WQL with string finding in where clause

Question

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.

score 1 · Accepted Answer · answered Sep 23 '13 at 13:18

1

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

answered Sep 23 '13 at 13:18

Damith

1 Answers1