/build/static/layout/Breadcrumb_cap_w.png

K1000 Patch Report by IP/Location

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

Answers (1)

Posted by: dugullett 10 years ago
Red Belt
1

Have you seen this post?

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

 


Comments:
  • 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. - ccullamco 10 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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