To get list of Servers

[cyno]

What is the best way to get all the Sql servers information that have been installed within a domain. May be i need to write a windows program to get this info. I am looking for the servername, IP address, Memory, SQl version and Service pack. Any help would be appreciated.

Cyno

 

[maswien]

If you have the domain administrator right and all the SQL Server in the domain can be accessed by the domain admin, then you should be able to get the information you want,

first get the server list:

osql -L > servers.txt

Then write script to loop the list:

osql -Sservername -E -q"select @@version" > info.txt

 

[cyno]

Maswein - This is what i am thinking to do. Thanks a lot for your reply.

Cyno