{"id":12241,"date":"2011-10-30T00:01:00","date_gmt":"2011-10-30T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2011\/10\/30\/use-wmi-association-classes-to-relate-two-classes-together\/"},"modified":"2011-10-30T00:01:00","modified_gmt":"2011-10-30T00:01:00","slug":"use-wmi-association-classes-to-relate-two-classes-together","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/use-wmi-association-classes-to-relate-two-classes-together\/","title":{"rendered":"Use WMI Association Classes to Relate Two Classes Together"},"content":{"rendered":"

Summary:<\/strong> Use a cool Windows PowerShell technique to easily relate two WMI classes together.<\/span><\/span><\/p>\n

 <\/span><\/p>\n

Microsoft Scripting Guy Ed Wilson here. Well, the Scripting Wife and I are getting settled back down from our Canadian tour. We had a great time visiting MVPs on our return. We got to see Jeffery Hicks in Syracuse, Joel Bennett in Rochester, and Ken McFerron in Pittsburgh, Pennsylvania. While teaching my Windows PowerShell class in Montreal, I realized that I had not written very much about using Windows PowerShell with WMI association classes. <\/span><\/p>\n

When querying a WMI association class, the results return references to external classes. In fact, the things that are returned point to the key property of the referenced classes. An example will help to clarify this. My laptop has a network adapter. The win32_networkadapter<\/b> WMI class describes the maker, the speed, MAC address, and other information about my network adapter. The following query returns information about my network adapter:<\/span><\/p>\n

gwmi win32_networkadapter -Filter “netconnectionid = ‘local area connection'”<\/span><\/p>\n

If I want to find all of the information about my network adapter, but I do not want to see any empty properties (because some WMI classes contain literally hundreds of properties many of which do not return any information), I use the haswmivalue<\/b> <\/i>filter from my WMI module. <\/span><\/p>\n

In the following figure, I use the haswmivalue<\/b> filter from <\/span>my HSGWMImoduleV5 module<\/span><\/a><\/span> to return all the properties that contain a value. (Of course, the haswmivalue<\/b> function also exists in <\/span>HSGWMImoduleV6<\/span><\/a><\/span> as well. Version six of my HSG WMI Module is the latest version, and it includes several upgrades to version five). <\/span><\/span><\/p>\n

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

In addition to having physical information, such as the MAC address and speed, a network adapter also has a protocol (or more than one protocol) bound to it. To find protocol type of information, such as the TCP\/IP address, subnet mask, and default gateway, it is necessary to query the Win32_NetworkAdapterConfiguration<\/b> WMI class. To make matters worse, the netconnectionid<\/b> <\/i>property that I used when querying the Win32_NetworkAdapter<\/b> WMI class is not available. In addition, the key<\/b> property from Win32_NetworkAdapter<\/b> is DeviceID<\/b>, but the key<\/span><\/b> property from Win32_NetworkAdapterConfiguration<\/b> is index<\/b>. <\/i>Upon closer observation, however, this problem is not as bad as it might seem. Using my Get-WmiKeyValue<\/b> function from my HSGWmiModuleV6<\/b> WMI module, I can easily see that the properties from the two different WMI classes are probably related (the values seem to be identical). This is shown in the following figure.<\/span><\/p>\n

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

From my previous query of Win32_NetworkAdapter<\/b>, I saw that the deviceID<\/b> <\/i>of 7 was the network interface from which I wanted to obtain information. Using this value as the index<\/b> number, I come up with the following query (gwmi<\/b> is an alias for Get-WmiObject<\/b>). The first position is class<\/b> <\/i>and I left it out. The f<\/b> <\/i>stands for filter<\/b> <\/i>and I was able to use the abbreviation. The haswmivalue<\/b> <\/i>filter is from my WMI module.<\/span><\/p>\n

gwmi win32_networkadapterconfiguration -F “index = 7” | HasWmiValue<\/span><\/p>\n

The command and associated output are shown in the following figure.<\/span><\/p>\n

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

What is needed is a way to query both WMI classes at the same time. I need to see both the hardware information and the protocol related information for the same adapter. There is a solution for this problem; I can use an association WMI class. In the old VBScript days, querying a WMI association class was a really hard-core task that few outside of the Microsoft Scripting Guys really understood. This can all change in the Windows PowerShell world, because querying WMI association classes is trivial. Keep in mind that there are more than 100 association classes in root\\cimv2<\/b> alone. These classes expose very useful and powerful information about your system. <\/span><\/p>\n

Using my Get-WmiClassesWithQualifiers<\/b> function from my WMI module, I can easily find association classes in any WMI namespace. For our purposes, I will focus on association classes in Root\\CimV2<\/b> (the default WMI namespace.) I am only interested in working with dynamic <\/i>WMI classes, and unfortunately, I did not add a dynamic filter to my Get-WmiClassesWithQualifiers<\/b> function (this is something I will probably do at a later date). In the meantime, I can reduce the number of WMI classes I need to filter through by removing the classes that begin with cim. <\/i>In most cases, classes that begin with cim <\/i>are abstract classes. I use the following query to find association <\/i>classes in Root\\CimV2<\/b>. <\/span><\/p>\n

Get-WMIClassesWithQualifiers -qualifier association | ? { $_ -notmatch ‘^cim’} | sort <\/span><\/p>\n

The command and associated output are shown in the following figure.<\/span><\/p>\n

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

Exploration of these association classes will yield fruitful and profitable results. To illustrate working with these classes, I want to examine the Win32_NetworkAdapterSetting<\/b> association class. This class relates the two WMI classes we began with: Win32_NetworkAdapter<\/b> and Win32_NetworkAdapterConfiguration<\/b>. <\/span><\/p>\n

The first thing I do is query the Win32_NetworkAdapterSetting<\/b> WMI class directly by using the Get-WMIObject<\/b> cmdlet. This query is shown here (using the gwmi<\/b> alias for Get-WmiObject<\/b>):<\/span><\/p>\n

gwmi win32_networkadaptersetting<\/span><\/p>\n

The command and associated output are shown in the following figure.<\/span><\/p>\n

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

A close examination of both the element<\/b> <\/i>and the setting<\/b> <\/i>properties reveals they point to the key<\/b> properties of the Win32_NetworkAdapter<\/b> and Win32_NetworkAdapterConfiguration<\/b> WMI classes. It is possible to filter out using WQL, but it starts to get tricky, and it is therefore easier to use the Where-Object<\/b> cmdlet to find an element that has the deviceID<\/b> of 7 (the value we found earlier). This is really easy to do, and the command is shown here (I use gwmi<\/b> for Get-WmiObject<\/b> and ?<\/b> for Where-Alias<\/b>):<\/span><\/p>\n

gwmi win32_networkadaptersetting | ? {$_.element -match 7}<\/b><\/span><\/p>\n

The [WMI]<\/b> management accelerator accepts this fully qualified path to a management object, and will return the associated class. To query these, I first store the result from the previous command into a variable called $adapter<\/b>. Next, I use the [WMI]<\/b> type accelerator to return the specific WMI instance of my Win32_NetworkAdapter<\/b> and my Win32_NetworkAdapterConfiguration<\/b> classes. Here are the three commands:<\/span><\/p>\n

$adapter = gwmi win32_networkadaptersetting | ? {$_.element -match 7}<\/span><\/p>\n

[wmi]$adapter.Element | HasWmiValue<\/span><\/p>\n

[wmi]$adapter.Setting | HasWmiValue<\/span><\/p>\n

The following figure illustrates these three commands and the associated output. <\/span><\/p>\n

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

One other thing before I go. It is possible to perform a less direct filter. This is because using the [WMI]<\/b> type accelerator and the path, I obtain a complete instance of the WMI class that is referenced. This means I can use the same type of query that I used previously with Get-WMIObject<\/b> when querying the WMI classes directly. Perhaps an example will suffice. In the following code, I use the Get-WMIObject<\/b> (gwmi<\/b> is the alias) to query the Win32_NetworkAdapterSetting WMI class. I use the where-object cmdlet (? is the alias) to perform my filtering. I already know that the first command, gwmi win32_networkadaptersetting<\/b>, returns a collection of paths that point to the key values of all instances of Win32_NetworkAdapter<\/b> and Win32_NetworkAdapterConfiguration<\/b>. I choose the value stored in the element<\/b> <\/i>property because it points to instances of Win32_NetworkAdapter<\/b>. I can therefore use one of my favorite techniques that I call “group and dot” where I group the results by using parentheses, and I access a specific property by using dotted notation. After I have the specific property, I look for elements that have a value of the netconnectionid<\/b> <\/i>property that will match local area connection. <\/i>The command is shown here:<\/span><\/p>\n

gwmi win32_networkadaptersetting | ? {([wmi]$_.element).netconnectionID -match ‘local area connection’}<\/span><\/p>\n

The command and associated output are shown in the following figure.<\/span><\/p>\n

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

Well, that is all there is to working with WMI association classes. Hopefully, you will search for other association classes using the techniques I have outlined here, and then you will also begin to explore the type of information that is available. <\/span><\/p>\n

 <\/span><\/p>\n

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

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

<\/span> <\/p>\n

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

Summary: Use a cool Windows PowerShell technique to easily relate two WMI classes together.   Microsoft Scripting Guy Ed Wilson here. Well, the Scripting Wife and I are getting settled back down from our Canadian tour. We had a great time visiting MVPs on our return. We got to see Jeffery Hicks in Syracuse, Joel […]<\/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],"class_list":["post-12241","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-scripting-guy","tag-scripting-techniques","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Use a cool Windows PowerShell technique to easily relate two WMI classes together.   Microsoft Scripting Guy Ed Wilson here. Well, the Scripting Wife and I are getting settled back down from our Canadian tour. We had a great time visiting MVPs on our return. We got to see Jeffery Hicks in Syracuse, Joel […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12241","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=12241"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/12241\/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=12241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=12241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=12241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}