Filtering the Approval status of clients in collections in ConfigMgr 2007
I’ve been trying to figure out how to filter out approved and non-approved clients in SCCM. Thanks to David Downs for providing this collection Query information.
Just create a collections and choose system resources then change it to query view and paste in this code.
*****************************************
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 inner join SMS_CM_RES_COLL_SMS00001 on SMS_CM_RES_COLL_SMS00001.ResourceId = SMS_R_System.ResourceId
where SMS_CM_RES_COLL_SMS00001.IsApproved= '0'
******************************************
This query can provide 3 different results:
0 = Not Approved
1 = Approved
2 = N/A