Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

Make a 100+ Server Inventory in 30 minutes Expand / Collapse
Author
Message
Posted Wednesday, June 23, 2010 5:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:33 PM
Points: 22, Visits: 297
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
Posted Wednesday, June 23, 2010 5:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 9:33 PM
Points: 22, Visits: 297
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
Posted Wednesday, June 23, 2010 6:14 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:36 AM
Points: 36,995, Visits: 31,524
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


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

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #941689
Posted Thursday, April 17, 2014 12:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 12:00 PM
Points: 4, Visits: 189
I worked on a similar solution to collect Windows and SQL Server inventory by gathering scripts from your posts and other SQL Family and released it as a free tool at http://crazydba.com. The tool uses powershell to grab data from all servers and stores it in SQL tables and can be viewed using SSRS reports. Can you please check it and give me any suggestions to improve it?

Thnx
Post #1562807
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse