For each patch schedule in KACE, we have patch phase (Completed, deploying, Error, not scheduled) etc.  I am trying to provide a report of this patch phase for all machines in my machine labels targeted for patching.  I have not been able to figure out the reference for the patch phase in KACE DB.  Has anybody created this sort of report? 

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

Here's the report that I created:

SELECT DISTINCT P.ID, DESCRIPTION AS Description, P.LAST_RUN AS 'Last Run' , K.PHASE AS Phase , M.NAME AS Machine, M.ID as Machine_ID , PSMS.PATCHED, PSMS.NOTPATCHEDFROM PATCHLINK_SCHEDULE P LEFT JOIN KBSYS.KONDUCTOR_TASK K ON P.KONDUCTOR_TASK_TYPE = K.TYPE LEFT JOIN MACHINE M ON K.KUID = M.KUID LEFT JOIN PATCHLINK_SCHEDULE_MACHINE_STATUS PSMS ON PSMS.MACHINE_ID = M.IDWHERE P.LAST_RUN <> 0 AND DESCRIPTION not like '%Detect'ORDER BY M.NAME

Note that this won't include any patching schedules that end with Detect. We run separate detection and deploymet schedules so this report only shows results for schedules that actually deploy.

Answered 02/06/2014 by: chucksteel
Red Belt

  • Hey chucksteel, thanks for the response. This helps a great deal, however, this does not provide machines with status as "Not Schedule". Any idea on this?
    • I'm not sure why that's the case and when I tried to search the inventory for computers with deploy status = "not scheduled" I got an error. I submitted the error to technical support to see what they say about that.

      Regardless of the error since I'm starting with the patching schedule and joining in the machine data and phase data machines that aren't scheduled probably don't get an entry. In order to find machines that don't have anything scheduled you'd have to go the other way (select from the machine table and join to pull in their status). I'll see if I can whip up a report that does that.
    • After doing some digging in the database it doesn't appear that "Not Scheduled" is an actual phase, so making that appear on the report is difficult. The easiest answer is that if a machine doesn't appear on the report it isn't scheduled, but I'm having problems getting those computers to be included in the report properly.
Please log in to comment
Answer this question or Comment on this question for clarity