SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Sakthivel Chidambaram / Generate a SQL Server Instance Inventory / Latest Posts

RE: Generate a SQL Server Instance Inventory

slofamia — Fri, 21 May 2010 16:38:01 GMT

Hello Sakthi. In line with the last post, where is the RDL? Please advise. Thanks.

RE: Generate a SQL Server Instance Inventory

back2boston — Wed, 27 May 2009 09:25:17 GMT

Thank you --- I will look forward to receiving the file, else if you tell me (and others) how to create it (if it's not too difficult, especially for myself---a known SQL DBA wannabe! ha!), then we can just go that route. Either way, it's appreciated. Thanks again.

RE: Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Tue, 26 May 2009 22:06:41 GMT

Hi James, It's me who is blind.. I guess i overlooked the attachments... The file you are looking for is datasource which you can create manually to the SQL Server where inventory data is stored. Retain "Inventory.rds" as the name... I don't have a copy of it now, I will upload after 12 hrs from now...

RE: Generate a SQL Server Instance Inventory

back2boston — Tue, 26 May 2009 16:38:40 GMT

Sorry, but I must be blind, because I've looked throughout this thread very carefully for the INVENTORY.RDS.TXT file that you reference in step 6 or your article and it is nowhere to be found.You did provide the SQLINV.RDL file (not DLL --- there are no DLL's anywhere in this process as far as I can tell) as attachment SQLINV.TXT (to be renamed .RDL for using it in Step 5). I have that, and that worked fine...I just need the missing INVENTORY.RDS.TXT that is to be saved/renamed INVENTORY.RDS once SQL instance name is edited.Please help with that missing INVENTORY.RDS.TXT file. Thank you!

RE: Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Thu, 21 May 2009 22:51:10 GMT

Hi, Refer to 8th post in http://www.sqlservercentral.com/Forums/Topic563572-1307-1.aspx for download the missing attachments...

RE: Generate a SQL Server Instance Inventory

back2boston — Thu, 21 May 2009 17:41:51 GMT

Hi Sakthivel -I was able to get the sqlinv file per your attachment in this post (which I think might actually be an RDL file per your screenshot, and [i]not [/i]a DLL file as you indicate in your article??) but then in the next step for creating the report, you mention a "inventory.rds.txt" file that you probably meant to include but didn't. So we need this as well in order to try your process. Thank you --- please either post it here or email me at jfordbos@yahoo.com. Very much appreciated! - James

RE: Generate a SQL Server Instance Inventory

Nick-957131 — Tue, 06 Jan 2009 10:15:39 GMT

Thanks for your article and follow up - very helpful to me as a new DBA.I did have some issues importing my text file re. truncation and "characters not recognized in the code base". Did anyone else experience this issue? I can give more specifics as needed.Thanks,Nick

RE: Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Wed, 17 Sep 2008 12:24:55 GMT

Hi, Just check my reply above your reply, I have attached the rdl file... Sorry for the inconvenience...

RE: Generate a SQL Server Instance Inventory

Shabba — Wed, 17 Sep 2008 04:32:48 GMT

Hi,Good article, however I'm stuck at point 6 (Under deploying RDL) you mention "Now open the Inventory.rds.txt and in the data source change the SQLInstance name to point to your server and save the file as Inventory.rds" Am I missing something? Where do I get Inventory.rds.txt from? Advice appreciated.

RE: Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Tue, 09 Sep 2008 15:16:57 GMT

RDL file can be download from this link[url]http://www.sqlservercentral.com/Forums/Attachment1344.aspx[/url]Thanks for all your feedbacks!

RE: Generate a SQL Server Instance Inventory

Ken Parchinski — Tue, 09 Sep 2008 13:02:10 GMT

Nice solution. Where would I find the .RDL file mentioned in the article?

RE: Generate a SQL Server Instance Inventory

Niels Grove-Rasmussen — Sat, 06 Sep 2008 10:18:07 GMT

Very good and highly relevant article!This issue I have been working on in each organization I been in.The approaches has been multiple...Right now I'm working on getting the information from the SCOM database and the HP Service Center (HPSC) database - and add some specific data in our own repository.For some years I've tried - with my current colleagues - to create the SQL Server administration silver bullet. We've never fully succeeded, and the current state of the general tool can be viewed at [url=http://sqladmin.dk/SQLAdmin/Design.aspx]SQLAdmin.dk Design[/url] (in Danish).How can we (SQL Server administrators) join forces - there are several tools out there, and the article mention some new to me, but we never really get There./NielsGrove

RE: Generate a SQL Server Instance Inventory

MANU-J. — Fri, 05 Sep 2008 15:05:32 GMT

I would like a copy of the RDL and resource info as well. Please email me at manujaidka@gmail.comThanks,MJ

RE: Generate a SQL Server Instance Inventory

Kirk J. Nason — Thu, 04 Sep 2008 15:18:32 GMT

