List all discovered devices which are not a client:
select Name0, Resource_Domain_Or_Workgr0, Operating_system_name_and0, AD_Site_Name0, Community_name0 from v_R_System Rwhere R.ResourceID Not in (Select CS.ResourceID From v_GS_Computer_System CS)Order by Name0
Great job dear, thanks for posting.
ReplyDeletePCEF on the Client Device