{"id":12271,"date":"2011-10-27T00:01:00","date_gmt":"2011-10-27T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2011\/10\/27\/easily-filter-empty-wmi-properties-in-powershell\/"},"modified":"2011-10-27T00:01:00","modified_gmt":"2011-10-27T00:01:00","slug":"easily-filter-empty-wmi-properties-in-powershell","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/easily-filter-empty-wmi-properties-in-powershell\/","title":{"rendered":"Easily Filter Empty WMI Properties in PowerShell"},"content":{"rendered":"

Summary:<\/strong> Microsoft Scripting Guy Ed Wilson introduces a WMI filter to remove empty WMI properties by using Windows PowerShell.<\/p>\n

 <\/p>\n

Microsoft Scripting Guy Ed Wilson here. It is no secret by now that I love Windows Management Instrumentation (WMI). The information I can obtain and the things I can do with it are astounding. In the Windows PowerShell class I was teaching last week in Montreal, I told the class that I think when people say they “do not like WMI,” it is because they are still hampered by nightmares from their experiences of trying to use WMI back in the VBScript days.<\/p>\n

Note<\/b>   This is part four of a multipart article on developing a WMI helper module. On Monday<\/a>, I created the base WMI module, and included a couple of really great functions that query the WMI schema and return WMI class methods and properties. On Tuesday<\/a>, I added a function that returns the key property of a WMI class. This is useful when working with WMI instance methods. On Wednesday<\/a>, I created a function that will return the values of those key properties. Today, I add a HasWMIValue filter to the module.<\/p>\n

Another Note  <\/strong> The module for today’s Hey, Scripting Guy! Blog post is on the Scripting Guys Script Repository<\/a>.<\/p>\n

For example, here is a really simple example. I want to obtain information about the BIOS on my computer. Here is the VBScript to do so (copied from the Scripting Guys Script Repository<\/a>).<\/p>\n

VBScript to Get the BIOS information from a local computer<\/b><\/p>\n

strComputer = “.”<\/p>\n

Set objWMIService = GetObject(“winmgmts:” _<\/p>\n

    & “{impersonationLevel=impersonate}!\\\\” & strComputer & “\\root\\cimv2”)<\/p>\n

 <\/p>\n

Set colBIOS = objWMIService.ExecQuery _<\/p>\n

    (“Select * from Win32_BIOS”)<\/p>\n

 <\/p>\n

For each objBIOS in colBIOS<\/p>\n

    Wscript.Echo “Build Number: ” & objBIOS.BuildNumber<\/p>\n

    Wscript.Echo “Current Language: ” & objBIOS.CurrentLanguage<\/p>\n

    Wscript.Echo “Installable Languages: ” & objBIOS.InstallableLanguages<\/p>\n

    Wscript.Echo “Manufacturer: ” & objBIOS.Manufacturer<\/p>\n

    Wscript.Echo “Name: ” & objBIOS.Name<\/p>\n

    Wscript.Echo “Primary BIOS: ” & objBIOS.PrimaryBIOS<\/p>\n

    Wscript.Echo “Release Date: ” & objBIOS.ReleaseDate<\/p>\n

    Wscript.Echo “Serial Number: ” & objBIOS.SerialNumber<\/p>\n

    Wscript.Echo “SMBIOS Version: ” & objBIOS.SMBIOSBIOSVersion<\/p>\n

    Wscript.Echo “SMBIOS Major Version: ” & objBIOS.SMBIOSMajorVersion<\/p>\n

    Wscript.Echo “SMBIOS Minor Version: ” & objBIOS.SMBIOSMinorVersion<\/p>\n

    Wscript.Echo “SMBIOS Present: ” & objBIOS.SMBIOSPresent<\/p>\n

    Wscript.Echo “Status: ” & objBIOS.Status<\/p>\n

    Wscript.Echo “Version: ” & objBIOS.Version<\/p>\n

    For i = 0 to Ubound(objBIOS.BiosCharacteristics)<\/p>\n

        Wscript.Echo “BIOS Characteristics: ” & _<\/p>\n

            objBIOS.BiosCharacteristics(i)<\/p>\n

    Next<\/p>\n

Next<\/p>\n

 <\/p>\n

Windows PowerShell script to retrieve the BIOS information from a local computer <\/b><\/p>\n

Get-WmiObject win32_bios | format-list *<\/p>\n

I am not kidding! It is one short line. In fact, if I use aliases, the command becomes even shorter. Here is the “short” version of the command. The short version is 18 characters long; the VBScript to do exactly the same thing is more than 18 lines long:<\/p>\n

gwmi win32_bios | fl *<\/p>\n

The output from the Windows PowerShell Get-WMIObject<\/b> command is shown in the following figure.<\/p>\n

\"Image<\/a><\/p>\n

With power like this at one’s fingertips, it is hard not to fall in love with WMI and Windows PowerShell. One thing that does annoy me, a bit, is the fact that nearly any query to WMI results in many lines of property names and no values. This was especially distressing in the old VBScript days because it was so much work to retrieve a single property value that I really felt disappointed when the command did not return any information.<\/p>\n

To solve the problem of WMI classes that do not populate values in all of the class properties, I have a filter that I use. In fact, when I was writing the scripts for the Windows 7 Inside Out<\/i> book and the Windows 7 Resource Kit, I used this filter extensively. I decided it is just the sort of thing I want to have constantly available. I use WMI on a daily basis, and therefore piping the output to the filter really makes sense. To make it always available, I modified it a bit and placed it in my WMI module. I uploaded HSGWMIModuleV4<\/b> to the Scripting Guys Script Repository. I have comment-based help, but there is no need to go over that. The key portion of the filter is shown here:<\/p>\n

$_.properties |<\/p>\n

   foreach-object -BEGIN {write-host -ForegroundColor BLUE $_.path} -Process {<\/p>\n

     If($_.value -AND $_.name -notmatch “__”)<\/p>\n

      {<\/p>\n

        @{ $($_.name) = $($_.value) }<\/p>\n

      } #end if<\/p>\n

    } #end foreach property<\/p>\n

 <\/p>\n

In the filter, the first thing I do is look at the input object that is piped to the filter, and retrieve a collection of the properties. I pipe the properties to the Foreach-Object<\/b> cmdlet:<\/p>\n

$_.properties |<\/p>\n

The first thing I do in the Foreach-Object<\/b> cmdlet is use the begin<\/i> parameter to print out the path to WMI instance, as shown here:<\/p>\n

foreach-object -BEGIN {write-host -ForegroundColor BLUE $_.path}<\/p>\n

In the process<\/b> <\/i>portion, I check to see if the property has a value, and if it does not match an underscore. This removes some system properties, and it also removes properties that do not have a value. I create a hash table from the properties and their associated values, and return it. This portion of the code is shown here:<\/p>\n

-Process {<\/p>\n

     If($_.value -AND $_.name -notmatch “__”)<\/p>\n

      {<\/p>\n

        @{ $($_.name) = $($_.value) }<\/p>\n

      } #end if<\/p>\n

To use the HasWMiValue<\/b> filter, I import my WMI module, and then pipe the results of a Get-WMiObject<\/b> command to it. This is shown here:<\/p>\n

Import-Module HSG*wmi*4<\/p>\n

GWMI win32_bios | HasWmiValue<\/p>\n

I removed the HSGWMIModuleV4<\/b> and did a query of the Win32_bios<\/b> WMI class while listing all the properties. There are a number of properties from the Win32_Bios<\/b> class that do not return values. I then import the HSSGWMIModuleV4<\/b> and instead of piping the management into Format-List<\/b>, I pipe it to the HasWMiValue<\/b> filter. These two commands and their associated output are shown in the following figure.<\/p>\n

\"Image<\/a><\/p>\n

The HasWMIValue<\/b> filter works great. It lists all of the properties of a WMI class that contain values, and suppresses the system properties as well as the properties that are empty. This output is great for exploring WMI.<\/p>\n

Once imported, there is no need to import the WMI module a second time. I can use the HasWmiValue<\/b> directly in the pipeline. I uploaded the complete WMI helper module to the Scripting Guys Script Repository<\/a>.<\/p>\n

 <\/p>\n

Well, that is about all there is to the HasWmiValue<\/b> filter. I have comment-based help in the function, so if you need additional help, use Get-Help<\/b>. Until tomorrow, keep on scripting!<\/p>\n

I invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.<\/p>\n<\/p>\n

Ed Wilson, Microsoft Scripting Guy<\/b><\/p>\n<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Microsoft Scripting Guy Ed Wilson introduces a WMI filter to remove empty WMI properties by using Windows PowerShell.   Microsoft Scripting Guy Ed Wilson here. It is no secret by now that I love Windows Management Instrumentation (WMI). The information I can obtain and the things I can do with it are astounding. In […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[3,4,45,6],"class_list":["post-12271","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell","tag-wmi"],"acf":[],"blog_post_summary":"

Summary: Microsoft Scripting Guy Ed Wilson introduces a WMI filter to remove empty WMI properties by using Windows PowerShell.   Microsoft Scripting Guy Ed Wilson here. It is no secret by now that I love Windows Management Instrumentation (WMI). The information I can obtain and the things I can do with it are astounding. In […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=12271"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12271\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=12271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=12271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=12271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}