July 22, 2011 at 5:41 pm
I need to inventory all sql server that I have been given in a list of the servers but there are over 200 so I need to document how many instances on the machines and the ports. I need to grab instance, port, and version. I have done similar stuff with dmo but Im finding it lacking when I only have the server name.
Has anyone had to deal with this?
July 22, 2011 at 6:33 pm
This PowerShell snippet could be easily modified to start with a list of server names and provide a list of named instances you can then move forward with checking:
http://www.sqlservercentral.com/Forums/FindPost1100455.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 24, 2011 at 3:35 pm
Have you had a look at what MAP 6.0 can do?
MAP is the Microsoft Application and Plannng toolkit, downloadable free from Microsoft. It does a very good job of reporting on SQL Servers and instances in your environment.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply