List all discovered devices which are not a client

This query will display all devices (PCs, routers, etc.) that ConfigMgr / SMS knows about which are not clients.

select
Name0,
Resource_Domain_Or_Workgr0,
Operating_system_name_and0,
AD_Site_Name0,
Community_name0
from
v_R_System R
where
R.ResourceID Not in
  (Select
   CS.ResourceID
  From
   v_GS_Computer_System CS)
Order by
Name0

Leave a Reply

Your email address will not be published. Required fields are marked *