[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

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
0
bsharath
Asked:
bsharath
  • 5
  • 4
1 Solution
 
RobSampsonCommented:
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.
0
 
bsharathAuthor Commented:
Thanks Rob can you help me to find the details that we need to feed the DB etc
0
 
Donald StewartNetwork AdministratorCommented:
Just out of curiosity, what benefit is there of having this info? :)

What do you mean by "Folder names" ?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RobSampsonCommented:
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.
0
 
bsharathAuthor Commented:
Thanks rob but it asks one machine name
* did not work
0
 
RobSampsonCommented:
Does a single machine work?

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

Rob.
0
 
bsharathAuthor Commented:
Ok np thanks
Please help on others the ping and reg posts
0
 
RobSampsonCommented:
OK, I've tested against my SUS server, but I had to run the script directly from the same server, using
strWSUSDBServer = "SERVERNAME\WSUS"
as the database server because is a local SQL installation.

Anyway, I don't think that's a problem because you got the report to open with the machine names, so what you've got should be fine.

To show all computers, just enter one letter that is common to your domain suffix and it will grab all computers.

When I clicked on of the computers links, it took quite a while for the detail to come up, but it eventually did....

Rob.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now