This is a good day! I have managed to fix a thing that has been a big problem at some SCCM 2007 customers. Clients are getting Approved N/A status even if everything looks ok and should work.
I have seen big complicated scripts that will change the status but today I found the most powerful and simple way to fix it.
First, go to your SCCM site where the clients are and create a new SQL Command.
Name:
ApproveAllClients
SQL command:
UPDATE v_CM_RES_COLL_SMS00001
SET IsApproved=1
FROM v_CM_RES_COLL_SMS00001
INNER JOIN v_R_System
ON v_CM_RES_COLL_SMS00001.ResourceID = v_R_System.ResourceID
WHERE v_CM_RES_COLL_SMS00001.IsApproved<>1
Log status to:
\c$\temp\ApproveAllClients.log">\\<siteserver>\c$\temp\ApproveAllClients.log
I found this solution at MyItforum so thank you sooo much!! Link:
http://myitforum.com/myitforumwp/2011/11/10/configmgr-auto-approve-clients-the-easy-way/