Windows way to Digital Learning……

Posts tagged ‘Non CM Client PCs Reporting’

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

SMSReporting

Advertisements

Tag Cloud