Need help with powershell script to get the list of systems and when they were last patched

Question

Hello Everyone,

Need help with getting the list of systems and also when they were last patched.

Answer 1

Hi @Neelesh Kumar Tiwari ,

could please try this:

Get-Hotfix|Where-Object {$_.Installedon -gt ((Get-Date).Adddays(-90))}|Select-Object -Property PSComputerName,InstalledOn, HotFixID, InstalledBy|Format-Table  

Based on this website the computer name should be the parameter Source:
https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.management/get-hotfix?view=powershell-7.1#example-1--get-all-hotfixes-on-the-local-computer

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Hi @Neelesh Kumar Tiwari ,

maybe this is helpful to get started:

https://p0w3rsh3ll.wordpress.com/2012/10/25/getting-windows-updates-installation-history/

Otherwise please post your script you got so far.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 3

Hello @Anonymous , Thanks I did Get-Hotfix and get the details but my requirement is to get the list of systems when it was last time patched so I tried the below command and getting the output for 90 days but computer name is not coming so any idea how can I fix this.

Get-Hotfix|Where-Object {$_.Installedon -gt ((Get-Date).Adddays(-90))}|Select-Object -Property Computername, KBArticle,InstalledOn, HotFixID, InstalledBy|Format-Table