Month – March 2007

Thermal State

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 […]

Win32_Bios aka PC Bios

Just like the Computer System class I enable all attributes of this class. These are the attributes that I enabled.   BiosCharacteristics Caption CodeSet CurrentLanguage IdentificationCode InstallableLanguages InstallDate LanguageEdition ListOfLanguages OtherTargetOS PrimaryBIOS SMBIOSMajorVersion SMBIOSMinorVersion SMBIOSPresent Status   With the information included in the article http://msdn2.microsoft.com/en-us/library/aa394077.aspx, we should get some interesting information from our systems.  

Hottest ticket in San Deigo

On Monday night I was helping out at the SMS Expert booth and I got to witness the on slot of people trying to get buttons to the myITForum party. The funny part about this was to see the reaction of the other vendors trying to figure out why there was a mad rush to […]

Bootup State

This query will show you the state in which each PC Booted. The normal options are: “Normal boot”“Fail-safe boot”“Fail-safe with network boot”   Based on the Win32_computer_system class: http://msdn2.microsoft.com/en-us/library/aa394102.aspx     SELECT v_GS_COMPUTER_SYSTEM.Name0 AS ‘PC Name’, v_GS_COMPUTER_SYSTEM.UserName0 AS ‘User ID’, v_GS_COMPUTER_SYSTEM.BootupState0 AS ‘Boot State’ FROM            v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM ORDER BY v_GS_COMPUTER_SYSTEM.Name0  

Chassis Bootup State

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’             […]

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’             […]

Auto Reboot

This query will show you which PCs are set to automatically reboot. Based on the Win32_computer_system class: http://msdn2.microsoft.com/en-us/library/aa394102.aspx     SELECT          v_GS_COMPUTER_SYSTEM.Name0 AS ‘PC Name’,             v_GS_COMPUTER_SYSTEM.UserName0 AS ‘User ID’,             Case v_GS_COMPUTER_SYSTEM.AutomaticResetBootOption0             When 1 then ‘True’             When 0 then ‘False’             Else ‘Unknown’ end AS ‘Auto Reboot’ FROM v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM ORDER BY     […]

Admin Password Status

In one of my previous blogs, I enable a few attributes within the Computer System Class.   Lets look at the Admin Password Status.   AdminPasswordStatus Data type: uint16Access type: Read-only System hardware security settings for administrator password status. Value Meaning 10×1 Disabled 20×2 Enabled 30×3 Not Implemented 40×4 Unknown     SELECT          Case […]