Generate a SQL Server Instance Inventory

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Sakthivel... » Generate a SQL Server Instance Inventory

27 posts, Page 1 of 3

1 2 3 »»»

Generate a SQL Server Instance Inventory

Rate Topic

Display Mode

Topic Options

Author

Message

Sakthivel Chidambaram

Posted Wednesday, September 03, 2008 11:12 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, March 21, 2013 5:40 PM
Points: 309, Visits: 807

Comments posted to this topic are about the item Generate a SQL Server Instance Inventory

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Post #563572

David Gugick

Posted Wednesday, September 03, 2008 11:21 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, April 13, 2012 8:33 AM
Points: 11, Visits: 46

Sakthivel,

Would you mind updating the article to include Quest Software's freeware Discovery Wizard for SQL Server? You can read more information about it here:
http://www.quest.com/sqldiscovery

We have an extensive roadmap for this product and it will continue to be freeware.

Multiple discovery techniques employed
* Multi-faceted approach improves discovery
* Leverages alternate Windows and SQL Server login credentials
* Export option
Baselines
* Saves discovered results
* Used as indicator of future change
* Password Vulnerability Check

Thanks.

David Gugick
Quest Software
Dir. Product Management - SQL Server

--
David Gugick
Dir. Architecture & Design, Quest Software

Post #563573

Anipaul

Posted Thursday, September 04, 2008 3:11 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 5:01 AM
Points: 4,815, Visits: 1,343

Good article...

Post #563645

Bombardier

Posted Thursday, September 04, 2008 6:33 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, February 05, 2010 1:12 AM
Points: 14, Visits: 135

Thank you for this article,

I got a question about this : it's possible to scann either the Analysis Services and Reporting Services on the network with the same tool ? or others tools ?

Post #563732

Sakthivel Chidambaram

Posted Thursday, September 04, 2008 7:03 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, March 21, 2013 5:40 PM
Points: 309, Visits: 807

Hi,
This will scan analysis services too... Please scan any one IP where analysis services is installed and check the output and let this forum know how it goes...

Reply to other posts:

1) I have downloaded Quest Discovery software.. I will update the article with details..
2) Thanks for your feedback!

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Post #563769

Bombardier

Posted Thursday, September 04, 2008 7:56 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, February 05, 2010 1:12 AM
Points: 14, Visits: 135

How can i determine the reporting services or analysis services in this extract of my network ?

