wmi how to do "where field in"

[juniormint]

My goal is to get information on a list of processes. I think WMI is a decent way to do this, but keep getting a syntax error from the select below. Refactoring to have Name = "app1" or Name = "app2" etc works, but I'd rather understand why the below doesn't work.

[WMI:ProcessMemory]
interval=10
wql = select * from Win32_PerfFormattedData_PerfProc_Process Where Name in ("app1", "app2", "java")

[juniormint · Accepted solution]

Windows Query Language (wql) does not appear to support where field in

[juniormint]

yeah...I was just noticing...Windows Query Language (wql) does not appear to support it...grumble

[somesoni2]

I believe WMI doesn't have IN clause.