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