Scripting Question

Patching - Severity & Impact

09/18/2015 1986 views
Good day folks,

I not an SQL person, but I've been trying to piece together some bit of SQL code found online to get a report that I want.
I eventually came across this http://www.itninja.com/question/k1000-report-of-all-patches-missing-by-machine-displayed-in-a-specific-way which was quite helpful.

There is column called PP.IMPACTID which seems to correspond to (Patch) Impact, what how do I know the name of the column that corresponds to Severity?

I would appreciate any assistance that can be rendered. Thank you.

Answer Summary:
0 Comments   [ + ] Show comments


Answer Chosen by the Author

Install Toad for MySQL on your tech station and attach to your kbox.  You can then browse the databases and field names
Answered 09/23/2015 by: SMal.tmcc
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

View more:


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