KACE report based on patch tasks from a Detect Schedule
Newer KACE user here, so likely will be back with multiple questions, if I cant find them already answered on the site :)
Question.
Setting up our TEST GROUP for patch deployment. The day after the patches are copied to our replication store, I have a scheduled task set, to do a DETECT only on those test PC's. (PC's are defined by a machine label).
Down at the bottom of the Patch Schedule is the PATCH TASKS, like as follows
Patch Tasks
| Name | IP Address | Status | Patch Results | Date |
|---|---|---|---|---|
| cnle | 192.168.252.24 | completed | Patched: 97, Not Patched: 2, Detect Failures: 0 | 11/20/2014 09:14:58 |
| CNEDESIA2 | 10.10.3.69 | completed | Patched: 97, Not Patched: 14, Detect Failures: 0 | 11/20/2014 09:16:32 |
| CNERISZO2 | 10.10.3.97 | completed | Patched: 79, Not Patched: 41, Detect Failures: 0 | 11/20/2014 09:12:51 |
| cninvent3 | 10.10.3.64 | completed | Patched: 66, Not Patched: 57, Detect Failures: 0 | 11/20/2014 09:18:12 |
| CNDIASKI | 10.10.3.56 | completed | Patched: 65, Not Patched: 54, Detect Failures: 0 | 11/20/2014 09:18:12 |
| CNBRITRI2 | 10.10.3.61 | completed | Patched: 65, Not Patched: 60, Detect Failures: 0 | 11/20/2014 09:16:32 |
| cnchrwin | 10.10.3.52 | completed | Patched: 60, Not Patched: 67, Detect Failures: 0 | 11/20/2014 09:17:36 |
| CNVICJOY2 | 10.10.3.124 | completed | Patched: 107, Not Patched: 3, Detect Failures: 0 | 11/20/2014 09:11:48 |
Is there an existing report, which I am missing which contains the information this way?
Or does anyone have a clue how to generate one which has the same information.
Just trying to automate things a bit.. That have it do the scan, then do the report afterwards so I am aware that the test group WILL have new updates this week (and who).
(the actual deployment, etc will be all scheduled, etc separately)
Thanks in advance!
Answers (2)
Comments:
-
Thanks for the post!
Entered it into the new Report (SQL)
Changed the bold part to my job name (keeping the ' right?)
No SQL errors :)
But when I run it, it comes back with no results :(
The patch job is there and shows info when I expand the patch schedule job. - GDkitty 9 years ago-
Yes on the single quotes. Keep them there.
Not sure why it would not work on yours. The best way to test it is to run the query from the MySQL Workshop software once you connect it to your KACE database. This way you can also verify all the tables and columns are there and populated. - h2opolo25 9 years ago-
Unfortunately, we are a sub group of our main location for this.. have limited access to the kbox otherwise :(
BUT.. some success!
Removed the line, where the patch job had to be changed completely..
And then it will give me results, of ALL the inventory.
So its just an issue with what that is referencing/looking at. - GDkitty 9 years ago -
That patch schedule, I have cut and pasted the name from it, into the spot, so I know its correct.. That patch schedule has its list, from a label... would it be any simpler referencing the machines via that label instead? - GDkitty 9 years ago
-
OK, so a LITTLE closer to getting this to work. REMOVED the where "PSS.DESCRIPTION = 'Monday Detect Job'" line and it shows all the machines.. and the two jobs I have so far. (also added a column to show the PSS.DESCRIPTION to make sure its correct. Keeping that line in, and removing the "and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE" gives me JUST the selected job.. but 4 instances of each machine... only ONE showing that the job is completed. - GDkitty 9 years ago
-
added 'and KT.PHASE = "Completed"' and it seems to give me the correct information. - GDkitty 9 years ago
-
The report is not showing those systems that read "Not Available" under Patch results. Is there anyway to include those as well? Thank you. - dabeava 8 years ago
thanks for the input.
Is there a way that the same report shows the updates patched/not patched ¿?
