/build/static/layout/Breadcrumb_cap_w.png
01/06/2016 1093 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"
AND
The device is a member of Device Label "ABC"

Thanks!
Mark
0 Comments   [ + ] Show comments

Comments


All 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