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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.