As most people know, Microsoft releases patches on the second Tuesday of the month. In some organizations these patches are deployed to development, test and QA systems within a couple of days of the release. However, production systems can’t be patched until the next maintenance window. Assuming this patch window is on a Saturday, we need to find the first Saturday after the second Tuesday. When looking at a calendar this is pretty simple for most people to figure out. However, when you need a whole years worth it takes a few minutes to calculate. What we need is some code to look these up for us…like this function:<\/p>\n
\r\nFunction Get-WsusSaturday {\r\n param([datetime]$date=(Get-Date) ) \r\n $numberOfTuesdays=0 \r\n \r\n 1..([datetime]::DaysInMonth( $date.year , $date.month )) | %{ \r\n $thisDate = Get-Date \"$($date.month)\/$($_)\/$($date.year)\"\r\n if ([string]$thisDate.DayOfWeek -eq 'Tuesday') {\r\n $numberOfTuesdays++ \r\n if ($numberOfTuesdays -eq 2) { \r\n $thisDate.AddDays(4).ToLongDateString() \r\n }\r\n }\r\n }\r\n}\r\n<\/code><\/pre>\nLine 2: accept the date as a parameter and cast it to a date\/time value, defaulting to today’s date if nothing is provided
\nLine 3: max sure we don’t think its Tuesday already
\nLine 5: starting on the first of each month, loop through the max number of days in the month
\nLine 8: if the date is Tuesday, add one to the counter
\nLine 9: once we find the second Tuesday
\nLine 10: add 4 more days to find the following Saturday and return the date text<\/p>\n
You can take this function and do something creative, like find the next 5 years worth of patch Saturdays.<\/p>\n
\r\n13..18 | %{\r\n $year = $_\r\n 1..12 | %{ Get-WsusSaturday \"$_\/1\/$year\" }\r\n}\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"As most people know, Microsoft releases patches on the second Tuesday of the month. In some organizations these patches are deployed to development, test and QA systems within a couple of days of the release. However, production systems can’t be … Continue reading