PENDING SMS_MP_CONTROL_MANAGER MP has rejected a message from Client GUID:xxxx

[bowlofBran]

Hello, I have one client that is causing SMS_MP_CONTROL_MANAGER to go into critical state. I have scoured the web trying to find out how to identify the rogue machine with no success. I've attempted WSQL queries and SQL queries but none are able to find the GUID in question. Is there anything else I can do to find this device and delete it? I've been beating my head on this for a while with no success. Any help would be greatly appreciated.

 

[Santhoshn4]

You may try to create a collection for collecting the duplicate system with NULL record use the below query:

Select R.ResourceID,R.ResourceType,R.Name,R.SMSUniqueIdentifier,R.ResourceDomainORWorkgroup,R.Client from SMS_R_System as r full join SMS_R_System as s1 on s1.ResourceId = r.ResourceId full join SMS_R_System as s2 on s2.Name = s1.Name where s1.Name = s2.Name and s1.ResourceId != s2.ResourceId and R.Client = null