Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I would like to get an inventory of all SQL Servers in my office and pertinent meta information about them.

Need things like Version#, Instances, isClustered etc...

I prefer to automate this and run regularly.

I was hoping for some freeware a la SQLrecon versus hand scripting it via Powershell or vbs.

Any ideas would be appreciated.

Thanks!

Flyer

share|improve this question

closed as off-topic by HopelessN00b Jan 29 at 22:20

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

3 Answers 3

Check out the Freely available Quest Discovery Wizard

share|improve this answer
    
Quest has some awesome tools –  RateControl Aug 20 '09 at 16:40
    
Quest is working on an upgrade to Discovery Wizard that has some new features that might help with what you want. See Brent Ozar's blog for more information: brentozar.com/archive/tag/discovery-wizard. –  Ed Leighton-Dick Aug 21 '09 at 15:43

SQL Ping 3 is very similar to SQL Recon, but gives the extended information you are looking for. If you run it on Vista/Win7/2008, make sure to run it as admin or it may not work properly.

share|improve this answer

I worked on a similar solution to collect Windows and SQL Server inventory by gathering scripts from 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. please check it and give me any suggestions to improve it.

Thnx

share|improve this answer