SQL Report- Patches Installed, Not installed and Failed
I'm very new to Kace 1000 and not much familiar with SQl.
Can anyone help me out in SQL reports - After my Patch Deployment completed, need a report which includes the Servers names with patching status - Patched, Not Patched and Failed. Any help much appreciated.
Thanks in advance.
Please log in to answer
Posted by: chucksteel 3 years ago
Will this work? It only reports for computers with a given label:
SELECT MACHINE.ID, MACHINE.NAME, P.DESCRIPTION, PSMS.PATCHED, PSMS.NOTPATCHED, PSMS.DETECT_FAILURES, PSMS.LAST_RUN, K.PHASE, K.TYPE
FROM PATCHLINK_SCHEDULE_MACHINE_STATUS PSMS
JOIN MACHINE on MACHINE.ID = PSMS.MACHINE_ID
JOIN PATCHLINK_SCHEDULE P on P.ID = PSMS.PATCHLINK_SCHEDULE_ID
JOIN KBSYS.KONDUCTOR_TASK K ON P.KONDUCTOR_TASK_TYPE = K.TYPE and K.KUID = MACHINE.KUID
JOIN MACHINE_LABEL_JT on MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID
JOIN LABEL on LABEL.ID = MACHINE_LABEL_JT.LABEL_ID
LABEL.NAME = "Label"
ORDER BY MACHINE.NAME