Microsoft® Windows® Scripting with WMI: Self-Paced Learning Guide

Chapter 3: Using Basic WMI Queries 67

"Select MACAddress, Manufacturer, Name, Description from Win32_NetworkAdapter" _

& " where manufacturer = 'Microsoft' and MACAddress is null"

Note that I use a compound Where clause in this query. I want to know where the manufac-

turer is equal to Microsoft but only if the MACAddress is also NULL. This is a great technique

for really focusing on the data that you are interested in retrieving.

AdapterMicrosoft.vbs

strComputer = "."

wmiNS = "\root\cimv2"

wmiQuery = "Select MACAddress, Manufacturer, Name, Description from Win32_NetworkAdapter" _

& " where

manufacturer = 'Microsoft' and MACAddress is null"

Set objWMIService =

getObject

("winmgmts:\\" & strComputer & wmiNS)

Set colItems = objWMIService. ...