Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql Server Information Expand / Collapse
Author
Message
Posted Monday, December 28, 2009 1:59 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, August 29, 2014 12:04 PM
Points: 67, Visits: 351
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
Post #839580
Posted Monday, December 28, 2009 2:37 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 1:54 PM
Points: 1,430, Visits: 3,229
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.
Post #839598
Posted Tuesday, December 29, 2009 5:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 6:19 AM
Points: 1,157, Visits: 4,650
Go BOL--check the SERVERPROPERTY function.

Hope this ll give more info


Muthukkumaran Kaliyamoorthy

Helping SQL DBAs and Developers >>>SqlserverBlogForum
Post #839777
Posted Thursday, December 31, 2009 5:06 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 7:32 PM
Points: 700, Visits: 1,029
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.
Post #840779
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse