I have a couple of display groups defined and want to do a report query where the records exist only in one display group. Does anyone know the SQL property for the IPAM Display Group?
I don't know. On the IPAM main screen, I have defined a few display groups of ip addresses. I know I can determine the SQL properties of an indivisual subnet (Subnet.Address, Subnet.Location, etc.).
I just don't know if there is a SQL property for the groups.
I would like to do a query along the lines of
Subnet.Group like "NetA" AND Subnet.PercentUtilized > 50
ah, I gotcha..so you've grouped IP Subnets on right into a "folder/group" on the left pane correct? so there are several different options here...
in the IPAM_Group table, you have columns (groupid, parentid, grouptype, friendlyname) plus others.
grouptype = 2 should identify as a group. you could also validate by using (friendlyname) which is the name of the group.
in that same table, you have a column (percentused).
so your query would look something like this if you just wanted a report of all groups with > 50% usage:
SELECT friendlyname, comments, usedcount, availablecount, percentused
FROM IPAM_Group
WHERE grouptype=2 and percentused>=50
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.