SCCM Configmgr collection SQL identify duplicate computer records with different GUID
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…