For Desktops only report SELECT TOP (100) PERCENT dbo.v_R_System.Name0 AS [Computer Name], dbo.v_R_System.User_Name0 AS [User Name],
dbo.v_R_System.User_Domain0 AS [Domain Name], dbo.v_GS_SYSTEM_ENCLOSURE.Manufacturer0 AS Manufacturer,
dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model, dbo.v_GS_SYSTEM_ENCLOSURE.SerialNumber0 AS [Serial Number],
dbo.v_GS_SYSTEM.SystemRole0 AS [System OS Type], dbo.v_GS_SYSTEM.SystemType0 AS [System Type]
FROM dbo.v_GS_SYSTEM_ENCLOSURE INNER JOIN
dbo.v_R_System ON dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID = dbo.v_R_System.ResourceID INNER JOIN
dbo.v_GS_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_SYSTEM.ResourceID INNER JOIN
dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_GS_SYSTEM.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID
WHERE (dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = ‘3’) OR
(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = ‘4’) OR
(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = ‘5’) OR
(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = ‘6’) OR
(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = ‘7’) OR
(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = ’15’) OR
(dbo.v_GS_SYSTEM_ENCLOSURE.ChassisTypes0 = ’16’)
ORDER BY [Computer Name]
