For full details please see:
http://www.myitforum.com/forums/SCCM-Report-question-m238232.aspx
SELECT DISTINCT CS.Name0 as 'PC', '' as 'Blank column1', BIOS.SerialNumber0 as 'SN #', CS.Manufacturer0 as 'Manufacturer', CS.Model0 as 'Model', '' as 'Blank column2', OS.Caption0 as 'OS', OS.CSDVersion0 as 'Service Pack', SCUM.TopConsoleUser0 as 'Top User', R.User_Name0 AS 'Last Logged (Heartbeat)', CS.UserName0 AS 'Last Logged (HW Inv.)', BIOS.ReleaseDate0 as 'Bios Date', NAC.IPAddress0 as 'IP', NAC.DefaultIPGateway0 as 'Gateway', '' as 'Blank column3', Case SE.ChassisTypes0 when '1' then 'Other' when '2' then 'Unknown' when '3' then 'Desktop' when '4' then 'Low Profile Desktop' when '5' then 'Pizza Box' when '6' then 'Mini Tower' when '7' then 'Tower' when '8' then 'Portable' when '9' then 'Laptop' when '10' then 'Notebook' when '11' then 'Hand Held' when '12' then 'Docking Station' when '13' then 'All in One' when '14' then 'Sub Notebook' when '15' then 'Space-Saving' when '16' then 'Lunch Box' when '17' then 'Main System Chassis' when '18' then 'Expansion Chassis' when '19' then 'SubChassis' when '20' then 'Bus Expansion Chassis' when '21' then 'Peripheral Chassis' when '22' then 'Storage Chassis' when '23' then 'Rack Mount Chassis' when '24' then 'Sealed-Case PC' else 'Undefinded' end as 'PC Type' FROM dbo.v_R_System R INNER JOIN dbo.v_GS_PC_BIOS BIOS ON R.ResourceID = BIOS.ResourceID INNER JOIN dbo.v_GS_COMPUTER_SYSTEM CS ON R.ResourceID = CS.ResourceID INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC ON R.ResourceID = NAC.ResourceID INNER JOIN dbo.v_GS_OPERATING_SYSTEM OS ON R.ResourceID = OS.ResourceID LEFT OUTER JOIN dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM ON R.ResourceID = SCUM.ResourceID INNER JOIN dbo.v_GS_SYSTEM S on R.ResourceID = S.ResourceID INNER JOIN dbo.v_GS_SYSTEM_ENCLOSURE SE on R.ResourceID = SE.ResourceID WHERE NAC.IPEnabled0 = 1 AND NAC.DefaultIPGateway0 Is NOT NULL AND S.SystemRole0 = 'Workstation' ORDER BY BIOS.ReleaseDate0