2 Replies Latest reply on Dec 1, 2014 11:15 AM by mr.e

    Setting up APIs (or SDK) for IPAM reservations




      One of our teams is trying to create an applet that will assign IP address reservations directly to the IPAM tables.  His script is as follows:

      UPDATE IPAM_Node Set Status = 1, Description = 'Assigned by Automation'

      WHERE IPAddress = 'xxx.xxx.xxx.xxx'


      Also, the script below is designed to flag IP addresses as Avalable.


      SELECT R.Address as SubnetAddress, R.CIDR, R.FriendlyName, R.PercentUsed,

      (SELECT TOP 1 I2.IpAddress FROM IPAM_Node as I2 WITH (NOLOCK) WHERE I2.Status=2 AND I2.SubnetId = R.GroupID ) AS FreeIpAddress

      FROM IPAM_Group as R WITH (NOLOCK)

      WHERE R.GroupType='8' AND R.Address LIKE 'xxx.xxx.xxx.%'

      The script seemed to work fine at first, with the required IP address showing as Used.  However, when I look at the subnet utlization, it shows 0 IP's used.  So, it seems that the there is another table that needs to be update.  Do any of you know which additional table(s) need to be updated as well?  Thanks in advance.