/build/static/layout/Breadcrumb_cap_w.png

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

NameIP AddressStatusPatch ResultsDate
cnle192.168.252.24completedPatched: 97, Not Patched: 2, Detect Failures: 0 11/20/2014 09:14:58
CNEDESIA210.10.3.69completedPatched: 97, Not Patched: 14, Detect Failures: 0 11/20/2014 09:16:32
CNERISZO210.10.3.97completedPatched: 79, Not Patched: 41, Detect Failures: 0 11/20/2014 09:12:51
cninvent310.10.3.64completedPatched: 66, Not Patched: 57, Detect Failures: 0 11/20/2014 09:18:12
CNDIASKI10.10.3.56completedPatched: 65, Not Patched: 54, Detect Failures: 0 11/20/2014 09:18:12
CNBRITRI210.10.3.61completedPatched: 65, Not Patched: 60, Detect Failures: 0 11/20/2014 09:16:32
cnchrwin10.10.3.52completedPatched: 60, Not Patched: 67, Detect Failures: 0 11/20/2014 09:17:36
CNVICJOY210.10.3.124completedPatched: 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!



0 Comments   [ + ] Show comments

Answers (2)

Posted by: h2opolo25 9 years ago
Red Belt
3
select M.NAME as NAME, M.IP as IP_ADDRESS, KT.PHASE as STATUS, Concat('Patched: ', PS.PATCHED,' , ','Not Patched: ',  PS.NOTPATCHED,' , ','Detect Failures: ',  PS.DETECT_FAILURES) as PATCH_RESULTS, PS.LAST_RUN as DATE 
from MACHINE M
left join PATCHLINK_SCHEDULE_MACHINE_STATUS PS on PS.MACHINE_ID = M.ID
left join PATCHLINK_SCHEDULE PSS on PSS.ID = PS.PATCHLINK_SCHEDULE_ID
left join KBSYS.KONDUCTOR_TASK KT on KT.KUID = M.KUID
where PSS.DESCRIPTION = 'Monday Detect Job'
and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE

Make sure to change the bold string with the name of your patch job.


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
Posted by: NachoGalan 5 years ago
White Belt
0

thanks for the input.

Is there a way that the same report shows the updates patched/not patched ¿?

 
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