Monday, March 05, 2012

SCCM SQL Count of 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 'Chassis 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
'Chassis Type'

No comments :

Post a comment