Home Forums Article Discussions Article Discussions by Author Discuss content posted by Stanley Chan Make a 100+ Server Inventory in 30 minutes RE: Make a 100+ Server Inventory in 30 minutes

  • June 23, 2010 at 6:14 am

    #1183873

    Stanley Chan (6/23/2010)

    Jeff Moden (6/22/2010)

    stephen.burke (6/14/2010)

    MAPS from Microsoft is the best way to record all such info in a database for you, plus a ncie report and excel spreadsheet.

    In order to produce the inventory it scans the network and identifies SQL Server installs, versions, OS details, disk space etc etc.

    Have you got a link for that?

    MAPS full name is "Microsoft assessment and planning toolkit",

    You can download it from "http://go.microsoft.com/fwlink/?LinkId=158988".

    it will also install sql server express as a repository.

    Ref:

    http://technet.microsoft.com/en-us/library/bb977556.aspx%5B/quote%5D

    I just did a quick glance at the Ref URL above. Very cool... thanks for posting the link, Stanley.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)