SCCM report find computer name with SMS GUID:

 

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

Prompt for GUID:

select SMS_Unique_Identifier0 from v_R_System

4 Responses to "SCCM report find computer name with SMS GUID:"

Leave a Reply