I need a Patching Summary Report that shows;
1. The total number of patches that has been applied to machines
2. The total number of failed patches
3. The total number of patches that needs to be applied to machines


Totals Only, so that I can quickly see the progress.

Thank You for any help
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
Seems pretty simple.

Give the SQL a shot, and post your code.

Well help if you get stuck.
Answered 10/24/2011 by: dchristian
Red Belt

Please log in to comment
0
I have zero experience with SQL, that's whay I'm asking for help on this.
Thanks
Answered 10/24/2011 by: pwhitt
Senior Yellow Belt

Please log in to comment
0
Here's some resources to get you started.

A good overview on SQL.
[link]http://www.w3schools.com/sql/default.asp[/link]

How to connect to the KBOX database.
[link]http://www.kace.com/support/kb/index.php?action=artikel&cat=9&id=9&artlang=en[/link]
Answered 10/24/2011 by: dchristian
Red Belt

Please log in to comment
0
ORIGINAL: pwhitt

I need a Patching Summary Report that shows;
1. The total number of patches that has been applied to machines
2. The total number of failed patches
3. The total number of patches that needs to be applied to machines


How do you define success and failure? Is a failure on one machine a failure? Or is this request a per machine request?
Answered 10/24/2011 by: GillySpy
Seventh Degree Black Belt

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