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 2 of 3

««1 2 3 »»

Generate a SQL Server Instance Inventory

Rate Topic

Display Mode

Topic Options

Author

Message

Sakthivel Chidambaram

Posted Thursday, September 04, 2008 11:05 AM

Old Hand

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

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

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

Post #564009

Bill Stutters

Posted Thursday, September 04, 2008 1:06 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:15 AM
Points: 138, Visits: 312

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

Thanks.

Post #564110

Wayne West

Posted Thursday, September 04, 2008 1:18 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:26 AM
Points: 891, Visits: 1,958

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.

Post #564121

Kirk J. Nason

Posted Thursday, September 04, 2008 3:18 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 20, 2011 2:25 PM
Points: 5, 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.

Post #564215

MANU-J.

Posted Friday, September 05, 2008 3:05 PM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 1,658, Visits: 8,564

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

Thanks,
MJ

Post #564919

Niels Grove-Rasmussen

Posted Saturday, September 06, 2008 10:18 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, January 11, 2013 8:32 AM
Points: 47, Visits: 111

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

Post #565048

Ken Parchinski

Posted Tuesday, September 09, 2008 1:02 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, November 18, 2010 12:55 PM
Points: 37, Visits: 120

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

Post #566426

Sakthivel Chidambaram

Posted Tuesday, September 09, 2008 3:16 PM

Old Hand

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

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

Post #566500

Shabba

Posted Wednesday, September 17, 2008 4:32 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 8:37 AM
Points: 304, Visits: 1,731

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.

Post #570886

Sakthivel Chidambaram

Posted Wednesday, September 17, 2008 12:24 PM

Old Hand

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

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

Post #571236

« Prev Topic | Next Topic »

27 posts, Page 2 of 3

««1 2 3 »»

Permissions