Query to List all the non CM Client PCs

To generate the report for the non Config Manager client PCs.

select
V_R_System.ResourceID,
V_R_System.ResourceType,
V_R_System.Name0,
V_R_System.SMS_Unique_Identifier0,
V_R_System.Resource_Domain_OR_Workgr0,
V_R_System.Client0
from
V_R_System
where
V_R_System.ResourceID not in (Select V_R_System.ResourceID from V_R_System where V_R_System.Client0 = 1)

 

Generated Report