windowswmiusbwql

How do I run the following WMI query?

How do I run the following WMI query, both programmatically to and as a one-shot deal? Can I use Visual Studio 2008, and if so what language and type of project do I setup? I'm a complete beginner at this so please provide details. Thanks!

SELECT * FROM Win32_USBControllerDevice
For Each as USBDevice
   ASSOCIATORS OF {Win32_PnPEntity.DeviceID="<USBDevice.Dependent>"}
    WHERE ResultClass = Win32_DiskDrive
   For Each as Drive
      ASSOCIATORS OF {Win32_DiskDrive.DeviceID="<Drive.DeviceID>"} 
       WHERE AssocClass = Win32_DiskDriveToDiskPartition
      For Each as Drive2Part
         ASSOCIATORS OF {Win32_DiskPartition.DeviceID="<Drive2Part.DeviceID>"} 
          WHERE AssocClass = Win32_LogicalDiskToPartition
         For Each as Disk2Part
            Win32_LogicalDisk = <Disk2Part.Dependent>
         End For
      End For      
   End For
End For

Here's the source of the query from CodeGuru.

Solution

  • The WMI Code creator will create the snippets for you in a few languages. It is pretty handy for this kind of task.