KACE Product Support

There are a number of ways this can be accomplished. There are some canned reports in the Reports module that may answer your question and custom reports are also possible. There were major changes to the patching module in version 10.x of the appliance, so custom reports may need to be updated if you have recently upgraded your SMA.

You can find the list of canned reports in    Reporting -> Reports. Select "View By:"  Patching

Here's what we've been using recently. This is in an interval of 1 month, so if you want it current you'll just need to take that out.

This report is for Recommended patches, so you'll need to adjust that at the bottom of the code for what you're wanting. I run 3 separate reports for Low, Recommended, and Critical.  If you want all severity in one report, just remove "  PP.SEVERITY != 'recommended'  "

Header is: Computer Name , Op System, Version, Last Username, IP, Agent Version, Last Inventory, Last Reboot, # installed patches, # Not installed, and percentage.  

SELECT

M.NAME AS Computername,

OS_NAME AS Operatingsystem,

CASE M.OS_BUILD

WHEN '7600' THEN 'Windows 7'

WHEN '7601' THEN 'Windows 7 SP1'

WHEN '9600' THEN '2012R2'

WHEN '10240' THEN '1507 (RTM)'

WHEN '10586' THEN '1511'

WHEN '14393' THEN '1607'

WHEN '15063' THEN '1703'

WHEN '16299' THEN '1709'

WHEN '17134' THEN '1803'

WHEN '17763' THEN '1809'

WHEN '18362' THEN '1903'

WHEN '18363' THEN '1909'

ELSE 'Unknown OS Build'

END

AS 'Version',

LAST_USER as Username,

M.IP as IPAdress,

CLIENT_VERSION as Agentversion,

M.LAST_SYNC as LastInventory,

M.LAST_REBOOT as LastReboot,

SUM(MS.DETECT_STATUS = 'PATCHED') AS Installed,

SUM(MS.DETECT_STATUS = 'NOTPATCHED') AS Notinstalled,

FLOOR(ROUND((SUM(MS.DETECT_STATUS = 'PATCHED') / (SUM(MS.DETECT_STATUS =

'PATCHED') + SUM(MS.DETECT_STATUS = 'NOTPATCHED'))) * 100,1)) AS

Percent

FROM

PATCH_MACHINE_STATUS MS

JOIN KBSYS.PATCH PP ON (PP.ID = MS.PATCH_ID)

JOIN PATCH_STATUS PPS ON (PPS.PATCH_ID = PP.ID)

JOIN MACHINE M ON (M.ID = MS.MACHINE_ID)

JOIN KBSYS.SMMP_CONNECTION SC ON (M.KUID = SC.KUID)

WHERE (Last_Sync > CURDATE() - INTERVAL 1 MONTH) AND

PPS.STATUS = 0

and PP.SEVERITY != 'recommended' AND PPS.IS_SUPERCEDED = 0

GROUP BY MS.MACHINE_ID

ORDER BY Percent , M.NAME

This one is just for a certain label, which is Servers on this report. Only showing Machine name, Windows Version, Patched, Not Patched, and percentage. This is my Recommended patches for devices with label servers, also in 1 month interval.

SELECT 

M.NAME AS MACHINE_NAME,

OS_NAME AS WINDOWS_VERSION,

SUM(MS.DETECT_STATUS = 'PATCHED') AS PATCHED,

SUM(MS.DETECT_STATUS = 'NOTPATCHED') AS NOTPATCHED,

FLOOR(ROUND((SUM(MS.DETECT_STATUS = 'PATCHED') / (SUM(MS.DETECT_STATUS =

'PATCHED') + SUM(MS.DETECT_STATUS = 'NOTPATCHED'))) * 100,1)) AS

PERCENT_PATCHED

FROM 

PATCH_MACHINE_STATUS MS

JOIN KBSYS.PATCH PP ON (PP.ID = MS.PATCH_ID)

JOIN PATCH_STATUS PPS ON (PPS.PATCH_ID = PP.ID)

JOIN MACHINE M ON (M.ID = MS.MACHINE_ID)

JOIN KBSYS.SMMP_CONNECTION SC ON (M.KUID = SC.KUID)

JOIN MACHINE_LABEL_JT ML ON (M.ID = ML.MACHINE_ID)

JOIN LABEL L ON (ML.LABEL_ID = L.ID)

WHERE (Last_Sync > CURDATE() - INTERVAL 1 MONTH) AND

PP.SEVERITY = 'Recommended'

AND PPS.STATUS = 0

AND PP.IS_SUPERCEDED = 0

AND L.NAME = 'Servers'

GROUP BY M.NAME

ORDER BY PERCENT_PATCHED, M.NAME

These reports work on v10

Hope this helps!