Collecting information about servers and DBs..........
-
Hi Guys,
I want to generate a report containing information like server name, IP address, Instance name, sql server service account name, port number, SQL SERVER version, service pack, all databases with their sizes. Do you have any t-sql scripts to collect those information as a table data or how can i generate report............
Thanks in advance.
AKP
-
a lot of the information you ar elooking for(like IP address) is not stored in any database, so it can't really be done in TSQL without using something like xp_cmdshell to run outside process.
the best thing to do is download the free version of SQLRecon; it will find all your servers, and has a great report featuring everything you are looking for and more:
http://www.specialopssecurity.com/labs/sqlrecon/
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
There are also some microsfot reports and tools you can use to get some of this information.
and the SQLH2
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply