Generate a SQL Server Instance Inventory

Question

Post reply

Generate a SQL Server Instance Inventory

Viewing 13 posts - 16 through 27 (of 27 total)

You must be logged in to reply to this topic. Login to reply

NielsGrove Say Hey Kid Points: 710 More actions · Answer 1

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 SQLAdmin.dk Design (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

/Niels Grove-Rasmussen

Ken Parchinski SSChasing Mays Points: 632 More actions · Answer 2

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

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 3

RDL file can be download from this link

http://www.sqlservercentral.com/Forums/Attachment1344.aspx

Thanks for all your feedbacks!

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

Shabba SSCertifiable Points: 5007 More actions · Answer 4

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.

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 5

Hi,

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

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

Nick-957131 Default port Points: 1498 More actions · Answer 6

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

back2boston SSC Enthusiast Points: 133 More actions · Answer 7

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

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 8

Hi,

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

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

back2boston SSC Enthusiast Points: 133 More actions · Answer 9

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!

Sakthivel Chidambaram SSCertifiable Points: 5531 More actions · Answer 10

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

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

back2boston SSC Enthusiast Points: 133 More actions · Answer 11

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.

slofamia Valued Member Points: 52 More actions · Answer 12

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

texas1236 SSC Enthusiast Points: 198 More actions · Answer 13

Hi There,

I worked on a similar solution to collect Windows and SQL Server inventory by gathering scripts from SQL Family and released it as a free tool at crazydba.com. The tool uses powershell to grab data from all servers and stores it in SQL tables and can be viewed using SSRS reports.