none
Creating a Chassis Type Lookup Table In SCCM DB

    Question

  • While running through reports containing the Chassis Type values (24 different integers) with a colleague, he pointed out that a simple table created in the SCCM DB (or at least on the same DB server, perhaps a different DB) would provide a simple lookup, so instead SCCM reports would show the actual Chassis Type (listed below).

    This would be extremely helpful to us with reports which are passed on to our customers.

    Can someone give me/our DBA a rough idea of how to set this up so that we can post instructions so that other users can benefit from it?  It seems very odd that users have to go to these lengths!!

    Thanks in advance

     

    Value Description
    1 Other
    2 Unknown
    3 Desktop
    4 Low Profile Desktop
    5 Pizza Box
    6 Mini Tower
    7 Tower
    8 Portable
    9 Laptop
    10 Notebook
    11 Hand Held
    12 Docking Station
    13 All in One
    14 Sub Notebook
    15 Space-Saving
    16 Lunch Box
    17 Main System Chassis
    18 Expansion Chassis
    19 Sub Chassis
    20 Bus Expansion Chassis
    21 Peripheral Chassis
    22 Storage Chassis
    23 Rack Mount Chassis
    24 Sealed-Case PC

    Monday, September 20, 2010 2:15 PM

Answers

  • It's just as easy to add it into the select statement of the individual reports you use for chassis type.

     

    SELECT     TOP 100 PERCENT 'Chassis Type' = enc.ChassisTypes0,
                          'Chassis Name' = CASE enc.ChassisTypes0
                           WHEN '1' THEN 'Other' WHEN '2' THEN 'Unkown'
                           WHEN '3' THEN 'Desktop' WHEN '4' THEN 'LowProfileDesktop'
                           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 Chassis' WHEN '16' THEN 'Lunch Box'
                           WHEN '17' THEN 'Main System  Chassis' WHEN '18' THEN 'Expansion Chassis'
                           WHEN '19' THEN 'Sub Chassis' WHEN '20' THEN 'Bus Expansion Chassis'
                           WHEN '21' THEN 'Peripheral Chassis' WHEN '22' THEN 'Storage Chassis'
                           WHEN '23' THEN 'Rack Mounted Chassis' WHEN '24' THEN 'Sealed  CASE PC'
                           WHEN '25' THEN 'Tablet -PC'


    John Marcum | http://myitforum.com/cs2/blogs/jmarcum |
    Monday, September 20, 2010 2:48 PM
    Moderator
  • So it is unsupported to edit the db like this.

     

    However this is a good suggestion and I recommend that you post/make the suggestion on the connect site. http://connect.microsoft.com/ This is the only way it will get implemented.

     

    BTW post a link to the suggestion so that everyone can vote it up.

     

     


    http://www.enhansoft.com/
    Monday, September 20, 2010 5:13 PM
    Moderator