[b][size="4"]Microsoft Assessment and Planning Toolkit Solution Accelerator[/size][/b]Published: February 25, 2008 | Updated: June 30, 2008 [url]http://technet.microsoft.com/en-us/library/bb977556.aspx[/url]OverviewThe Microsoft® Assessment and Planning Toolkit (MAP) makes it easy for you to assess your current IT infrastructure and determine the right Microsoft technologies for your IT needs. [b]MAP [/b]is a powerful inventory, assessment, and reporting tool that can securely run in small or large IT environments without requiring the installation of agent software on any computers or devices. The data and analysis provided by this Solution Accelerator can significantly simplify the planning process for migrating to Windows Vista®, Microsoft Office 2007, Windows Server® 2008, Windows Server 2008 Hyper-V, Virtual Server 2005 R2, [b]SQL Server [/b]2008 and Microsoft Application Virtualization (formerly SoftGrid).MAP expands upon the assessment features included in the Windows Vista Hardware Assessment Solution Accelerator. These features include Windows Vista assessment, Microsoft Office 2007 assessment, and non-Windows device inventory, using the Simple Network Management Protocol (SNMP). Reports for these assessment scenarios are localized in French, German, Japanese, Korean, Brazilian Portuguese, and Spanish.

RE: Generate a SQL Server Instance Inventory

Wayne West — Thu, 04 Sep 2008 13:18:00 GMT

You want to be careful with tools like this, you can run afoul of your network security people, managers, or policy. At my current place of employ, for example, I cannot run a network sweep to look for instances of SQL Server that I am not aware of. I have also heard of cases where a network sweep like this tripped the IDS and shut down the entire network.Just make sure you have management's go-ahead before proceeding with something like this.

RE: Generate a SQL Server Instance Inventory

Bill Stutters — Thu, 04 Sep 2008 13:06:35 GMT

I would like a copy of the RDL and resource info as well. Please email me at bstutters@mercurycompanies.comThanks.

RE: Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Thu, 04 Sep 2008 11:05:38 GMT

Hi, Please check my previous reply... I have attached there...

RE: Generate a SQL Server Instance Inventory

Francois De Beck — Thu, 04 Sep 2008 10:54:18 GMT

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

RE: Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Thu, 04 Sep 2008 10:42:02 GMT

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...

RE: Generate a SQL Server Instance Inventory

Daniel Claus — Thu, 04 Sep 2008 09:21:31 GMT

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.Danieldsclaus@comcast.net

RE: Generate a SQL Server Instance Inventory

yzheng25 — Thu, 04 Sep 2008 07:58:30 GMT

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

RE: Generate a SQL Server Instance Inventory

Bombardier — Thu, 04 Sep 2008 07:56:29 GMT

How can i determine the reporting services or analysis services in this extract of my network ? [font="Courier New"]ServerIP,TCPPort,ServerName,InstanceName,BaseVersion,SSNetlibVersion,TrueVersion,ServiceAccount,IsClustered,Details,DetectionMethod10.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 SA10.15.104.31,1433,FRXTLTORX20,SQL SERVER (MSSQLSERVER),9.00.1399.06,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA10.15.104.90,1433,FRGHTGID20.CONSOTO.TRUCKS.COM,MSSQLSERVER,,,,,,,TCP10.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 SCM10.15.104.114,1433,FRXTLXORT10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-sql_XORT,,(SA)Server present but required trusted context,REG SA10.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 SCM10.15.104.118,1433,FRXTLCERT10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_CERT,,(SA)Server present but required trusted context,REG SA10.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",WMI10.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 WMI10.15.104.123,1433,FRXTLTORX30,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA10.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 SA10.15.104.124,1433,FRXTLXORT20,SQL SERVER (MSSQLSERVER),9.00.2047.00,,,CONSOTO\SRVS-SRVXORT-DEV,,(SA)Server present but required trusted context,REG SA10.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 SCM10.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 SCM10.15.104.158,1433,FRXTLTORX10,SQL SERVER (MSSQLSERVER),9.00.3042.00,,,CONSOTO\SRVS-SQL_TURBO,,(SA)Server present but required trusted context,REG SA10.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 SCM10.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][/font]

RE: Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Thu, 04 Sep 2008 07:03:40 GMT

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...[u]Reply to other posts:[/u]1) I have downloaded Quest Discovery software.. I will update the article with details.. 2) Thanks for your feedback!

RE: Generate a SQL Server Instance Inventory

Bombardier — Thu, 04 Sep 2008 06:33:29 GMT

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 ?

RE: Generate a SQL Server Instance Inventory

Anipaul — Thu, 04 Sep 2008 03:11:03 GMT

Good article...

RE: Generate a SQL Server Instance Inventory

David Gugick — Wed, 03 Sep 2008 23:21:07 GMT

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:[url=http://www.quest.com/sqldiscovery]http://www.quest.com/sqldiscovery[/url]We have an extensive roadmap for this product and it will continue to be freeware.[b]Multiple discovery techniques employed[/b]* Multi-faceted approach improves discovery* Leverages alternate Windows and SQL Server login credentials* Export option[b]Baselines[/b]* Saves discovered results * Used as indicator of future change* Password Vulnerability CheckThanks.David GugickQuest SoftwareDir. Product Management - SQL Server

Generate a SQL Server Instance Inventory

Sakthivel Chidambaram — Wed, 03 Sep 2008 23:12:32 GMT

Comments posted to this topic are about the item [B]Generate a SQL Server Instance Inventory[/B]