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   [ - ] Hide Comments


Please log in to comment

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

Please log in to comment
Answer this question or Comment on this question for clarity


Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja
Nine Simple (but Critical) Tips for Effective Patch Management
This paper reviews nine simple tips that can make patch management simpler, more effective and less expensive.