KACE Product Support : Report to show devices that are missing patches based on a specific Patch Label AND specific Device Label

Report to show devices that are missing patches based on a specific Patch Label AND specific Device Label

I am looking for a SQL query that will provide a report that lists devices missing a patch where:

The patch is a member of Patch Label "XYZ"

AND

The device is a member of Device Label "ABC"

Thanks!

Mark

0 Comments [ + ] Show comments

Posted by: StockTrader 8 years ago

Hello,

you can try this (I'm improvising... :-) )

Look for a report called For a group of devices, what patches are installed and duplicate it
Add another subtopic: Patch
Adjust the Fields to display, column order and sorting to suit your needs
In the filters section try something like that:

I've not tested it, mine is a bit ad impromptu idea.

Hope that helps :-)

Kind regards,

Marco - StockTrader

Answer this question

question