Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Setting up APIs (or SDK) for IPAM reservations

Hello,

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.

Find more posts tagged with

ipam

sdk

Accepted answers

All comments

RichardLetts

I think you have to call IPAM_spTouchSubnetCounts(@ids) and possibly IPAM_spTouchGroupCounts(@ids) to update the counters.

They both take the subnet ids you want to update the counters for as arguments

mr.e

Thanks, Richard. I forwarded your reply to our developers, so they'll update their SQL script accordingly. I will let you know how it goes. Thanks again.