I recently had a request for a report of what sites were assigned to what subnets. Is there a way of doing such a report?
This can be done through a SQL query. If you scope the report to individual sites yojll get a csv list of all the subnets with live assets within that site. For a more global report you could add dim_site to the query and add a column for the site it belongs to ideally.
with a as (select asset_id,concat(split_part(ip_address,‘.’,1),‘.’,split_part(ip_address,‘.’,2),‘.’,split_part(ip_address,‘.’,3),‘.0/24’) as network from dim_asset)
select distinct network from a