PowerShell

PowerShell is King – Getting a massive amount of hotfixes from the Windows Update Site

Working for a customer in Norway, I received a list of “hotfixes” that needs to be downloaded and imported into WSUS for distribution, number of patches was 90. I have not found any great way to automate download from the Update Catalog into WSUS (there must be). So the here is the ugly version:

The ugly PowerShell script that starts Internet Explorer and add every patch to a separate tab

$Urls = Get-Content -Path C:\Temp\hotfixes.txt

$TabSettings = 0x1000;
$ie = New-Object -ComObject InternetExplorer.Application
$ie.Navigate2("http://www.microsoft.com");
foreach($Url in $Urls){
    $ie.Navigate2("$Url", $TabSettings);
}
$ie.Visible = $true;

The content of hotfixes.txt

http://catalog.update.microsoft.com/v7/site/Search.aspx?q=2965733
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=2981330
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3000123
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3014795
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3020813
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3020773
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3022333
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3027115
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3027110
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3025080
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3027108
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3023894
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3020717
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=2970653
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3033917
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3036614
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3042121
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3046481
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3042127
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3044457
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3046826
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3031598
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3036173
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3047296
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3018489
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3049448
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3047280
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3052122
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3049443
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3061460
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3060678
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3063283
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3068445
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3072380
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3068444
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3072381
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3077354
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3075610
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3076950
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3076946
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3075161
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3078411
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3080728
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3078584
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3076953
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3012714
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3073062
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3087856
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3078420
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3025091
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3078631
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3094197
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3053667
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3093571
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3090322
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3093272
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3094199
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3094209
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3095711
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3082343
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3093899
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3093550
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3095319
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3091403
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3084093
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3095308
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3091057
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3090973
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3092005
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3095663
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3091402
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3063109
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3102354
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3105881
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3100527
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3101694
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3087288
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3092604
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3100477
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3080141
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3084463
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3102770
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3109099
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3102997
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3114133
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3109973
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3123538
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3127673
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3123593
http://catalog.update.microsoft.com/v7/site/Search.aspx?q=3107677

Categories: PowerShell

Tagged as:

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.