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


Today I am looking at the ThermalState mostly because I want to see what my new server has to say.


SELECT          Case GS.ThermalState0

            when 1 then ‘Other’

            when 2 then ‘Unknown’

            when 3 then ‘Safe’

            when 4 then ‘Warning’

            when 5 then ‘Critical’

            when 6 then ‘Non-recoverable’

            else ‘Not Defined’ end AS ‘Thermal State’,

            Count(‘Thermal State’) AS ‘Count’


GROUP BY GS.ThermalState0

Order by ‘Thermal State’