/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


I want to create a report giving me the name. IP address, status for each machine, patch results as patched, not patched, detect failures, if failed - what is the reason and date. Please help. Thanks

02/12/2016 1003 views
I am able to generate report which gives me almost everything what I need. The problem is for some machines status is missing and if failed, not able to expand it as why it is failed. Also for some machines getting some weird dates like almost 3-4 years back dates.
3 Comments   [ + ] Show comments

Comments

  • Can you post your current SQL statement? Also, how many patching schedules do you have configured?
  • The problem with weird dates might have to do with superseded patches? Try including PATCHLINK_PATCH_STATUS.STATUS = 0 in the WHERE clause (0 indicates 'active' patches)
  • my current sql statement is -
    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
    and KT.TYPE = PSS.KONDUCTOR_TASK_TYPE
    • I would add PSS.DESCRIPTION to the list of fields being selected. I don't think that the tables ever get purged so there may be results for older patching schedules being included in your results.

      Also, in order to get error codes you need to select from specific patches in the PATCHLINK_MACHINE_STATUS table.

Be the first to answer this question

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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