I created a report using the following query:
select * from IPAM_Group g
join IPAM_GroupAttrData d on g.GroupId = d.GroupId
order by d.Site, d.Category;
we had to try out a few times until we found out that GroupType=8 are subnets, otherwise dhcp-servers,folders,… were displayed in the report as well!
But we don't only want to see usual subnets but also supernets, but we can't find out what GroupType-where clause we need to use!
You may see the details of Each group type in IPAM_GroupType table
Pasting the IPAM_grouptype table information below
32 DHCP Server
64 DHCP Scope
128 IPv6 Global Prefix
256 IPv6 Site
512 IPv6 Subnet
1024 Dns Server
2048 Dns Zone
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.