Wake Up Type

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

 

Over the past several months there has been a lot of talk about “Wake on Lan”. This query will show how every PCs was booted at it last hardware inventory.

 

 

SELECT          Case GS.WakeUpType0

            when 0 then ‘Reserved’

            when 1 then ‘Other’

            when 2 then ‘Unknown’

            when 3 then ‘APM Timer’

            when 4 then ‘Modem Ring’

            when 5 then ‘LAN Remote’

            when 6 then ‘Power Switch’

            when 7 then ‘PCI PME#’

            when 8 then ‘AC Power Restored’

            else ‘Not Defined’ end AS ‘Wake Up Type’,

            Count(‘Wake Up Type’) AS ‘Count’

FROM             v_GS_COMPUTER_SYSTEM GS

GROUP BY GS.WakeUpType0

Order by ‘Wake Up Type’

Leave a Reply

Your email address will not be published. Required fields are marked *