Monday, July 9, 2012

SCCM 2007 report to find client by GUID

I was getting a critical error in my SCCM 2007 R3 Component Status log as follows:

SMS_MP_CONTROL_MANAGER 5447 MP has rejected a policy request from GUID:XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX because it was not approved. The operating system reported error 2147942405: Access is denied.

I copied all the GUID information and created a report to search the database for a specific GUID as follows:

select * from v_R_System where v_R_System.SMS_Unique_Identifier0=@GUID

this SQL query includes a prompt for you to enter a single GUID, prompt info is as follows:

Name: GUID
Prompt text: Enter GUID
Default value: GUID: (this must be added as the query searches for the full value GUID:xxxxxxx-xxxx-xxxx-xxx-xxxxxxxx)

The report will provide the client hostname, after locating the client I attempted to delete the client from SCCM and let rediscovery find the client. After the client was rediscovered the issue resolved. Short and sweet!

1 comment: