Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

A colleague has been given a task of documenting SQL Servers for a client, that has about 200 servers (on physical and virtual hardware) with a total of about 1000 databases.

  • What servers are on the network?
  • What hardware are they running on?
  • Version of OS/SQL Server?
  • What users have access to the server?

We have been googling for software to do this, but without luck. Does software like this exist, or do we have to roll our own?

share|improve this question

3 Answers 3

up vote 3 down vote accepted

Your colelague should talk to the admin team - most likely they have or shoult ahve something like Tivoli or SCCM / SCOM (System Center, Microsoft) in use and actually DO AHVE this information already.

Otherwise I would suggest SCOM (System Center Operations Manager) and SCCM (System Center Configuration Manager) to start managing those servers.

share|improve this answer
    
Yes to SCOM (if you have it) –  jl. Nov 23 '10 at 14:00

There are a number of utilities that can do this. One that I was recently introduced to is pretty good, it's ManagePC and it can collect the bulk of this information for you.

As for determining which users have access to the server, your client needs to be more specific. Do they want to know which users can access file shares on the servers, which users can access SQL server, etc.?

share|improve this answer

Quest has a (currently free) tool called Discovery Wizard for SQL Server that can get you most of the data that you want.

It will search IP ranges or AD groups using various methods, and get information about servers (including OS level, how much memory, number of processors), the databases installed (including SQL version and service pack level), logins, etc.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.