Hello,
I created a report using the following query:
select * from IPAM_Group g
join IPAM_GroupAttrData d on g.GroupId = d.GroupId
where g.GroupType='8'
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!