/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Server Patching Report

11/04/2015 1028 views
Hi All,

I'm trying to create a report that gives us a report of server that have total patches deployed and total patches detected. with the code below i'm getting a list of all deployed and detected for each server.

How do I group them and get the totals?

SELECT MACHINE.NAME AS SYSTEM_NAME, (group_concat(distinct concat(KBSYS.PATCHLINK_PATCH.TITLE,' (',IDENTIFIER,') - ',PATCHLINK_MACHINE_STATUS.DEPLOY_STATUS) order by KBSYS.PATCHLINK_PATCH.TITLE separator '\n')) as DEPLOY_STATUS, group_concat(distinct concat(KBSYS.PATCHLINK_PATCH.TITLE,' (',IDENTIFIER,') - ',PATCHLINK_MACHINE_STATUS.STATUS) order by KBSYS.PATCHLINK_PATCH.TITLE separator '\n') as DETECT_STATUS

FROM MACHINE  left join PATCHLINK_MACHINE_STATUS on PATCHLINK_MACHINE_STATUS.MACHINE_ID = MACHINE.ID LEFT JOIN KBSYS.PATCHLINK_PATCH ON (KBSYS.PATCHLINK_PATCH.UID = PATCHLINK_MACHINE_STATUS.PATCHUID)

WHERE ((( exists  (select 1 from LABEL, MACHINE_LABEL_JT where MACHINE.ID = MACHINE_LABEL_JT.MACHINE_ID AND MACHINE_LABEL_JT.LABEL_ID = LABEL.ID  AND LABEL.TYPE <> 'hidden' and LABEL.NAME = 'C_Servers')) ))  GROUP BY MACHINE.ID ORDER BY SYSTEM_NAME

I'm after the below:

ServerDeployed PatchesDetected Patches
Server0154156

1 Comment   [ + ] Show comment

Comments

  • is anyone able to help with this? I still don't have it fixed.

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