Home > SCCM Reports > SCCM Reports – List of All Chasis Types

SCCM Reports – List of All Chasis Types


I found this helpful to understand the install base of certain chasis types.  You can also split this out to individual reports to isolate certain types.
 
select   Distinct sys.name0 as ‘Name’, sys.UserName0 as ‘User Name’, sys.manufacturer0 as ‘Manufacturer’, sys.model0 as ‘Model’, v_gs_pc_bios.serialnumber0,
        case enc.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 ‘Unknown’
        End As ‘Chassis’
from    v_gs_computer_system sys
inner join v_gs_system_enclosure enc on sys.resourceid=enc.resourceid
inner join v_gs_pc_bios on v_gs_pc_bios.resourceid=enc.resourceid
WHERE   sys.name0  LIKE @variable
order by ‘name’
Advertisements
Categories: SCCM Reports
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: