Is there a script that returns all databases in a domain?

Question

Is there a script that returns all databases in a domain?

Jay Bee-249994

SSCrazy

Points: 2393
More actions
September 5, 2007 at 6:25 am

#180628

grouped by server?
Thanks,

Jaybee.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

no, because there's no central resource to ask for the information.

You'll want to use a utility like SQL Recon to find all the servers in your domain. Besides finding out which are vulnerable, with that list of servers, you could create a script that logs into each and tries to list the databases.

Since each server might have different setups/credential requirements, it might get difficult unless you are running as a domain admin, and the group builtin\Administrators wasn't removed from any of the servers.

SQL Recon: http://www.specialopssecurity.com/labs/sqlrecon/

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Bob Fazio SSChampion Points: 10794 More actions · Answer 2

SQL - NO.

DMO/SMO yes, but you are going to have to write some code. Even VBScript.

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 3

If you registered your server and databases in AD you can had an AD Administrator give you the list. If not, then the other options posted are your best bet.

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."