/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


SQL Report- Patches Installed, Not installed and Failed

06/13/2017 493 views
Hi,

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.

Regards,
MN
1 Comment   [ + ] Show comment

Comments

  • Thanks Chucksteel, it worked. Adding to this report i need patch title or Patch description. Ex: if 2 patches installed, i need those 2 patches description on this report. Thanks in advance... Regards, MN
    • That would make the report rather messy, depending on the output style. For instance, in a CSV style report they would need to be listed in one column that would be quite large. If you are using the HTML report then the K1000 can group by certain columns and make the output nicer, but I still think it will look messy. Also, as the report will most likely return a large number of patches for most computers, it will get worse over time, unless you intend to filter by when the patches were installed.

All Answers

3
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
WHERE 
LABEL.NAME = "Label"
ORDER BY MACHINE.NAME


Answered 06/13/2017 by: chucksteel
Red Belt

 
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