locked
Duplicate SCCM GUIDS Query RRS feed

  • Question

  • 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

    Thursday, July 14, 2011 4:52 PM

Answers

  • 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

    Wednesday, July 20, 2011 9:59 AM

All replies

  • This query should still work, although the article was written for SMS 2003: http://support.microsoft.com/kb/837374/en-us
    Torsten Meringer | http://www.mssccmfaq.de
    Thursday, July 14, 2011 6:40 PM
  • 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

    Wednesday, July 20, 2011 9:59 AM