How to create a collection of all approved clients

This collection will allow you to find machines that need approval.


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 :-)

4 comments:

Anonymous said...

This does not work. The query returns no results.

Anonymous said...

This worked for me creating a collection of Approved = N/A systems using the the

For Unknown
SMS_CM_RES_COLL_SMS00001.IsApproved= '2'

Thanks!

Anonymous said...

So great.
0 and 2 gave me the PCs I was looking for.
Thank you very much

Ryan Hogan said...

You don't need '' around the number.

Post a Comment