GUID – All about Microsoft Endpoint Manager

Tuesday, 21 March 2023

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

Posted on May 31, 2019 by Eswar Koneti | 1 Comment | 25,866 Views

I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with different GUID ID and resource ID but with same hostname. So i started looking at this issue to see how identify the records with duplicate hostnames. SCCM clients are uniquely identified by a GUID. A…

SCCM report find computer name with SMS GUID:

Posted on July 14, 2009 by Eswar Koneti | 4 Comments | 7,766 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