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 (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)

Group: General Forum Members
Points: 383 Visits: 838
Hi,
Please check my previous reply... I have attached there...

Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Bill Stutters
Bill Stutters
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 Visits: 354
I would like a copy of the RDL and resource info as well. Please email me at bstutters@mercurycompanies.com

Thanks.
Wayne West
Wayne West
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1696 Visits: 3694
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.

-----
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson
Kirk J. Nason
Kirk J. Nason
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 11
Microsoft Assessment and Planning Toolkit Solution Accelerator
Published: February 25, 2008 | Updated: June 30, 2008

http://technet.microsoft.com/en-us/library/bb977556.aspx

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

MAP 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, SQL Server 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.
MANU-J.
MANU-J.
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1918 Visits: 8766
I would like a copy of the RDL and resource info as well. Please email me at manujaidka@gmail.com

Thanks,
MJ
NielsGrove
NielsGrove
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 169
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
Ken Parchinski
SSC Rookie
SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)SSC Rookie (36 reputation)

Group: General Forum Members
Points: 36 Visits: 138
Nice solution. Where would I find the .RDL file mentioned in the article?



Sakthivel Chidambaram
Sakthivel Chidambaram
Old Hand
Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)

Group: General Forum Members
Points: 383 Visits: 838
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
Shabba
Old Hand
Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)Old Hand (341 reputation)

Group: General Forum Members
Points: 341 Visits: 1846
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
Sakthivel Chidambaram
Old Hand
Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)Old Hand (383 reputation)

Group: General Forum Members
Points: 383 Visits: 838
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
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