01/06/2016 1200 views
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"
The device is a member of Device Label "ABC"

0 Comments   [ + ] Show comments


All Answers


you can try this (I'm improvising... :-) )
  1. Look for a report called For a group of devices, what patches are installed and duplicate it
  2. Add another subtopic: Patch
  3. Adjust the Fields to display, column order and sorting to suit your needs
  4. 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

Answered 01/06/2016 by: StockTrader
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login