Report for all security patches deployed by certain month
I was curious if anyone could tell me how to write a script to tell me all the security updates that were applied during a certain month, if thats even possible. I would like the name of the patch that was installed and how many machines it was able to depoly/fail.
Thanks in advance!!
Community Chosen Answer
You can use this.
select P.TITLE AS DISPLAY_NAME, MACHINE.NAME as ComputerName, MACHINE.USER_LOGGED as USER,
IP, STATUS from PATCHLINK_MACHINE_STATUS S, MACHINE, KBSYS.PATCHLINK_PATCH P where MACHINE.ID = S.MACHINE_ID and S.PATCHUID = P.UID and P.RELEASEDATE > CURDATE() - INTERVAL 30 DAY order by P.TITLE
Make sure to break on "DISPLAY_NAME"