Does anyone have any SQL statement to define the patch report by ip range or site location. Im trying to break it down so each one of our company sites is able to see what computers from from their specific location by completion percentage. Can anyone help?

0 Comments   [ - ] Hide Comments


Please log in to comment

Answer this question or Comment on this question for clarity



Have you seen this post?



Answered 09/04/2013 by: dugullett
Red Belt

  • Thank you! This helps a lot but its not pulling all the machines from the smart label I created (BY L.NAME rlike 'label') only shows 4 computers when there should be about 200. I'm not sure if that's an AMP agent issue or something else needs to be added to the sql command.
Please log in to comment