Sunday #PowerShell #PowerTweet – Opening multiple #Microsoft Knowledgebase articles

By | March 9, 2014

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 (”, 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.


more to follow…

Leave a Reply

Your email address will not be published. Required fields are marked *