[windows software] Counting number of MSSQL Installs

[tsutton]

We need to do some software auditing and I need to find out how many copies of MSSQL install on our network including the product versions & editions (i.e. Standard or Enterprise)

 

What does everyone use to count the number of MSSQL installs on a network?

 

Thanks.

[tsutton]

Looks like I forgot to update this.

 

After a bit of research, I have gone with SQL Power Doc - https://sqlpowerdoc.codeplex.com

 

VERY, very powerful and does the job I need! Hopefully you will also find this useful as well.

[jinnantonnixx]

From your SQL server, run a command prompt then type

SQLCMD -L

 

That will list all instances it finds on the network.

 

If you're just interested in a particular server,

SQLCMD -L | FIND /I "your_server_name"

 

and to just count instances

 

SQLCMD -L | FIND /I /C "your_server_name"

Edited June 17, 2014 by jinnantonnixx

[tsutton]

Yes, I could have used it, but it's limited and does not reach across to different subnet of networks, security layers, firewalls, etc.

[jinnantonnixx]

True enough, The scripts look a better bet.