/build/static/layout/Breadcrumb_cap_w.png

Report To Show Recently Installed Patches

I'm looking for a field to search on in a report to show recently installed patches, ie past 7 days or entering a specific date in the SQL query. I'm wanting to pull up a report after patching that shows what patches were installed sorted by computer after we run a patch job. It's too time consuming to go to each computer in Inventory to pull up this information. Thanks.


0 Comments   [ + ] Show comments

Answers (2)

Answer Summary:
SELECT DISTINCT M.NAME, IP, P.TITLE, PM.DEPLOY_STATUS_DT AS 'DEPLOY DATE', PM.STATUS FROM MACHINE M LEFT JOIN PATCHLINK_MACHINE_STATUS PM ON M.ID=PM.MACHINE_ID LEFT JOIN KBSYS.PATCHLINK_PATCH P ON P.UID=PM.PATCHUID WHERE (DEPLOY_STATUS_DT > CURDATE() - INTERVAL 7 DAY)
Posted by: dugullett 11 years ago
Red Belt
5

Something like this will get you going. If you need it to include more detail let me know.

SELECT DISTINCT M.NAME, IP, P.TITLE, PM.DEPLOY_STATUS_DT AS 'DEPLOY DATE', PM.STATUS

FROM MACHINE M

LEFT JOIN PATCHLINK_MACHINE_STATUS PM ON M.ID=PM.MACHINE_ID

LEFT JOIN KBSYS.PATCHLINK_PATCH P ON P.UID=PM.PATCHUID

WHERE (DEPLOY_STATUS_DT > CURDATE() - INTERVAL 7 DAY)

*Break on M.NAME


Comments:
  • This got me going in the right direction, thanks. - jeffwbrown 11 years ago

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