Last week I enable a few attributes within the Computer System Class.


Going along the same theme as last few days Lets look at the Chassis Bootup State.


SELECT          Case GS.ChassisBootupState0

            when 1 then ‘Other’

            when 2 then ‘Unknown’

            when 3 then ‘Safes’

            when 4 then ‘Warning’

            when 5 then ‘Critical’

            when 6 then ‘Non-recoverable’

            else ‘Not Defined’ end AS ‘Chassis Bootup State’,

            Count(‘Chassis Bootup State’) AS ‘Count’


GROUP BY GS.ChassisBootupState0

Order by ‘Chassis Bootup State’