Wednesday, 18 March 2015

SCCM report to list the Computer based on Given GUID

Came Across with Error

MP has rejected a policy request from GUID:xxxxxxxxxxxxxxxxxxxxxxxxxxxx  because it was not approved. The operating system reported error 2147942405: Access is denied.

 

To identify non approved computers for particular GUID Create the custom reports with below query

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

Prompt:

Note : Mention the Name of prompt GUID

select SMS_Unique_Identifier0 from v_R_System

No comments:

Post a Comment