Identify system name using SMSID

Hello All,

Looking for a help, I am getting the below message on one of the SCCM 2012 Primary server. From the below SMSID, I want to identify the problematic client. Is there any way I can do so?

"MP has rejected the request because CD(SMSID = 56AD2E95-7458-44F7-8418-395C7459E110) certificate has expired."

April 29th, 2015 4:48am

You can add the 'ID' column to the console.
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 5:08am

Have you read this post:

http://systemcenter.no/?p=1020

It seems to cover the same scenario, about clients unable to register.

Regards,

Stoyan

April 29th, 2015 5:12am

Fairly easy to do create a query.

  1. Browse to the monitoring workspace
  2. Right click queries and select "Create Query"
  3. Use the below screenshots as a reference:

From this you should be able to see the computer name in the result. It is important to include % and the start and end of the GUID search string.

Good luck and hopefully this will help.

Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 5:47am

Or you can use below SQL query

select Netbios_Name0 from v_R_System where SMS_Unique_Identifier0='GUID:XXXXX-XXXX-XXXXX-XXXXXXXX'


April 29th, 2015 5:56am

One last question, is SMSID and GUID same?
Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 8:53am

Should be. Just see if you got a match using one of the methods mentioned above.
April 29th, 2015 8:55am

Or you can use below SQL query

select Netbios_Name0 from v_R_System where SMS_Unique_Identifier0='GUID:XXXXX-XXXX-XXXXX-XXXXXXXX'


Free Windows Admin Tool Kit Click here and download it now
April 29th, 2015 9:52am

So what I did till now is -

1. I took the query from this link http://systemcenter.no/?p=1020 and ran it. Got a list of GUIDS.

2. Found the SMSID mentioned here in that list. "MP has rejected the request because CD(SMSID = 56AD2E95-7458-44F7-8418-395C7459E110) certificate has expired."

3. I had Put the SMSID in that query and ran it. "select Netbios_Name0 from v_R_System where SMS_Unique_Identifier0='GUID:56AD2E95-7458-44F7-8418-395C7459E110'"

4. Query ran successfully but did not give the client name.

April 29th, 2015 10:20am

Hi,

Please have a look at the similar thread below. It fixed the problem by edit the value of IsRevoked in ClientKeyData table from 1 to 0. Note, this is not supported by Microsoft.

https://social.technet.microsoft.com/Forums/en-US/3fd25d9d-3912-4b49-964c-fb94eedcea95/mp-has-rejected-policy-request-from-cdsmsid-because-this-smsid-is-marked-as-blocked?forum=configmanagergeneral

Best Regards,

Joyce

Free Windows Admin Tool Kit Click here and download it now
April 30th, 2015 1:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics