Friday, November 22

Browsing: GUID

CM2012

SCCM Configmgr collection SQL identify duplicate computer records with different GUID

By Eswar KonetiMay 31, 4:37 pm3 Mins Read31,068 Views

I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with…

SCCM report find computer name with SMS GUID:

By Eswar KonetiJuly 14, 4:26 pm1 Min Read8,783 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