This collection will allow you to find machines that need approval.
For Is Approved
Replace this section for not approved and unknown:
For not approved
For Unknown
I did not write this collection, I will be glade to give credit to whom ever it was :-)
For Is Approved
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= '1'
Replace this section for not approved and unknown:
For not approved
SMS_CM_RES_COLL_SMS00001.IsApproved= '0'
For Unknown
SMS_CM_RES_COLL_SMS00001.IsApproved= '2'
I did not write this collection, I will be glade to give credit to whom ever it was :-)