Make a 100+ Server Inventory in 30 minutes

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 Stanley Chan » Make a 100+ Server Inventory in 30 minutes

43 posts, Page 2 of 5

««1 2 3 4 5 »»»

Make a 100+ Server Inventory in 30 minutes

Rate Topic

Display Mode

Topic Options

Author

Message

Stanley Chan

Posted Thursday, June 10, 2010 1:23 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, March 31, 2013 7:02 AM
Points: 22, Visits: 280

Thanks ryberg, I will try!

Post #935199

Phil Factor

Posted Thursday, June 10, 2010 1:33 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:00 AM
Points: 533, Visits: 2,285

This would be handy for a DBA if all the servers are in the domain, but rather than make a batch file with a list of all your servers by hand, you could get the list of all your registered SQL servers very easily from SMO, and, whilst you're doing it, collect as much SQL Server information as you want about them to combine with the systeminfo info.

Best wishes,

Phil Factor
Simple Talk

Post #935201

Nils Gustav Stråbø

Posted Thursday, June 10, 2010 2:17 AM

SSCommitted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:44 PM
Points: 1,786, Visits: 3,323

We are using Quest Spotlight and Confio Ignite for our most important servers, but the price of these products made me look for a free tool that could be used for our "not so important server".
I found SQLH2, which is written in C# (comes with complete source code) and is licensed under Microsoft Public License (Ms-PL).
I stripped out the logging parts that I did not want and modified/added some more logging to make it fit my needs.

Post #935211

sqlguy-549681

Posted Thursday, June 10, 2010 2:52 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 16, 2013 7:14 AM
Points: 93, Visits: 456

M A Srinivas (6/9/2010)

This is a good tool for systeminfo . Do you have a tool to capture sql server information like edition,service pack, cpu affinity mask, memory configured. Now these are caried out with scripts or system stored procedures

Thanks

Srinivas

Microsoft Assessment and Planning Toolkit

The Microsoft Assessment and Planning Toolkit makes it easy to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process

[url=http://www.microsoft.com/downloads/details.aspx?FamilyID=67240b76-3148-4e49-943d-4d9ea7f77730&displaylang=en#QuickInfoContainer][/url]

Post #935227

Karl McIntyre

Posted Thursday, June 10, 2010 3:34 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 2:23 AM
Points: 33, Visits: 98

Hi,

We have just started using the sql discovery wizard from quest, it is not perfect but it gets most of the information we need such as patch levels and basic information from other dbs. You can also set up custom scripts that it can run to collect extra data. The product is still in beta but has become a massive time saver.

http://www.quest.com/discovery-wizard-for-sql-server/

Thanks,
Karl

Post #935242

Android

Posted Thursday, June 10, 2010 6:41 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 23, 2011 2:40 PM
Points: 3, Visits: 10

Nice process. Would you happen to know how to either automatically populate the batch file with a listing of server names instead of manually (we have close to 200 servers and the list changes frequently) or have the batch file written to draw from another file which contains the list of servers (txt, csv, etc. format)?

Thanks,
Android

Post #935307

@Ashish

Posted Thursday, June 10, 2010 7:39 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 2:30 PM
Points: 89, Visits: 228

There is no information of hard disk size in this command.

Is there any other o/s command which can give you the current hard disk sizes?

_________

Regards,
Ashish

Post #935345

marvin.meints

Posted Thursday, June 10, 2010 7:43 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 04, 2010 9:44 AM
Points: 2, Visits: 14

I like the concept, I played with it and had good results in general. One thing to be aware of, is that this approach does not work in all environments. RPC has to be available for this to function.

So, if you are in a "hardened" environment for security where the port are not available, the service is shut off, or any number of things like that, the script will fail generating a simple error message.

So, while this is a great and simple solution, it has it limitations-only worked on a subset of the servers I deal with.

Post #935350

arr.nagaraj

Posted Thursday, June 10, 2010 7:47 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 12:27 AM
Points: 483, Visits: 1,191

@andriod,

Try "sqlcmd -L" on the command prompt and check whether it helps you.

Regards,
Raj

Strictlysql.blogspot.com

Post #935354

Kendal Van Dyke

Posted Thursday, June 10, 2010 7:53 AM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:58 PM
Points: 361, Visits: 780

Great tip to get a quick inventory!

I wrote a similar blog post about using a free tool called SYDI that uses WMI to gather system information and query\persist it in SQL 2005: http://kendalvandyke.blogspot.com/2008/06/network-documentation-with-sql-2005-and.html. It gathers more information than systeminfo does but it's also slightly more complecated to implement. Smile

Kendal Van Dyke
http://kendalvandyke.blogspot.com/

Post #935357

« Prev Topic | Next Topic »

43 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions