Solarwinds WMI Query on Print Spooler

Greetings,

We are trying to run a WMI query that detects the total amount of jobs currently in the print queue which we have done, but are also wanting to detect whether the printer has errors or is offline so that these are ignored. Is there a way to have more than one table in the FROM clause of the query?

SELECT Jobs FROM Win32_PerfFormattedData_Spooler_PrintQueue WHERE Name='_Total'

This is what we are currently running, but want to add Win32_Printer Where Portname like 'USB%' AND Workoffline = False to the query.

Find more posts tagged with

win32

query

sam

select

sql

printqueue

solarwinds

WMI

printer

Accepted answers

mesverrum

Not as part of a WMI query. You could wrap those WMI queries in some powershell and create additional layers of logic that way.

All comments

mesverrum

Not as part of a WMI query. You could wrap those WMI queries in some powershell and create additional layers of logic that way.

dalton948

Thats what we've started to look into. Thanks for the help!

mesverrum

I also just learned that SCCM adds some join functionalities to WMI queries, but I'm not sure if you have to do the queries within SCCM to have them or if it installs something that enables all WMI calls to leverage them.