IPAM license question

Question

Hi All,

I am getting this warning that I am running low on licenses and I for the life of me can't seem to figure out what table from the SQL database this is pulling. I want to see if I am really getting low of available licenses of if I just need to clean up some. So if you anyone could tell me what table to look into that would be a big help

Thanks Pat

IP Address Manager v4.3  IP Addresses93.95% used monitoring 3848/4096

maryan.dmytriv · Answer

I would recommend uprading to just released 4.6 version. Also asked query you can find in c:\Program Files (x86)\SolarWinds\Orion\Modules\IPAM.xml

SELECT COUNT(ipNodeId) AS  IpNodeCount FROM IPAM.IPNode AS N INNER JOIN (SELECT DISTINCT GroupId, GroupType, AddressN, AddressEnd FROM IPAM.GroupReport) AS G ON N.SubnetId = G.GroupId AND (G.GroupType != 8 OR N.IPAddressN NOT IN (G.AddressN, G.AddressEnd)) WHERE G.GroupType IN (8, 512) AND G.GroupId != 1 AND N.Status != 2

sfp · Answer

Bump up ;-)

so what is SQL query to do the calculations done by license management?

It would be great to see such parameter on some Capacity dashboard.

michal.hrncirik​ maybe You can help us?

isuguy · Answer

Check how many reserved ips you have.  The current number of used ips addresses doesnt seem to include ones that are set to reserved.