I have successfully run the following query that provides me with available ip addresses of interfaces that are part of a specific subnet:
SELECT TOP 2 I.DisplayName FROM IPAM.IPNode I WHERE Status=2 and Subnetid=370
I now need to run a query to find the subnetids present at a specific location, however, I am unable to find the correct source for this information. I have tried IPAM.GroupNode IPAM.GroupReport etc.
but with no success. Does anyone have an idea of where this information is stored?
Thanks in advance.