ServerIP,TCPPort,ServerName,InstanceName,BaseVersion,SSNetlibVersion,TrueVersion,ServiceAccount,IsClustered,Details,DetectionMethod
10.15.104.31,1433,FRXTLTORX20,MSSQLSERVER,9.00.1399.06,9.0.1399,9.00.1399.06,CONSOTO\SRVS-SQL_TURBO,No,(UDP)ServerName;FRXTLTORX20;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.1399.06;tcp;1433;; (WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (SA)Server present but blank SA login failed,UDP TCP WMI SCM SA
10.15.104.31,1433,FRXTLTORX20,SQL SERVER (MSSQLSERVER),9.00.1399.06,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA
10.15.104.90,1433,FRGHTGID20.CONSOTO.TRUCKS.COM,MSSQLSERVER,,,,,,,TCP
10.15.104.114,1433,FRXTLXORT10,MSSQLSERVER,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-sql_XORT,No,(UDP)ServerName;FRXTLXORT10;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.3042.00;tcp;1433;; (WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (SA)Server present but blank SA login failed (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,UDP TCP WMI SA SCM
10.15.104.114,1433,FRXTLXORT10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-sql_XORT,,(SA)Server present but required trusted context,REG SA
10.15.104.118,1433,FRXTLCERT10,MSSQLSERVER,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_CERT,No,(UDP)ServerName;FRXTLCERT10;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.3042.00;tcp;1433;; (WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (SA)Server present but blank SA login failed (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,UDP TCP WMI SA SCM
10.15.104.118,1433,FRXTLCERT10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_CERT,,(SA)Server present but required trusted context,REG SA
10.15.104.118,,FRXTLCERT10,MSSQLSERVEROLAPSERVICE,,,,CONSOTO\SRVS-SQL_CERT,,(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin\msmdsrv.exe" -s "C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config",WMI
10.15.104.123,1433,FRXTLTORX30,MSSQLSERVER,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_TURBO,No,(UDP)ServerName;FRXTLTORX30;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.3042.00;tcp;1433;; (SA)Server present but blank SA login failed (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,UDP TCP SA SCM WMI
10.15.104.123,1433,FRXTLTORX30,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA
10.15.104.124,1433,FRXTLXORT20,MSSQLSERVER,9.00.2047.00,9.0.2047,9.00.2047.00,CONSOTO\SRVS-SRVXORT-DEV,No,(UDP)ServerName;FRXTLXORT20;InstanceName;MSSQLSERVER;IsClustered;No;Version;9.00.2047.00;tcp;1433;; (WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (SA)Server present but blank SA login failed,UDP TCP WMI SCM SA
10.15.104.124,1433,FRXTLXORT20,SQL SERVER (MSSQLSERVER),9.00.2047.00,,,CONSOTO\SRVS-SRVXORT-DEV,,(SA)Server present but required trusted context,REG SA
10.15.104.125,1433,FRXTLREP10,MSSQLSERVER,8.00.194,8.0.2039,8.00.2039,CONSOTO\SRVS-sql,No,(UDP)ServerName;FRXTLREP10;InstanceName;MSSQLSERVER;IsClustered;No;Version;8.00.194;tcp;1433;np;\\FRXTLREP10\pipe\sql\query;; (WMI)StartMode:Auto State:Running Path:C:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe (SA)Server present but blank SA login failed (SCM)Start_Mode: 2 AUTO_START Path:C:\PROGRA~1\MICROS~1\MSSQL\binn\sqlservr.exe,UDP REG TCP WMI SA SCM
10.15.104.158,1433,FRXTLTORX10.CONSOTO.TRUCKS.COM,MSSQLSERVER,,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_TURBO,,(WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER (SA)Server present but blank SA login failed (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" -sMSSQLSERVER,TCP WMI SA SCM
10.15.104.158,1433,FRXTLTORX10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA
10.15.104.174,4650,FRXTLSXS30,INST20,9.00.3042.00,9.0.3239,9.00.3239.00,CONSOTO\SRVS-SQL_CRM,No,(UDP)ServerName;FRXTLSXS30;InstanceName;INST20;IsClustered;No;Version;9.00.3042.00;tcp;4650;;ServerName;FRXTLSXS30;InstanceName;INST30;IsClustered;No;Version;9.00.3042.00;tcp;3250;; (WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.6\MSSQL\Binn\sqlservr.exe" -sINST20 (SA)Server present but blank SA login failed (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.6\MSSQL\Binn\sqlservr.exe" -sINST20,UDP WMI SA SCM
10.15.104.174,3250,FRXTLSXS30,INST30,9.00.3042.00,9.0.3042,9.00.3042.00,CONSOTO\SRVS-SQL_CRM,No,(UDP)ServerName;FRXTLSXS30;InstanceName;INST20;IsClustered;No;Version;9.00.3042.00;tcp;4650;;ServerName;FRXTLSXS30;InstanceName;INST30;IsClustered;No;Version;9.00.3042.00;tcp;3250;; (WMI)StartMode:Auto State:Running Path:"C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlservr.exe" -sINST30 (SA)Server present but blank SA login failed (SCM)Start_Mode: 2 AUTO_START Path:"C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\sqlservr.exe" -sINST30,UDP WMI SA SCM[size="7"][/size]

Post #563824

yzheng25

Posted Thursday, September 04, 2008 7:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 05, 2013 6:25 PM
Points: 3, Visits: 211

I am not be able to find SQLInv.dll from your article. Could you email me ?
My email address: yzheng25@hotmail.com
Thanks

Peter

Post #563827

Daniel Claus

Posted Thursday, September 04, 2008 9:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 6:39 AM
Points: 2, Visits: 137

Sakthi,

Not sure this is the correct post for this but:

Like you, I needed to get a list of systems running SQL in our environment and used OSQL to get that list. Once I had this information, requests for more information were made.

I created a SSIS package to pull Server (OS and SQL) and Database information. Such as SQL Version, OS Version, memory installed, the account(s) SQL Server and SQL Agent are running under, database status and recovery mode, database size, the last time the database and logs were backed up.

If anyone is interested send an email to dsclaus@comcast.net I will send a Winzip file of the project.

Daniel
dsclaus@comcast.net

Post #563911

Sakthivel Chidambaram

Posted Thursday, September 04, 2008 10:42 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, March 21, 2013 5:40 PM
Points: 309, Visits: 807

Hi All,
1) SQlInv.dll is missing in the article.. I'm attaching it here.. I will try to upload it to article... (Please rename .txt to .dll)
2) Also regarding OLAPServer Inventory question... Check the attachment where it is showing Instance Name as OLAPSERVER...
3) Reg using OSQL... I'm sure that it will miss lot of server... Check it...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc

Post Attachments

Analysis.JPG (69 views, 10.30 KB)

SQLInv.txt (195 views, 44.26 KB)

Post #563998

Francois De Beck

Posted Thursday, September 04, 2008 10:54 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, July 06, 2009 6:55 AM
Points: 19, Visits: 27

You mentioned an .RDL file and a 'resource' section in your article.
I don't seems to be able to locate them.

Can you send them to me by email ?
Thanks

Post #564003

« Prev Topic | Next Topic »

27 posts, Page 1 of 3

1 2 3 »»»

Permissions