Script to run/export reports on WSUS

Anything VBScript-related, including Windows Script Host, WMI, ADSI, and more.
Forum rules
Do not post any licensing information in this forum.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
Locked
User avatar
udiggity
Posts: 6
Joined: Mon Jun 18, 2007 1:55 am

Script to run/export reports on WSUS

Post by udiggity » Mon Jun 18, 2007 1:59 am

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!

User avatar
udiggity
Posts: 6
Joined: Mon Jun 18, 2007 1:55 am

Script to run/export reports on WSUS

Post by udiggity » Mon Jun 18, 2007 3:42 am

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!

jvierra
Posts: 13881
Joined: Tue May 22, 2007 9:57 am
Contact:

Script to run/export reports on WSUS

Post by jvierra » Mon Jun 18, 2007 4:18 am

I believe there is a report that runs on WSUS. It tells sync status.

jvierra
Posts: 13881
Joined: Tue May 22, 2007 9:57 am
Contact:

Script to run/export reports on WSUS

Post by jvierra » Mon Jun 18, 2007 4:50 am

Export the report an parse it. That would be the easiest way I think.

jvierra
Posts: 13881
Joined: Tue May 22, 2007 9:57 am
Contact:

Script to run/export reports on WSUS

Post by jvierra » Mon Jun 18, 2007 5:02 am

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


User avatar
udiggity
Posts: 6
Joined: Mon Jun 18, 2007 1:55 am

Script to run/export reports on WSUS

Post by udiggity » Mon Jun 18, 2007 5:08 am

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!

jvierra
Posts: 13881
Joined: Tue May 22, 2007 9:57 am
Contact:

Script to run/export reports on WSUS

Post by jvierra » Mon Jun 18, 2007 5:59 am

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

jvierra
Posts: 13881
Joined: Tue May 22, 2007 9:57 am
Contact:

Script to run/export reports on WSUS

Post by jvierra » Tue Jun 19, 2007 2:24 am

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.


jvierra
Posts: 13881
Joined: Tue May 22, 2007 9:57 am
Contact:

Script to run/export reports on WSUS

Post by jvierra » Tue Jun 19, 2007 3:45 am


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.

Locked