hello,
i am trying to query the IPAM database and get a list of all IP addresses. i would also need the city for each of the IP Address. i see a column called City in IPAM_GroupAttrData, but there is no groupID column in the IPAM_node table to map these through a join. i am wondering how i can get this information, as for sure there has to be a way. The UI shows a tree of all cities and shows IP addresses inside each of the cities. sso wondereing from where the UI is fetching data to assign a city to an IP address?
any help is greatly appreciated.