Need help converting old report
We had a "Missing Patches" report in Version 9 of KACE. We use this on a constant basis. The SQL scripting for this is below:
PP.TITLE AS DISPLAY_NAME,
(CASE PP.TYPE WHEN 0 THEN 'Non-Security' WHEN 1 THEN 'Security' ELSE '' END) AS TYPE,
M.NAME AS ComputerName,
(CASE PP.IS_SUPERCEDED WHEN 1 THEN 'Yes' ELSE 'No' END) AS SUPERSEDED
FROM PATCH_MACHINE_STATUS MS
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
JOIN MACHINE M ON M.ID = MS.MACHINE_ID
WHERE MS.STATUS = 'NOTPATCHED'
ORDER BY PP.TITLE, M.NAME
Does anyone have any idea how to convert this to the new tables for Version 10? I know that the tables were changed and it broke some of the custom reports, I am just hoping that someone might have a secret decoder ring to help out with this.