SELECT DISTINCT
    CS.Name0 as 'PC',
    BIOS.SerialNumber0 as 'SN #',
    CS.Manufacturer0 as 'Manufacturer',
    CS.Model0 as 'Model',
    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.)',



    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_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

    S.SystemRole0 = 'Workstation'
    AND SE.ChassisTypes0 in ( '8', '9', '10', '11', '12', '14', '18', '21' )
ORDER BY
    CS.Name0