Chassis type

SELECT
Case v_GS_SYSTEM_ENCLOSURE.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’,
Count(v_GS_SYSTEM_ENCLOSURE.ChassisTypes0) AS ‘Total’
FROM
v_GS_SYSTEM_ENCLOSURE v_GS_SYSTEM_ENCLOSURE
GROUP BY
v_GS_SYSTEM_ENCLOSURE.ChassisTypes0
Order by
‘PC Type’

Leave a Reply

Your email address will not be published. Required fields are marked *