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

Comments

Please log in to comment

Answers

0
Hello,

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

Please log in to comment
Answer this question or Comment on this question for clarity

Share