Make a 100+ Server Inventory in 30 minutes

Question

Make a 100+ Server Inventory in 30 minutes

Stanley Chan

Mr or Mrs. 500

Points: 560
More actions
June 9, 2010 at 10:21 pm

#222491

Comments posted to this topic are about the item Make a 100+ Server Inventory in 30 minutes

Viewing 15 posts - 1 through 15 (of 44 total)

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

M A Srinivas SSC-Addicted Points: 494 More actions · Answer 1

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

arr.nagaraj SSCertifiable Points: 6528 More actions · Answer 2

Hi Stanley,

Good and informative article. Does it require any ports to be opened?

Regards,
Raj

http://Strictlysql.blogspot.com

Vikas S. Rajput SSC-Addicted Points: 475 More actions · Answer 3

Good Article. Thanks for sharing it.

I have used systeminfo in past, but generating a CSV with help of flags is an excellent idea. Makes to my personal command repo. 🙂

_____________
Vikas S. Rajput

Stanley Chan Mr or Mrs. 500 Points: 560 More actions · Answer 4

Hi Srinivas,

For SQL Server, I think it have to do it with scripts and stored procs.

Stanley

Ritesh Medhe SSCommitted Points: 1941 More actions · Answer 5

Hi Stanley,

I am a DBA and this will surely make my life easy. thanks a lot for sharing this information.

ryberg_b SSC Enthusiast Points: 182 More actions · Answer 6

Great info - quick and easy asset overview.

However - if you want to know stuff about what runs on server, try sydi server - it takes you just that step further - but also creates quite a lot more output that you might not need.

[/url]

PS: It's free 🙂 (and I am not associated in any way, just blown away by the usability of that little tool)

Ritesh Medhe SSCommitted Points: 1941 More actions · Answer 7

Hi Srinivas,

I am not sure if this will be of any help. but you can check this article of mine.

http://www.sqlservercentral.com/articles/Automating+SQL+Server+Health+Checks/68910/

Stanley Chan Mr or Mrs. 500 Points: 560 More actions · Answer 8

Hi Raj,

Sorry I don't have idea of which port it is using.

So far I don't encounter any problem as long as I have enough permission to access the machine.

Stanley

Stanley Chan Mr or Mrs. 500 Points: 560 More actions · Answer 9

Thanks Rajput.

There are much more commands you can return the result in remote machine, in CSV/List/Table format in the same way like tasklist, schtasks.

Stanley Chan Mr or Mrs. 500 Points: 560 More actions · Answer 10

Stanley Chan

Mr or Mrs. 500

Points: 560

June 10, 2010 at 1:23 am

#1178478

Thanks ryberg, I will try!

Phil Factor SSC-Insane Points: 20244 More actions · Answer 11

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

Nils Gustav Stråbø SSChampion Points: 11259 More actions · Answer 12

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[/url], 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.

sqlguy-549681 Ten Centuries Points: 1187 More actions · Answer 13

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

Karl McIntyre SSC Enthusiast Points: 119 More actions · Answer 14

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