Search code examples
c#wmiwql

WQL with string finding in where clause

I'm looking a way to search for USB devices where the DeviceID contains the string literal VID_217C. Is it possible?

In other words, I'm looking for the following query

select * from Win32_USBHub where DeviceID contains "VID_217C"

to return only those Win32_USBHubs for which VID_217C is a substring in DeviceID.

Solution

  • You can use like operator 

    select * from Win32_USBHub where DeviceID LIKE "%VID_217C%"