There is no table is SQL Server that will give you this information unless you want to create and maintain a table with this information. Otherwise you need to look at some sort of query outside of SQL Server to get this information, like using AD to query all the computers in the domain, but even with that unless your computer names have a unique id to tell you that it's a SQL Server you are stuck. Jeswanth may have the better idea for you but not having ever used that method I can't validate it.