Configure Database Distribution Lists

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Configure Database Distribution Lists

Postby gsc_ghx » Thu Sep 29, 2011 11:09 pm

When I installed Multiscript it automatically 'detected' a number of SQL Servers on our network. I had to add some that it did not find. I want to remove several of the servers it 'found' that I do not use nor have access to as they are developer's servers. How can I remove these automaticaly added servers? I can remove those that I add but not the ones that are automatically detected and added.

Thanks
Geri
gsc_ghx
 
Posts: 51
Joined: Tue Dec 04, 2007 10:33 pm

Postby james.billings » Mon Oct 03, 2011 1:19 pm

Hi, and thanks for your post.

When you click "Configure" in Multi Script, it'll search your network to give you a list of available servers. This works by running a query that partly relies on the SQL Browser service running on the servers, and could explain why some weren't listed and you had to add them manually (i.e. they couldn't be detected).

Once you have the ones you want in the list, you then click "Add" to move the ones you want to actually work with over to the right. You can add them to the default list, or create a new list of servers by clicking "New" at the top, and entering a name - for instance, "Geri's list".

Once you OK that, then you can select your list in the main SQL Multi Script screen and you'll just be working with the servers you want.

Regarding your original query of removing servers from the selection screen, this isn't possible unfortunately, as a search is performed when you go into that screen. The idea here is to present you a list of as many servers as possible to minimise the need to add them manually. The lists enable you to then work with just the ones you want, so the extra ones aren't in the way.

Hope that makes sense.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.

Most server missing in the Databases to Add

Postby facklec » Wed May 07, 2014 8:33 pm

The Configure Database Distribution List is missimg almost all of our servers and is showing many workstation I'm not interested in. We have about 30 SQL servers and only one is listed (we have probably 100+ servers and 5,000 workstations). I'd like to apply a filter (e.g. all servers like "SQL*" with the ability to use wildcards.
facklec
 
Posts: 5
Joined: Wed Jun 26, 2013 7:36 pm
Location: Olympia, WA

Order Distribution List

Postby facklec » Wed May 07, 2014 8:38 pm

PS...
It would be great if we can order the distribution list (or at least have them appear in alpabetical order).
facklec
 
Posts: 5
Joined: Wed Jun 26, 2013 7:36 pm
Location: Olympia, WA


Return to SQL Multi Script 1

Who is online

Users browsing this forum: No registered users and 0 guests

cron