Hi,

Obsolete0 is only available on SMS 2003 with SP1.  You can get the same results if you just remove that portion of the query.

Here is the modified query:

SELECT     dbo.v_R_System.Name0, dbo.v_R_System.Resource_Domain_OR_Workgr0, dbo.v_R_System.Client0
FROM         dbo.v_R_System INNER JOIN
                      dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_R_System.ResourceID INNER JOIN
                      dbo.v_FullCollectionMembership ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_FullCollectionMembership.ResourceID
WHERE     (dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0 = 'Dell Computer Corporation') AND (dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX150' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX50' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX60' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX400' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX240' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX260' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX270' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex SX260' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex SX270' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex GX280' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'OptiPlex SX280' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C600' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C800' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C500' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C610' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C810' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C400' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C840' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C510' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude L400' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude X200' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude C540' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D600' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D800' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D500' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude D400' OR
                      dbo.v_GS_COMPUTER_SYSTEM.Model0 = 'Latitude X300') AND (dbo.v_R_System.Client0 = 1) AND v_FullCollectionMembership.CollectionID = @ID