Friday 18 December 2009

List all discovered devices which are not a client

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

1 comment: