Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

Generate a SQL Server Instance Inventory Expand / Collapse
Author
Message
Posted Thursday, September 4, 2008 11:05 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 27, 2014 11:17 PM
Points: 309, Visits: 814
Hi,
Please check my previous reply... I have attached there...


Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
Post #564009
Posted Thursday, September 4, 2008 1:06 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 12, 2014 3:12 PM
Points: 138, Visits: 346
I would like a copy of the RDL and resource info as well. Please email me at bstutters@mercurycompanies.com

Thanks.
Post #564110
Posted Thursday, September 4, 2008 1:18 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 9, 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
Posted Thursday, September 4, 2008 3:18 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, September 5, 2008 3:05 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
I would like a copy of the RDL and resource info as well. Please email me at manujaidka@gmail.com

Thanks,
MJ
Post #564919
Posted Saturday, September 6, 2008 10:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 2:37 AM
Points: 48, Visits: 137
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
Posted Tuesday, September 9, 2008 1:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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
Posted Tuesday, September 9, 2008 3:16 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 27, 2014 11:17 PM
Points: 309, Visits: 814
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
Posted Wednesday, September 17, 2008 4:32 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 11, 2014 5:33 AM
Points: 307, Visits: 1,846
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
Posted Wednesday, September 17, 2008 12:24 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, March 27, 2014 11:17 PM
Points: 309, Visits: 814
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 »

Add to briefcase ««123»»

Permissions Expand / Collapse