PowerTip: Find Windows Hotfixes Installed After a Certain Date

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

IamMred — Fri, 08 Feb 2013 17:43:40 GMT

My 1/15/2013 is EN-US date time format. You can use the date time format that is appropriate for your culture, and PowerShell will automatically convert it to a datetime object for you.

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

IamMred — Fri, 08 Feb 2013 17:42:26 GMT

@Thomas yes Get-Hotfix works on anything with PowerShell 2.0 installed on. So it works by default on Windows 7, Windows Server 20008 R2 and of course Windows 8 and Windows SErver 2012.

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

IL — Tue, 05 Feb 2013 06:16:20 GMT

@JV Thank you! I haven't noticed the time jump into September 2013! I was thinking about September 2012. It is very strange to have such a thing I guess. In fact the command just detected it.

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

JV — Mon, 04 Feb 2013 22:22:15 GMT

@IL

01.09.2013 is a European format for September 1 2013. This is clearly greater than 1-13-2013.

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

IL — Mon, 04 Feb 2013 12:35:38 GMT

@JV Thank you, but

Get-HotFix | where { $_.installedon -gt [datetime]'01/15/2013'}

does the same. What time should I specify to make it work in case I don't really need to filter by time just by date?

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

JV — Fri, 01 Feb 2013 18:08:11 GMT

@IL

Think about what teh date you used means. -gt "01/15/2013" is any time after midnight on 1-13. Any installation that occurred from 00:00:00 on will be included. YOu need to add one day or specify the time.

[datetime]'01/13/2013'

look at the time field. It will be 12:00AM

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

IL — Fri, 01 Feb 2013 07:22:08 GMT

Why does it show hotfixes installed on 9/1/2013?

PS E:\> Get-HotFix | where { $_.installedon -gt "01/15/2013"}

Source Description HotFixID InstalledBy InstalledOn

------ ----------- -------- ----------- -----------

FLAWLESS Security Update KB2736422 NT AUTHORITY\SYSTEM 01.09.2013...

FLAWLESS Security Update KB2742599 NT AUTHORITY\SYSTEM 01.09.2013...

FLAWLESS Security Update KB2756921 NT AUTHORITY\SYSTEM 01.09.2013...

FLAWLESS Security Update KB2757638 NT AUTHORITY\SYSTEM 01.09.2013...

FLAWLESS Security Update KB2769369 NT AUTHORITY\SYSTEM 01.09.2013...

FLAWLESS Security Update KB2778930 NT AUTHORITY\SYSTEM 01.09.2013...

FLAWLESS Security Update KB2785220 NT AUTHORITY\SYSTEM 01.09.2013...

FLAWLESS Update KB2786081 NT AUTHORITY\SYSTEM 01.09.2013...

Perhaps it is a date to string conversion effect. How to place the date immune to system locale? May be something like 20130115 or convert(datetime, "20130115").

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

Marius — Fri, 01 Feb 2013 06:11:14 GMT

Requires powershell 2.0 for the get-hotfix cmdlet. :)

re: PowerTip: Find Windows Hotfixes Installed After a Certain Date

Thomas — Thu, 31 Jan 2013 23:08:13 GMT

Does this work on other OS besides Windows 8? Say Server 2008 R2 or Win 7 or Server 2012?