strComputer = “.”\nstrTargetAddress = “192.59.244.247”<\/p>\nSet objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)\nSet colItems = objWMIService.ExecQuery _\n (“Select * From Win32_NetworkAdapterConfiguration Where IPEnabled = True”)<\/p>\n
For Each objItem in colItems\n arrIPAddresses = objItem.IPAddress\n For Each strAddress in arrIPAddresses\n If strAddress = strTargetAddress Then\n strMACAddress = objItem.MacAddress\n End If\n Next\nNext<\/p>\n
Set colItems = objWMIService.ExecQuery _\n (“Select * From Win32_NetworkAdapter Where MACAddress = ‘” & strMACAddress & “‘”)<\/p>\n
For Each objItem in colItems\n If Not IsNull(objItem.NetConnectionID) Then\n Wscript.Echo objItem.NetConnectionID\n End If\nNext\n<\/PRE>\n
After assigning values to the variables strComputer and strTargetAddress (which represent the computer we\u2019re working with and the target IP address, respectively) we bind to the WMI service and then use the ExecQuery<\/B> method to select all instances of the Win32_NetworkAdapterConfiguration class where the IPEnabled<\/B> property is equal to True. This returns only TCP\/IP-enabled network adapters, and weeds out things like FireWire connections. <\/P>\n
We then set up a For Each loop to cycle through the returned collection. Inside that For Each loop we assign the value of the IPAddress<\/B> property of our first network adapter to an array variable named arrIPAddresses. (Don\u2019t be fooled by the named IPAddress; this property can contain more than one IP address, which is why we need to use an array to get at the values.) We then set up a second For Each loop to loop through the array of IP addresses. For each address we check to see if the value matches our target IP address (192.59.244.247). If it does, we assign the value of the MACAddress<\/B> property to a variable named strMACAddress. We continue this process until we\u2019ve checked all the IP addresses for all the network adapters.<\/P>\n
When we exit the loop we will know the MAC address of the network adapter associated with our target IP address. Believe it or not, that\u2019s the key to unlocking this mystery. Why? Because the MACAddress property is found in both of our WMI classes. As soon as we know the MAC address associated with the IP address 192.59.244.247 all we have to do find this same MAC address somewhere in the Win32_NetworkAdapter class. When we do that, we can then determine the name of the network connection associated with that IP address. <\/P>\n
And that\u2019s exactly what we do with this second WMI query, one that retrieves all instances of the Win32_NetworkAdapter class where the MACAddress is equal to the MAC address associated with our IP address:<\/P>
Set colItems = objWMIService.ExecQuery _\n (“Select * From Win32_NetworkAdapter Where MACAddress = ‘” & strMACAddress & “‘”)\n<\/PRE>\nRelax; we\u2019re almost done here. We now loop through the returned collection, eliminating any instances where the NetConnectionID<\/B> property is null. Eventually we\u2019ll get back a message like this one:<\/P>![\"Network](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/qanda\/netconnect.jpg\")
\n
OK, sure, it doesn\u2019t look<\/I> like much. But this just happens to be the name of the network connection associated with the IP address 192.59.244.247. And that ought to be worth something<\/I>, right?<\/P>\n
Incidentally, you can find some additional information about associating network connections and network adapters in the whitepaper Automating TCP\/IP Networking on Clients<\/B><\/A>. Click the link and then search for Associating the Network Connections Name with MAC and IP Addresses Using Two Classes<\/I>.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"Hey, Scripting Guy! How can I determine the local area connection that\u2019s associated with a particular IP address?— SH Hey, SH. Believe it or not, this is a fairly complicated procedure, and for two reasons. To begin with, we have to use two separate WMI classes – Win32_NetworkAdapter and Win32_NetworkAdapterConfiguration – in order to retrieve […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[36,37,3,5],"class_list":["post-69603","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-client-side-management","tag-networking","tag-scripting-guy","tag-vbscript"],"acf":[],"blog_post_summary":"
Hey, Scripting Guy! How can I determine the local area connection that\u2019s associated with a particular IP address?— SH Hey, SH. Believe it or not, this is a fairly complicated procedure, and for two reasons. To begin with, we have to use two separate WMI classes – Win32_NetworkAdapter and Win32_NetworkAdapterConfiguration – in order to retrieve […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/69603","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\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=69603"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/69603\/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=69603"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=69603"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=69603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
\n![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/A> \n