Web page solution to search/extract updates from WSUS content folder by — Robert Collewijn

This web page solution by Robert Collewijn will display (search/extract update) information about the update files and there location within the content directory structure. This enables to search for updates on WSUS Server and can be downloaded locally. The updates are stored in a content folder on the WSUS server with unrecognizable 40 character file name (C6C8B597D4268C65AFFC94C34F46C9147B109329.exe). This web page will display filename and download link & location associated with that unrecognizable 40 character file name. All you have to do is use the search option at top right to with the KB number. Give it a try! STEP-BY-STEP Download HotfixInfo.zip (inclusive … Continue reading Web page solution to search/extract updates from WSUS content folder by — Robert Collewijn

Perl script to extract updates from WSUS content folder by — Alexey Biznya

This script by Alexey Biznya will Extract and sort by Categories latest or all updates from \WSUSContent folder. The script will find \WSUSContent folder and SQL Server name from the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Update Services\Server\Setup. [WSUS stores updates in \WSUSContent folder using SHA1 hash for file names and this script will query WSUS SQL/MSDE database and then exports those updates and categories.] Requirements Windows 2000+ ActivePerl 5.8.7 build 815 or higher from www.ActiveState.com osql.exe Utility (included in MSDE) Tunable params my $root = “C:\\WSUS\\FtpRoot”; Make sure \WSUSContent folder and the folder where it will extract the files should be on the same volume. For … Continue reading Perl script to extract updates from WSUS content folder by — Alexey Biznya

Batch script to extract updates from WSUS content folder by — Alexander Suhovey

This script by Alexander Suhovey will extract/copy particular updates from WSUS content folder. WSUS stores updates in \WSUSContent folder using SHA1 hash for file names and this script will attempt to decrypt SHA1 hash for file names by querying  WSUS SQL/MSDE database and then exports those updates as well. Command line switches to run the script SYNTAX:   WSUSExtract.cmd <-f:search_string> [-l:lang] [-t:target] -f:search_string   – Part of update KB to search for. -l:lang      – Update language. If omitted, all languages will be processed. -t:target  – Target folder to copy updates to. If omitted, script assumes ‘View Only’ mode. Examples The command below will … Continue reading Batch script to extract updates from WSUS content folder by — Alexander Suhovey

Configuring WSUS clients in a workgroup using WSUSClientManager by — Greg Chapman[MVP]

So, if you are in a workgroup environment and would like to configure WUA on workstations, then you might want to check WSUSClientManager – an Excel automation tool by Greg Chapman. Greg recently posted this information on WSUS Mailing List; WSUSClientManager is created in Excel 2003. Operation is simple and requires you to set your Excel macro security to Medium. Medium allows you to be prompted about disabling or enabling macros in an Excel document. The default setting is high and will prevent the VBA code in the spreadsheet from executing. Open the Excel doc and enable macros when prompted. … Continue reading Configuring WSUS clients in a workgroup using WSUSClientManager by — Greg Chapman[MVP]

Windows Update Agent force script, email results version 2.3 by — Rob Dunn [WSUS MVP]

Rob Dunn [WSUS MVP] has created an excellent .vbs script (updatehf.vbs) which is very popular in WSUS Community. This script will do the following; Detects missing updates, Downloads approved updates which are missing, Installs the approved updates from WSUS Server, And reboots the computer after the updates are applied. Last but not the least; it can email a recipient the resulting log file. Before you run this script, rename the downloaded script to updatehf.vbs and you need to edit some variables in the script; MANDATORY VARIABLES sExePath – this is the location of the WindowsUpdateAgent20-x86.exe. Download it from http://go.microsoft.com/fwlink/?LinkId=43264. This script … Continue reading Windows Update Agent force script, email results version 2.3 by — Rob Dunn [WSUS MVP]

Welcome to WSUS Scripts & WSUS Tools Repository

So, these days I am trying to collect information (as much as I can) on WSUS Scripts & WSUS Tools in the community and host a dedicated blog for WSUS Scripts & Tools Repository. If you are aware of any such tools then kindly let me know.  You can either Contact me or drop a comment. New!!! WSUS Scripts and WSUS Tools Repository!. Stay tuned!.

Delete Older Not Reported Stale Computers

Is it possible to configure WSUS to delete older computers which are not reported in WSUS for quite a time? To clean up the old computer objects, use CleanStaleComputers from Windows Server Update Services API Samples and Tools. CleanStaleComputers: This sample application removes computers from the Update Services server that have not contacted the server in a specified number of days. USAGE: CLEANSTALECOMPUTERS /DAYS:[1-365] /DELETE:{YES | NO} /PROMPT:{YES | NO} /DAYS. Days since the computer contacted the server /DELETE. Delete from the Update Services server or move to the Stale computers group /PROMPT. Prompt before moving/deleting computers  WSUS Product Team has … Continue reading Delete Older Not Reported Stale Computers

Excellent Script to detect or download just the IMF Update

Scott Roberts posted an excellent vb script on http://blogs.technet.com/exchange/archive/2006/04/12/425060.aspx which can detect or download just the IMF Update’s based on the parameter passed whilst executing the script. This script is very handy as it detects / downloads IMF updates only. To enable IMF updates using WSUS, take a look at my previous blog entry; Updating Intelligent Message Filter v2 via WSUShttp://msmvps.com/blogs/athif/archive/2006/03/21/Updating_Intelligent_Message_Filter_v2_via_WSUS.aspx USAGE: cscript //nologo imfUpdateScript.vbs Detect (this command will detect IMF updates). cscript //nologo imfUpdateScript.vbs Install (this command will install IMF updates). NOTE: I have saved the script as imfUpdateScript.vbs. Scott also promised a post on the WSUS blog next week on how to create a script … Continue reading Excellent Script to detect or download just the IMF Update

WSUS will not provide HOT FIXES

Many-a-times WSUS Admins, wonder if they can automatically deploy hot fixes which are not supported by WSUS or which are not available on WindowsUpdate.com. The simple answer is NO and you have to use SMS or some script to install them. Alternately, If the computers are in an Active Directory Domain, then you might want to take a look at this excellent script posted by Torgeir Bakken (MVP). Notes from Torgeir Bakken (MVP): You should do it in a computer startup script (with a GPO that is applied to you computers) instead of a logon script. A computer startup script runs as … Continue reading WSUS will not provide HOT FIXES

WSUS TOOL: Copying Approvals Between Target Groups

You can use the WSUS API to copy update approvals from one WSUS group to another. Yasufumi Shiraishi [MSFT] has posted the code and the procedure to get a tool that copies update approvals from one computer group to another, Some additional notes about the utility from Torgeir Bakken (MVP) on microsoft.public.windows.server.update_services: 1. The utility is a command line based utility, you need to specify the “from” and “to” group names on the command line. 2. If a group name contains spaces, you need to surround it with quotes, like this: “Test group”. 3. The naming of the groups is case … Continue reading WSUS TOOL: Copying Approvals Between Target Groups