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.
This topic is 16 years and 9 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked
User avatar
udiggity
Posts: 6
Last visit: Tue Mar 11, 2008 12:06 am

Script to run/export reports on WSUS

Post 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!
User avatar
udiggity
Posts: 6
Last visit: Tue Mar 11, 2008 12:06 am

Script to run/export reports on WSUS

Post 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!
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Script to run/export reports on WSUS

Post by jvierra »

I believe there is a report that runs on WSUS. It tells sync status.
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Script to run/export reports on WSUS

Post by jvierra »

Export the report an parse it. That would be the easiest way I think.
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Script to run/export reports on WSUS

Post 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

User avatar
udiggity
Posts: 6
Last visit: Tue Mar 11, 2008 12:06 am

Script to run/export reports on WSUS

Post 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!
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Script to run/export reports on WSUS

Post 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
jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Script to run/export reports on WSUS

Post 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.

jvierra
Posts: 15439
Last visit: Tue Nov 21, 2023 6:37 pm
Answers: 30
Has voted: 4 times
Been upvoted: 33 times

Script to run/export reports on WSUS

Post 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.
This topic is 16 years and 9 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
Locked