SCCM report to list the Computer based on Given GUID

There are some warnings under component system for MP_control_manager bcz of client machine are not approved and MP is rejecting the policys that are requesting from the client (MP has rejected a policy request from GUID:d0400dcb-68a9-4b64-92af-daa70db2a53a because it was not approved. The operating system reported error 2147942405: Access is denied.) It might be difficult in finding a system in a large number of systems based on GUID.

Create a new report and paste the following qeury into the report:

Select
    Sys.Name0,
    Sys.SMSID0,
    Sys.Domain0,
    Sys.SystemRole0
from
    dbo.v_GS_SYSTEM Sys
Where
    Sys.SMSID0 = @GUID

Prompt:

select SMS_Unique_Identifier0 from v_R_System