Custom Property on IP address

blmcguire

Hello,

I am trying to create a powershell script that will create an IP reservation and set a custom property on the IP address. The reservation portion is working. However the custom property is failing with the following error: Set-SwisObject : The given key was not present in the dictionary.

I am aware I need to create the field first and I have placed what I think is correct in the script.

Any help would be appreciated. My script is below:

Add-PSSnapin SwisSnapin -ErrorAction SilentlyContinue
$swis = Connect-Swis -Hostname 10.107.11.81 -Trusted
$ipaddr = Import-Csv -Path "\\sharent1\nshare\group#4\Powershell\IP-Reservations-SW-DHCPserver\new-ip-addresses.csv"       
foreach ($si in $ipaddr){
    $mac=$($si.mac)
    $ip=$($si.ip)
    $name=$($si.dhcpclientname)
    $custom=$($si.SFH_Description)
    $status=$($si.Status)

    Invoke-SwisVerb $swis IPAM.DhcpDnsManagement CreateIpReservation @($ip,"10.113.9.1",$name,$mac,"DhcpOnly")

    $IPtoIdQuery = "SELECT IpNodeId FROM IPAM.IPNode where IPAddress like '"+ $ip+"'"

    $IPAMNode =  Get-SwisData -SwisConnection $swis -Query $IPtoIdQuery
    Write-host $IPAMNode


    New-SwisObject $swis -EntityType 'IPAM.IPNodeAttr' -Properties @{ IPNodeId = $IPAMNode; }


    $CustomURI = 'swis://10.107.11.81/Orion/IPAM.IPNode/IpNodeId='+$IPAMNode+'/Custom'

    Set-SwisObject $swis -Uri $CustomURI -Properties @{ SFH_Description = $custom }


    Invoke-SwisVerb $swis IPAM.SubnetManagement ChangeIPStatus  @($ip, $status)

	}

shuth

Check the database table IPAM_Node for the IP address to determine the IPNodeID. Then check the IPAM_NodeAttrData table to see if that IPNodeID exists in that table. The IPAM_NodeAttrData table contains the custom property data.

e.g. SELECT * FROM IPAM_NodeAttrData WHERE IPNodeID = 1234

If the row doesn't return anything, the system cannot assign the custom property values. If this is what is happening, I'm not sure whether the IPs have to be added a certain way for the correlating row to be added to the IPAM_NodeAttrData table. I ran into this when importing a ton of subnets and then realising a whole bunch of them didn't import custom properties and the IPAM log was full of missing key errors. Super annoying as the web console doesn't indicate any errors as it happens.

All of these methods failed when trying to assign the custom property:

• Editing the IP via the web console
• Bulk import IP address data via the web console
• Manage Custom Properties - manually assigning custom property values
• Manage Custom Properties - import custom property data from spreadsheet

I had to find what subnets/IPs were missing, then delete and re-added those IPs manually in the web console. Not entirely useful method for you if you're trying to automate a bunch of stuff. You might be able to automate injecting the row into the database if it's missing...

This should give you a list of every IP address that is missing from the IPAM_NodeAttrData table.

SELECT * FROM IPAM_NodeAttrData
WHERE IPNodeID NOT IN (SELECT IPNodeID FROM IPAM_Node)

If the row does exist in the IPAM_NodeAttrData table, then I don't know...