All replies

  • It's just as easy to add it into the select statement of the individual reports you use for chassis type.

     

    SELECT     TOP 100 PERCENT 'Chassis Type' = enc.ChassisTypes0,
                          'Chassis Name' = CASE enc.ChassisTypes0
                           WHEN '1' THEN 'Other' WHEN '2' THEN 'Unkown'
                           WHEN '3' THEN 'Desktop' WHEN '4' THEN 'LowProfileDesktop'
                           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 Chassis' WHEN '16' THEN 'Lunch Box'
                           WHEN '17' THEN 'Main System  Chassis' WHEN '18' THEN 'Expansion Chassis'
                           WHEN '19' THEN 'Sub Chassis' WHEN '20' THEN 'Bus Expansion Chassis'
                           WHEN '21' THEN 'Peripheral Chassis' WHEN '22' THEN 'Storage Chassis'
                           WHEN '23' THEN 'Rack Mounted Chassis' WHEN '24' THEN 'Sealed  CASE PC'
                           WHEN '25' THEN 'Tablet -PC'


    John Marcum | http://myitforum.com/cs2/blogs/jmarcum |
    Monday, September 20, 2010 2:48 PM
    Moderator
  • So it is unsupported to edit the db like this.

     

    However this is a good suggestion and I recommend that you post/make the suggestion on the connect site. http://connect.microsoft.com/ This is the only way it will get implemented.

     

    BTW post a link to the suggestion so that everyone can vote it up.

     

     


    http://www.enhansoft.com/
    Monday, September 20, 2010 5:13 PM
    Moderator
  • I notice John came up with a Chassis Type of 25, Tablet...I don't see that listed in the MSDN WMI/CIM documentation, http://msdn.microsoft.com/en-us/library/windows/desktop/aa387204(v=vs.85).aspx?) ...  IS there a Chassis Type of 25 = Tablet, and, if so, what's the source documentation on Chassis types?

    Thanks!

     

    Thursday, April 18, 2013 7:08 PM
  • I honestly don't know where I stole that list from. :-)

    John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/

    Thursday, April 18, 2013 7:22 PM
    Moderator
  • <G>  I found another thread, where it has Chassis Type 65 (am assuming typo) as "tablet"...<G>

    Thanks.  I have nothing higher than 24 in my DB, anyway...

    Thursday, April 18, 2013 7:55 PM
  • I just looked up in the standard doc and 25, which is the highest number,  25 = Multi-system Chassis.

    FYI my surface have a Chassis type of 11. Soooo... There is no easy way to determine that a device is a tablet.  At least not using Chassis type.


    http://www.enhansoft.com/

    Thursday, April 18, 2013 10:01 PM
    Moderator
  • Surface computers are Chassis Type 26...<G>

    BTW...where IS the standard doc?  I found the MSDN documentation, but, know there is a CIM (or something) site?

    And, what is it that makes a system report as a certain Chassis Type?  I have a site with 40 Motion Computer C5v Tablets (and, they ARE Tablets, and all the same).  Some have WinXP SP3, some Win7 SP1.  About 3/4 of each OS has Chassis Type 10 (Notebook) 1/4 of each OS Chassis Type 3 (Desktop).  No difference in computers, BIOS, version of OS, applications (minimal and identical except Office 2007 on XP, 2010 on Win7) and all done at same time with same image (of either OS).

    Thanks.

    Thursday, April 18, 2013 10:17 PM
  • Surface computers are Chassis Type 26...<G>

    BTW...where IS the standard doc?  I found the MSDN documentation, but, know there is a CIM (or something) site?

    And, what is it that makes a system report as a certain Chassis Type?  I have a site with 40 Motion Computer C5v Tablets (and, they ARE Tablets, and all the same).  Some have WinXP SP3, some Win7 SP1.  About 3/4 of each OS has Chassis Type 10 (Notebook) 1/4 of each OS Chassis Type 3 (Desktop).  No difference in computers, BIOS, version of OS, applications (minimal and identical except Office 2007 on XP, 2010 on Win7) and all done at same time with same image (of either OS).

    Thanks.

    Motions? YUCK! You work in Healthcare? I found that nothing on Motions very standardized.


    John Marcum | http://myitforum.com/myitforumwp/author/johnmarcum/

    Friday, April 19, 2013 3:22 PM
    Moderator
  • Great minds...<G>

    Guilty, Veterans Affairs.

    Friday, April 19, 2013 3:40 PM
  • Wouldn't it be nice if they finally updated the standard for chassis type adn the manufacturer followed it correctly! The last update looks like 2006.

    The standard docs can be found at http://www.dmtf.org/ it took a bit of digging to find it. I don't have the direct link to it, but I do have the zip file that has the standard (MOF) listed.


    http://www.enhansoft.com/

    Friday, April 19, 2013 4:35 PM
    Moderator
  • Thanks, Garth!
    Friday, April 19, 2013 5:36 PM
  • HI John

    when we run the query we are getting value 2 which is unknown so what we have to understand from this statement "unknown". this value is coming for SUN servers so please explain.

    Friday, December 26, 2014 5:49 AM
  • HI John

    when we run the query we are getting value 2 which is unknown so what we have to understand from this statement "unknown". this value is coming for SUN servers so please explain.


    There is nothing to know. Sun computers have define their chassis type as 2. If you want more details as to why Sun has done this, you need to talk to then.

    Garth Jones | My blogs: Enhansoft and Old Blog site | Twitter: @GarthMJ

    • Proposed as answer by SPV4645 Tuesday, January 13, 2015 11:18 AM
    Friday, December 26, 2014 10:54 AM
    Moderator