Duplicate SCCM GUIDS Query
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
July 15th, 2011 12:50pm
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
Free Windows Admin Tool Kit Click here and download it now
July 15th, 2011 2:38pm