• Great example, I will try it out, since I am also interested in findning computers where SQL Server is installed but stopped.

    However, since you are using 'NET VIEW' to list computers, you will only see the computers on the same subnet as the computer you are running the script, right? (At least that is the way it works for me, I don't know if it is a configuration issue with broadcasting, I get the same result with SQLCMD -L). A way to get computers from separate subnets would be to query the AD, for example like this:

    http://blogs.technet.com/b/heyscriptingguy/archive/2006/11/09/how-can-i-use-windows-powershell-to-get-a-list-of-all-my-computers.aspx