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.
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity

Share