I am hoping someone can help me with this query: SELECT dbo.SMS_G_System_SYSTEM.Name1, dbo.SMS_G_System_SYSTEM.SMSID, dbo.SMS_GH_System_SYSTEM.Name1 AS Expr1, dbo.SMS_GH_System_SYSTEM.SMSID AS Expr2, dbo.SMS_R_System.SMSAssignedSites FROM dbo.SMS_G_System_SYSTEM INNER JOIN dbo.SMS_GH_System_SYSTEM ON dbo.SMS_G_System_SYSTEM.ResourceID = dbo.SMS_GH_System_SYSTEM.ResourceID INNER JOIN dbo.SMS_R_System ON dbo.SMS_GH_System_SYSTEM.ResourceID = dbo.SMS_R_System.ResourceID

This query should still work, although the article was written for SMS 2003: http://support.microsoft.com/kb/837374/en-usTorsten Meringer | http://www.mssccmfaq.de

Hi, Can you try this WMI query for duplicate SCCM GUIDS: select * from sms_g_system_SYSTEM INNER JOIN sms_gh_system_SYSTEM on sms_g_system_SYSTEM.ResourceId = sms_gh_system_SYSTEM.ResourceId where sms_g_system_SYSTEM.Name <> sms_gh_system_SYSTEM.Name And the SQL query can be: select * from v_GS_System inner join v_HS_System on v_HS_System.ResourceID = v_GS_System.ResourceID where v_GS_System.Name0 <> v_HS_System.Name0 Thanks