Last week I was sent an email with an Excel spreadsheet containing a bunch of Microsoft TechNet KB articles that were being considered in the context of being applied to a Windows Server farm.

I had no idea what all of these KB articles were (who does after all?) so wanted to take a peek over them to get the lowdown on what was being proposed.

Given that there were 21 KB articles referenced in the spreadsheet, I really did not want to manually open each one.

Guess what? PowerShell to the rescue.

Knowing that I could parse my way over a CSV file (easily created from Excel), manipulate Internet Explorer as a COM object and that all KB articles are stubbed by the same URL (http://support.microsoft.com/kb/”, all I had to do was loop over the CSV and spawn a stack of IE tabs which I could then review at my leisure.

$content = Import-Csv .\kb.csv
$iexplore = New-Object -ComObject internetexplorer.application
foreach ($kb in $content) {
   $url = "http://support.microsoft.com/kb/"+$kb.KB
   $iexplore.Navigate($url,65536)
}
$iexplore.Visible = $true

Simples!

more to follow…