Export-IpamAddress

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: Default
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.

-Force

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

-PassThru

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

-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.

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see    about_CommonParameters (https://go.microsoft.com/fwlink/p/?LinkID=113216).

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

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" }

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

Related topics

Import-IpamAddress

Export-Csv

Where-Object