One of my nuisance issues when using WMI with Windows PowerShell, is that when looking at all properties I have to wade though many that have no value. I'd prefer to only view properties that have a populated value. Here's one way.<\/p>\n
Every WMI object has a property called Properties that is a collection of just what you would expect, properties. <\/p>\n
[cc lang=\"PowerShell\"]
\nPS S:\\> gwmi win32_computersystem | Select Properties<\/p>\n
Properties
\n----------
\n{AdminPasswordStatus, AutomaticManagedPagefile, AutomaticResetBootOption, AutomaticResetCapability...}
\n[\/cc]<\/p>\n
Because this is a collection, we can use Select-Object's ExpandProperty parameter.<\/p>\n
[cc lang=\"PowerShell\"]
\nPS S:\\> gwmi win32_computersystem | Select -ExpandProperty Properties | select -first 2<\/p>\n
Name : AdminPasswordStatus
\nValue : 0
\nType : UInt16
\nIsLocal : True
\nIsArray : False
\nOrigin : Win32_ComputerSystem
\nQualifiers : {CIMTYPE}<\/p>\n
Name : AutomaticManagedPagefile
\nValue : False
\nType : Boolean
\nIsLocal : True
\nIsArray : False
\nOrigin : Win32_ComputerSystem
\nQualifiers : {CIMTYPE}
\n[\/cc]<\/p>\n
The object gives me the property name and any value. This means I can construct a PowerShell expression like this:<\/p>\n
[cc lang=\"PowerShell\"]
\nPS S:\\> gwmi win32_computersystem | Select -ExpandProperty Properties | where {$_.value} | select Name,Value<\/p>\n
Name Value
\n---- -----
\nAutomaticResetBootOption True
\nAutomaticResetCapability True
\nBootOptionOnLimit 3
\nBootOptionOnWatchDog 3
\nBootROMSupported True
\nBootupState Normal boot
\nCaption SERENITY
\nChassisBootupState 3
\nCreationClassName Win32_ComputerSystem
\nCurrentTimeZone -240
\nDaylightInEffect True
\nDescription AT\/AT COMPATIBLE
\nDNSHostName SERENITY
\nDomain WORKGROUP
\nEnableDaylightSavingsTime True
\nFrontPanelResetStatus 3
\nKeyboardPasswordStatus 3
\nManufacturer TOSHIBA
\nModel Qosmio X505
\nName SERENITY
\nNetworkServerModeEnabled True
\nNumberOfLogicalProcessors 8
\nNumberOfProcessors 1
\nOEMStringArray ... , Bd-BtD7SW5M3i, bM5oVNHGZz+S9, yGkIbhav0zUFP}
\nPauseAfterReset 3932100000
\nPCSystemType 2
\nPowerSupplyState 3
\nPrimaryOwnerName Prof. Powershell
\nResetCapability 1
\nResetCount -1
\nResetLimit -1
\nRoles {LM_Workstation, LM_Server, SQLServer, NT}
\nStatus OK
\nSystemType x64-based PC
\nThermalState 3
\nTotalPhysicalMemory 8577855488
\nUserName SERENITY\\Jeff
\nWakeUpType 6
\nWorkgroup WORKGROUP
\n[\/cc]<\/p>\n
All I've done is pipe the collection of properties to Where-Object which is filtering out any objects that do not have a value. This is the type of thing where a scriptblock or function would come in handy.<\/p>\n
[cc lang=\"PowerShell\"]
\nPS S:\\> $wmi={Param([string]$class) gwmi $class | Select -ExpandProperty Properties | where {$_.value} | Select Name,Value}
\nPS S:\\> &$wmi win32_bios<\/p>\n
Name Value
\n---- -----
\nBiosCharacteristics {4, 7, 8, 9...}
\nBIOSVersion {TOSQCI - 6040000, Ver 1.00PARTTBL}
\nCaption Ver 1.00PARTTBL
\nDescription Ver 1.00PARTTBL
\nManufacturer TOSHIBA
\nName Ver 1.00PARTTBL
\nPrimaryBIOS True
\nReleaseDate 20101210000000.000000+000
\nSerialNumber Z9131790W
\nSMBIOSBIOSVersion V2.90
\nSMBIOSMajorVersion 2
\nSMBIOSMinorVersion 6
\nSMBIOSPresent True
\nSoftwareElementID Ver 1.00PARTTBL
\nSoftwareElementState 3
\nStatus OK
\nVersion TOSQCI - 6040000
\n[\/cc]<\/p>\n
I'll let you play with this and add support for remote computers or alternate credentials.<\/p>\n","protected":false},"excerpt":{"rendered":"
One of my nuisance issues when using WMI with Windows PowerShell, is that when looking at all properties I have to wade though many that have no value. I’d prefer to only view properties that have a populated value. Here’s one way.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,75,19],"tags":[534,82,302,301,547],"class_list":["post-1542","post","type-post","status-publish","format-standard","hentry","category-powershell","category-powershell-v2-0","category-wmi","tag-powershell","tag-scriptblock","tag-select-object","tag-where-object","tag-wmi"],"yoast_head":"\n