not clear on what you mean - display group?
You could always do a custom property, but that would be manual...
how did you define the other display groups. give example of properties or columns used to define and I might be able to help :)
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
WHERE grouptype=2 and percentused>=50
note if you are using supernet "groups" that is grouptype=4