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 5 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 Wednesday, June 23, 2010 5:34 AM

Grasshopper

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

olsosoft (6/22/2010)

You could also use a free program like SpiceWorks which does this and a lot more...

Thanks, will try.

Post #941658

Stanley Chan

Posted Wednesday, June 23, 2010 5:38 AM

Grasshopper

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

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

Post #941661

Jeff Moden

Posted Wednesday, June 23, 2010 6:14 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:49 AM
Points: 32,889, Visits: 26,758

Stanley Chan (6/23/2010)

Jeff Moden (6/22/2010)

stephen.burke (6/14/2010)

Have you got a link for that?

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

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #941689

« Prev Topic | Next Topic »

43 posts, Page 5 of 5

«««1 2 3 4 5

Permissions