Page 1 of 1

Script to run/export reports on WSUS

Posted: Mon Jun 18, 2007 1:59 am
by udiggity
I am wondering if it is possible to write a VBScript that will query my WSUS server for a report of PC's that did not recieve that last set of patches. I have looked all over and haven't seen anywhere that someone else has tried this, so I don't even know if it is possible. Hoping someone can point me in the right direction! Thanks for any and all assistance you can provide!

Script to run/export reports on WSUS

Posted: Mon Jun 18, 2007 3:42 am
by udiggity
Yeah I have this script. This runs on the client side. I'd like to query the server itself and have it tell me what clients have connected... I would need to run this on every client (I have over 1000) to find out...

Thanks for the reply though, I do appreciate it!

Script to run/export reports on WSUS

Posted: Mon Jun 18, 2007 4:18 am
by jvierra
I believe there is a report that runs on WSUS. It tells sync status.

Script to run/export reports on WSUS

Posted: Mon Jun 18, 2007 4:50 am
by jvierra
Export the report an parse it. That would be the easiest way I think.

Script to run/export reports on WSUS

Posted: Mon Jun 18, 2007 5:02 am
by jvierra
Here is a script you can modify. It's for POwerShell but will give you what you want.

http://www.microsoft.com/technet/script ... x?mfr=true


Script to run/export reports on WSUS

Posted: Mon Jun 18, 2007 5:08 am
by udiggity
Thanks, I found this script earlier but had a hard time figuring out how to do it in VB as I don't have powershell running...

I'll have a looksie at it and see if I can get it working... Thank you so much for all of your effort!

Script to run/export reports on WSUS

Posted: Mon Jun 18, 2007 5:59 am
by jvierra
Here is the config page for the report. You can filter it by any status you want.



Yhe "Include Updates that have a status of: link - click it and set the status you need. You can also filter by computer groups or patch type etc.


In the PoSH script just set the .status = 'failed' or 'missing' or alter any of the properties to filter as needed.

jvierra2007-06-19 09:21:42

Script to run/export reports on WSUS

Posted: Tue Jun 19, 2007 2:24 am
by jvierra
The image should be visible now.

Had to link it to a public area so it could be seen by all.

I was able to get an Excel spreadsheet export of al of the "failed" or "missing" hosts.

Are you sure you are running WSUS? Are you running WSUS 1.0? That won't work with PowerShell but can use VBScript.


Script to run/export reports on WSUS

Posted: Tue Jun 19, 2007 3:45 am
by jvierra

Here are teh docs and tools for 2.0

http://technet.microsoft.com/en-us/wsus/bb466192.aspx

MS says 2.0 is deprecated as of teh release of 3.0 so you should upgrade quickly.

You need 3.0 to get all of teh updates and reports.