Question on Available Reports
Couple of questions regarding some reports that I need.
First, when viewing a computer in Inventory, it will list the hardware and software changes. Is there a report that I can generate that will list these? If not, can someone point me in the direction what I need to create this report?
Second, I have a custom report that lists patches installed in the past X amount of days:
SELECT PP.TITLE AS PATCH_NAME,
M.NAME AS COMPUTER_NAME,
PP.IDENTIFIER AS KB_ARTICLE
FROM PATCHLINK_MACHINE_STATUS MS
JOIN KBSYS.PATCHLINK_PATCH PP ON PP.UID = MS.PATCHUID
JOIN PATCHLINK_PATCH_STATUS PPS ON PPS.PATCHUID = PP.UID
JOIN MACHINE M ON M.ID = MS.MACHINE_ID
WHERE MS.STATUS = 'PATCHED'
AND (DEPLOY_STATUS_DT > CURDATE() - INTERVAL 7 DAY)
ORDER BY M.NAME
Will this only list the patches installed by KACE, or will it list the Windows update if performed manually?