Make a 100+ Server Inventory in 30 minutes

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

  • 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

  • Hi Stanley,

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

  • 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

  • Hi Srinivas,

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

    Stanley

  • Hi Stanley,

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

  • 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)

  • 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/

  • 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

  • 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.

  • Thanks ryberg, I will try!

  • 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

  • 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.

  • 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

  • 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

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

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