December 28, 2009 at 1:59 pm
Hi Guys,
I want to generate a report which includes server name, IP address, Port number, Instance name, database name, service account, version, edition and other information. I have more than 50 servers and want to hit same script in all servers. Is there any idea ? This is sql server 2005 environment. Any script or code, Plz help me.
Appreciate your help..
AKP
December 28, 2009 at 2:37 pm
some of the things you want are in global variables (@@servername, @@servicename, @@version). Others you'd have to use xp_regread to obtain. The IP you already know if you can connect to the server!
The probability of survival is inversely proportional to the angle of arrival.
December 29, 2009 at 5:19 am
Go BOL--check the SERVERPROPERTY function.
Hope this ll give more info
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
December 31, 2009 at 5:06 am
Powershell is also pretty good for these sorts of tasks. You can easily write some scripts which will loop through a list of servers to find all this information and populate a table somewhere via smo & wmi.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply