Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Generate a SQL Server Instance Inventory


Generate a SQL Server Instance Inventory

Author
Message
Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
Comments posted to this topic are about the item Generate a SQL Server Instance Inventory

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
David Gugick
David Gugick
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 51
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
Anipaul
Anipaul
SSCertifiable
SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)SSCertifiable (6.3K reputation)

Group: General Forum Members
Points: 6275 Visits: 1407
Good article...



Bombardier
Bombardier
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
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 ?
Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
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
Bombardier
Bombardier
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
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]

yzheng25
yzheng25
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 212
I am not be able to find SQLInv.dll from your article. Could you email me ?
My email address: yzheng25@hotmail.com
Thanks

Peter
Daniel Claus
Daniel Claus
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 171
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
Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)Old Hand (311 reputation)

Group: General Forum Members
Points: 311 Visits: 838
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
Attachments
Analysis.JPG (84 views, 10.00 KB)
SQLInv.txt (215 views, 44.00 KB)
Francois De Beck
Francois De Beck
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search