United Kingdom Endpoint Management User Group

 View Only

How to create Site filters based off of manually created sites 

Feb 12, 2014 04:20 PM

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'

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

Jun 09, 2014 07:15 AM

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

 

Related Entries and Links

No Related Resource entered.