Link to home
Start Free TrialLog in
Avatar of bsharath
bsharathFlag for India

asked on

Fetch all computers and the folder names from WSUS . When script run we need to get all data possible.

Hi,

Fetch all computers and the folder names from WSUS . When script run we need to get all data possible.

Regards
Raja
Avatar of RobSampson
RobSampson
Flag of Australia image

I have not scripted again WSUS before, but I would suggest you try this script:

WSUS Client Report Script by -- Rob Dunn
https://msmvps.com/blogs/athif/archive/2006/05/17/95443.aspx

it looks like a good start.

Regards,

Rob.
Avatar of bsharath

ASKER

Thanks Rob can you help me to find the details that we need to feed the DB etc
Just out of curiosity, what benefit is there of having this info? :)

What do you mean by "Folder names" ?
It looks all you need to specify are the two values here:
'Your WSUS server.  If you are running remote SQL, enter your SQL server name
' here instead.
strWSUSDBServer = "sadadsms-mn" 

'Your WSUS server - i.e. where you run the administration from.  If you are 
' not running remote SQL, then this variable should be the same as the variable
' above.
strWSUSServer = "sadadsms-mn:8530"

Open in new window


and when you are prompted for the computer name, you should be able to put a * character.

Regards,

Rob.
Thanks rob but it asks one machine name
* did not work
Does a single machine work?

Rob.
It gets the machine name with suffix to a html page and when clicked it opens a blank page
I'll have to try and test against my WSUS server on Monday....I won't have access to it until then.

Rob.
Ok np thanks
Please help on others the ping and reg posts
ASKER CERTIFIED SOLUTION
Avatar of RobSampson
RobSampson
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial