No of SQL server running in a domain

• Ryan007

  SSCrazy Eights

  Points: 8275

  More actions

  November 23, 2011 at 1:24 am

  #246654

  Hi,

  I want the number of servers (which have SQL server installed) in our domain (say abc.com). We can find it from some of the third party tool like Discovery. Do you have any scripts, you are using to get the servers in a domain?

  Ryan
  //All our dreams can come true, if we have the courage to pursue them//

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  November 23, 2011 at 4:13 am

  #1412052

  from cmd prompt, try this :-

  sqlcmd -L >c:\serverlist.txt

  which will search all the sql server in domain and will write it in c:\sqlserver.txt. You can later on open this file to see the server list.

  ----------
  Ashish