Date of Last Patch Installed
Anyone have success with a Report that shows when a patch was last installed for each device under all device labels? (Regardless if KACE patched it or not.) Would it be better to focus on a script or could this be added as a SQL line in one of the reports? I see a script that calls a Text file for a server list but I would like to avoid having to keep a text file up to date. Ideally is a report that shows each computer name with the latest date of the last patch next to it. And that's it.
This is a report based on the asset history and software table. It reports the last software detected on the machine that is marked in the software table as a patch:
SELECT MACHINE.NAME, ASSET_HISTORY.ASSET_ID,
JOIN ASSET ON ASSET.ID = ASSET_HISTORY.ASSET_ID
JOIN MACHINE ON ASSET.NAME = MACHINE.BIOS_SERIAL_NUMBER
JOIN SOFTWARE ON SOFTWARE.DISPLAY_NAME = ASSET_HISTORY.VALUE1
WHERE CHANGE_TYPE = "Detected"
AND FIELD_NAME = "SOFTWARE"
AND SOFTWARE.IS_PATCH = 1
GROUP BY ASSET_ID
ORDER BY MACHINE.NAME
I'm not sure how accurate it will be, but it might be a good place to start.