If you have chosen to create your sites and subnets manually instead of importing them from AD, what is the easiest way to create filters that contain the computers associated with those sites?
The following query is one way of achieving this goal (another method would be to target the actual subnets contained in each site):
SELECT ip._ResourceGuid FROM Inv_AeX_AC_TCPIP ip JOIN vSubnet sub ON sub.Subnet = ip.Subnet JOIN vSiteSubnetMap map ON map.SubnetGuid = sub.[Guid] JOIN vSite s ON s.[Guid] = map._ResourceGuid WHERE s.Name = 'name of site'
Scott,
The query works well for me.
With a little amendment you could use is in the drill down report. In in level 1 counts by site , level 2 detailed computer info.
SELECT s.name as Site, count (distinct ip._ResourceGuid) as [PC counts]
FROM Inv_AeX_AC_TCPIP ip
JOIN vSubnet sub ON sub.Subnet = ip.Subnet
JOIN vSiteSubnetMap map ON map.SubnetGuid = sub.[Guid]
JOIN vSite s ON s.[Guid] = map._ResourceGuid
group by s.name
order by 2 desc