SCCM report find computer name with SMS GUID:By Eswar KonetiJuly 14, 4:26 pm SCCM 2007 1 Min Read8,683 Views 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
