How to write a Query for Filter the SCCM Agent 0 Devices

You can use the following query to identify the SCCM Agent Not installed devices.

select

SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,

SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup,

SMS_R_SYSTEM.Client from sms_r_system   where Client = 0
or Client is null

Advertisements