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!!
0 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
dugullett
12 years ago
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"
Posted by:
dugullett
12 years ago
Is there a patch label associated with these patches? I'm guessing you would just want that one label instead of all patches?
Comments:
-
Well my patch lables are setup like "Win7 Sec critical" WinXp Sec Critcal". But I was asked if I can tell what patches were deployed to our OSs during certain months. I assume it to make sure that we are in compliance.... Is that any help?? - cwest311 12 years ago
