Export (0) Print
Expand All

Export-IpamAddress

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Export-IpamAddress

Exports all of the IP addresses of the specified address family from the computer running the IP Address Management (IPAM) server as a comma-separated value (.csv) file or as an array of Windows PowerShell® objects or both.

Syntax

Parameter Set: __AllParameterSets
Export-IpamAddress [-AddressFamily] <String> [-Force] [-PassThru] [-Path <String> ] [ <CommonParameters>]




Detailed Description

The Export-IpamAddress cmdlet exports all of the IP addresses of the specified address family from the computer running the IP Address Management (IPAM) server as a comma-separated value (.csv) file or as an array of Windows PowerShell® objects or both.

Either the Path or PassThru parameter must be specified with the cmdlet. The object array returned using PassThru parameter can be pipelined for further filtering, if required. The Force parameter can be used with the cmdlet, to overwrite an existing .csv file with the same name as specified in the Path parameter, during export.

Unlike the localized object export from computer running the IPAM client user interface (UI), the field header names and the enum value names of IP address objects exported by Windows PowerShell have English names and are not be localized in the language used by the server. The field header names follow the Windows PowerShell property naming conventions.

Note: The format of date and time values of the exported objects are in the localized format of the computer running the IPAm server and not in UTC.

The IPAM client UI and IPAM Windows PowerShell support interoperability between import and export functionality of English and localized .csv files, provided that the language and locale of the computers running the IPAM server and associated UI that are importing and exporting are the same. In other words a localized .csv file exported from the computer running the IPAM client UI can be imported using IPAM Windows PowerShell and an English .csv file exported from IPAM Windows PowerShell can be imported from computer running the IPAM client UI provided the language and locale of the computers running the IPAM client and IPAM server are the same.

Parameters

-AddressFamily<String>

Specifies the address family of the IP address objects being exported. The acceptable values for this parameter are: IPv4 or IPv6.
This parameter specifies if IPv4 or IPv6 records need to be exported. Only one address family at a time can be specified with this cmdlet.


Aliases

none

Required?

true

Position?

2

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

-Force

Specifies that the new .csv file generated by export must overwrite the existing .csv file (if present), as specified in the Path parameter.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-PassThru

Returns an object representing the item with which you are working. By default, this cmdlet does not generate any output.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

false

Accept Wildcard Characters?

false

-Path<String>

Specifies the literal path and name of the .csv file which are created during export.
This parameter is used to export all IP address objects in a .csv file format.


Aliases

none

Required?

false

Position?

named

Default Value

none

Accept Pipeline Input?

True (ByPropertyName)

Accept Wildcard Characters?

false

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters.

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

  • None

Outputs

The output type is the type of the objects that the cmdlet emits.

  • Microsoft.Windows.Ipam.Commands.IpamIPAddressPSObject[]

    This array of objects contains IPAM IP addresses.


Examples

EXAMPLE 1

This example outputs all of the IPv4 addresses in the file C:\addresses_v4.csv.


PS C:\> Export-IpamAddress -AddressFamily IPv4 -Path "C:\addresses_v4.csv"

EXAMPLE 2

This example outputs all of the IPv6 addresses in the file C:\addresses_v6.csv, and overwrites the file if it already exists.


PS C:\> Export-IpamAddress -AddressFamily IPv6 -Path "C:\addresses_v6.csv" -Force

EXAMPLE 3

This example outputs all of the IPv4 address objects.


PS C:\> Export-IpamAddress -AddressFamily IPv4 -PassThru
IPAddress       IPAddressState    AssignmentType   ManagedByService    ServiceInstance 
---------       --------------    --------------   ----------------    --------------- 
2.2.2.15        In-Use            Static           IPAM                Localhost 
10.10.0.10      In-Use            Static           IPAM                Localhost 
12.13.14.15     Reserved          Dynamic          MS DHCP             s2-infra.contoso.com 
5.5.0.1         Reserved          Dynamic          MS DHCP             s2-infra.contoso.com 

EXAMPLE 4

This example filters all of the expired IPv4 address objects.


PS C:\> Export-IpamAddress -AddressFamily IPv4 -PassThru | Where-Object -FilterScript { $_.ExpiryStatus -Eq "Expired" }
IPAddress       IPAddressState    AssignmentType   ManagedByService    ServiceInstance 
---------       --------------    --------------   ----------------    --------------- 
2.2.2.15        In-Use            Static           IPAM                Localhost 

EXAMPLE 5

This example filters all of the expired IPv4 address objects and exports those objects into the file C:\expired.csv.


PS C:\> Export-IpamAddress -AddressFamily IPv4 -PassThru | Where-Object -FilterScript { $_.ExpiryStatus -Eq "Expired" } | Export-Csv –Path "C:\expired.csv"

EXAMPLE 6

This example outputs all of the IPv4 addresses in the file C:\addresses.csv and also displays the exported addresses.


PS C:\> Export-IpamAddress -AddressFamily IPv4 -Path C:\addresses.csv -PassThru
IPAddress       IPAddressState    AssignmentType   ManagedByService    ServiceInstance 
---------       --------------    --------------   ----------------    --------------- 
2.2.2.15        In-Use            Static           IPAM                Localhost 
10.10.0.10      In-Use            Static           IPAM                Localhost 
12.13.14.15     Reserved          Dynamic          MS DHCP             s2-infra.contoso.com 
5.5.0.1         Reserved          Dynamic          MS DHCP             s2-infra.contoso.com 

Related topics

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft