SCCM - Approve Clients Script

 You can find the archive here.


Step 1.

Create the following collection and criteria on your Top SCCM Server and name it per your naming standards

My Collection and Query are both named "All Unapproved Systems".

You will need to Replace YOURDOMAIN with your domain name..

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' and SMS_R_SYSTEM.ResourceDomainORWorkgroup = 'YOURDOMAIN'
 

Step 2.

Download the script, modify a few lines of code.

Line 85 = Add your Top SCCM Site Server here.

Line 86 = Add your Top SCCM Site Code here.