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!!

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

3

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"

Answered 07/26/2012 by: dugullett
Red Belt

Please log in to comment

Answers

1

Is there a patch label associated with these patches? I'm guessing you would just want that one label instead of all patches?

Answered 07/26/2012 by: dugullett
Red Belt

  • 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??
Please log in to comment
Answer this question or Comment on this question for clarity

Share