Finding Indivudual Patches using the WSUS files

Dear Folks -

In addition to its automatic updates, we used our old SUS server to manually
get patches and service packs as we needed them for standalone install. SUS
saved all the patches and service pack files in a friendly file format in a
single directory which made finding any patch easy. This worked well and we
frequently used SUS's files to dig out large service pack files and so on
instead of downloading them from Microsoft every time you needed one. This
also saved tech support staff from having to build their own redundant
'collections' - we also knew we were always getting the latest version every
time and not a stale patch from an older patch collection.

We also have a lot of computers in the field with nothing faster than a
28.8k modem (Broadband is not everywhere yet!) and it was great to make a
cd-rom containing these patches to physically carry out to these slow
machines located in rural areas.

Unfortunately, WSUS no longer stores the patches in a friendly file name
format, but all the patches are saved right there in the WSUS directory.
Redundant sets of patches and service packs are sprouting up again...

Does anyone have any scripts or has written a SQL search that will locate
the respective patch using the friendly name or patch number? I'd like to be
able to click on the WSUS admin page and have it display the WSUS file name
directly. our WSUS server to be able to serve up individual patches up

FYI, there is a WSUS newsgroup :
http://www.microsoft.com/windowsserv...newsgroup.mspx
Might be better to ask your question there.

MowGreen [MVP 2003-2006]
===============
*-343-* FDNY
Never Forgotten
===============

ItsBrokenAgain! wrote:

> Dear Folks -
>
> In addition to its automatic updates, we used our old SUS server to manually
> get patches and service packs as we needed them for standalone install. SUS
> saved all the patches and service pack files in a friendly file format in a
> single directory which made finding any patch easy. This worked well and we
> frequently used SUS's files to dig out large service pack files and so on
> instead of downloading them from Microsoft every time you needed one. This
> also saved tech support staff from having to build their own redundant
> 'collections' - we also knew we were always getting the latest version every
> time and not a stale patch from an older patch collection.
>
> We also have a lot of computers in the field with nothing faster than a
> 28.8k modem (Broadband is not everywhere yet!) and it was great to make a
> cd-rom containing these patches to physically carry out to these slow
> machines located in rural areas.
>
> Unfortunately, WSUS no longer stores the patches in a friendly file name
> format, but all the patches are saved right there in the WSUS directory.
> Redundant sets of patches and service packs are sprouting up again...
>
> Does anyone have any scripts or has written a SQL search that will locate
> the respective patch using the friendly name or patch number? I'd like to be
> able to click on the WSUS admin page and have it display the WSUS file name
> directly. our WSUS server to be able to serve up individual patches up
>