Import-IpamAddress

Syntax

Import-IpamAddress
      [-Path] <String>
      [-AddressFamily] <String>
      [-ErrorPath <String>]
      [-Force]
      [-Confirm]
      [-WhatIf]

Import-IpamAddress
      [-Path] <String>
      [-AddressFamily] <String>
      [-ManagedByService] <String>
      [-ServiceInstance] <String>
      [-NetworkId] <String>
      [-EndIPAddress <IPAddress>]
      [-ErrorPath <String>]
      [-Force]
      [-StartIPAddress <IPAddress>]
      [-Confirm]
      [-WhatIf]

Description

The Import-IpamAddress cmdlet imports one or more IP address objects from the specified comma-separated values (.csv) file into the computer running the IP Address Management (IPAM) server. Any objects that fail being imported during the operation are logged in the appropriate error log file for further analysis.

The cmdlet supports two parameter sets. The default invocation of the cmdlet adds new IP address objects from the .csv file into the computer running the IPAM server and edits the existing address objects with updated information specified in the .csv file.

The second parameter set can be used to periodically import and update all of the IP address objects that belong ,or map, to the IP address range identified by the unique combination of the NetworkId, ManagedByService, ServiceInstance, StartIPAddress, and EndIPAddress parameters, in the computer running the IPAM server. Along with adding new addresses and editing existing addresses, this operation also deletes those addresses from the computer running the IPAM server which map to the specified IP address range, but are not present in the .csv file being imported. If not specified, then the computer running the IPAM server auto calculates the StartIPAddress and EndIPAddress parameter values, at the default address boundaries of the range as specified by the NetworkId parameter. If explicitly specified, then both the StartIpAddress and EndIpAddress parameter values must be provided together. The import and update operation of IP addresses for the IP address range succeeds only if the range is already present in the computer running the IPAM server at the time of import.

The only mandatory field required to be present in the .csv file being imported for IPAM addresses is the IP address itself. Any other address specific basic field or custom field can be specified in any order in the .csv file for import. Sample format of the import .csv file, can be generated using IPAM export functionality from IPAM UI (localized format) or IPAM Windows PowerShell® (English format).

Note: The IPAM Windows PowerShell import supports both the English as well as the server localized .csv file. The computer running the IPAM server uses the presence of the field name IPAddress (without spaces) in the .csv file to determine that the file must be processed in English format. Otherwise the .csv file is processed in the server localized format for the various field names and enumeration values. The format of date and time values of the imported objects are always interpreted in the localized format of the computer running the IPAM server and not in UTC.

Examples

EXAMPLE 1

PS C:\>Import-IpamAddress -AddressFamily IPv4 -Path "C:\addressv4.csv" -Force

This example imports the IPv4 addresses from the file C:\addressv4.csv into the computer running the IPAM server. The new addresses are added and existing addresses are edited. The errors, if any, are recorded in the Documents folder of the user in .csv file format. The default confirmation text is suppressed in this example.

EXAMPLE 2

PS C:\>Import-IpamAddress -AddressFamily IPv4 -Path "C:\addressv4.csv" -ErrorPath "C:\" -Force

This example imports IPv4 addresses from the file C:\addressv4.csv into the computer running the IPAM server. The new addresses are added and existing addresses are edited. The errors, if any, are recorded in .csv file format at the path C:. The default confirmation text is suppressed in this example.

EXAMPLE 3

PS C:\>Import-IpamAddress -AddressFamily IPv4 -Path "C:\addressupdatev4.csv" -ManagedByService "IPAM" -ServiceInstance "localhost" -NetworkId 10.10.10.0/24
Confirm 
 
Imports a csv file as an update of all IP address records that belong to the specified IP address range. Along with adding new addresses and editing existing addresses, this operation also deletes addresses belonging to the specified IP address range from IPAM database, that are not present in the csv file update being imported. 
 
 
Continue with this operation? 
 
[Y] Yes  [N] No  [?] Help  :Y

This example imports and updates all of the IPv4 addresses belonging to the range specified by the network ID 10.10.10.0/24, the managing service IPAM, and the service instance Localhost, from the file C:\addressupdatev4.csv into the computer running the IPAM server. The starting IP address and ending IP address of the range are automatically calculated as 10.10.10.1 and 10.10.10.254 respectively since the values are not explicitly specified. The new addresses are added, existing addresses are edited, and addresses belonging to the specified range, which are not in the .csv file, are deleted from the computer running the IPAM server. The errors, if any, are recorded in the documents folder of the user in .csv file format. Note: By default, host IDs that contain all zeros (0) and all ones (1) are skipped for IPv4 address ranges while calculating the starting and ending IP address.

EXAMPLE 4

PS C:\>Import-IpamAddress -AddressFamily IPv4 -Path "C:\addressupdatev4.csv" -ManagedByService "IPAM" -ServiceInstance "localhost" -NetworkId 10.10.10.0/24 -StartIpAddress 10.10.10.1 -EndIpAddress 10.10.10.50 -Force

This example imports and updates all of the IPv4 addresses belonging to the range specified by the network ID 10.10.10.0/24, the starting IP address 10.10.10.1, the ending IP address 10.10.10.50, the managing service IPAM, and the service instance Localhost, from the file C:\addressupdatev4.csv into the computer running the IPAM server. The new addresses are added, existing addresses are edited, and addresses belonging to the specified range, which are not in the .csv file, are deleted from the computer running the IPAM server. The errors, if any, are recorded in the Documents folder of the user in .csv file format. The default confirmation text is suppressed in this example.

Parameters

-AddressFamily

-Confirm

-EndIPAddress

-ErrorPath

-Force

-ManagedByService

-NetworkId

-Path

-ServiceInstance

-StartIPAddress

-WhatIf

Inputs

None

Outputs

String

A detailed summary of the steps performed by this cmdlet. The message can be one of the following: Import of \<AddressFamily\> objects is complete. \<y\> out of \<y\> objects successfully imported.\<AddressFamily\>\<y\>\<y\>

OR Import of \<AddressFamily\> objects is complete. \<x\> out of \<y\> objects successfully imported. \<z\> out of \<y\> objects failed to get imported. Failures recorded in the file: \<ErrorFilename\>\<AddressFamily\>\<x\>\<y\>\<z\>\<y\>\<ErrorFilename\>

Related Links

• Export-IpamAddress