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   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

Have you seen this post?

http://www.itninja.com/blog/view/k1000-reports-patching-reports-for-completion-by-patch-machine-vendor-using-labels

 

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
Answer this question or Comment on this question for clarity