KACE Product Support Question

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

01/06/2016 1722 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


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