Make a 100+ Server Inventory in 30 minutes

  • Stanley Chan

    Mr or Mrs. 500

    Points: 560

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

  • M A Srinivas

    SSC-Addicted

    Points: 488

    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: 6518

    Hi Stanley,

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

  • Vikas S. Rajput

    SSC-Addicted

    Points: 475

    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

    Hi Srinivas,

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

    Stanley

  • Ritesh Medhe

    SSCommitted

    Points: 1941

    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

    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

    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

    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

    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

    Thanks ryberg, I will try!

  • Phil Factor

    SSCoach

    Points: 19913

    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

  • Nils Gustav Stråbø

    SSChampion

    Points: 11259

    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: 1077

    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 Journeyman

    Points: 89

    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 45 total)

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