Tool for SQL Inventory

Question

Tool for SQL Inventory

will75

Mr or Mrs. 500

Points: 575
More actions
September 12, 2013 at 7:57 pm

#298656

I am doing a SQL inventory. basicly I need to scan a network range,find all SQL instance and record server name, instance name, version, logins.....
What is the best tool for all these?
Thanks!

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

DanAzz24 Ten Centuries Points: 1047 More actions · Answer 1

I have used SQL Discovery Wizard from Quest (http://www.quest.com/discovery-wizard-for-sql-server/) and it is free, not sure you can capture the results into a table though.

There are some powershell scripts online if you want to capture the results.

DanAzz24 Ten Centuries Points: 1047 More actions · Answer 2

I have used SQL Discovery Wizard from Quest (http://www.quest.com/discovery-wizard-for-sql-server/) and it is free, not sure you can capture the results into a table though.

There are some powershell scripts online if you want to capture the results.

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Powershell is a great tool for doing that. I think Kendal Van Dyke may have written a script that's available online. Just do a search for it.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

mrrobsewell SSC-Addicted Points: 496 More actions · Answer 4

It's called POwerDoc it's very good

http://sqlpowerdoc.codeplex.com/[/url]

https://blog.robsewell.com Its where I blog
SQL Community Slack Channel https://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA https://dbatools.io
Data South West User Group http://sqlsouthwest.co.uk/[/url]

kevaburg SSCoach Points: 18131 More actions · Answer 5

This is possible using the SSMS although it is a little more involved.

From the command line run osql -L to search the subnet for available servers. The SQL Browser needs to be active on each server though for the server to be visible.

Register these servers in the SMSS and run a query againt the parent group containing the servers.

It requires a little more work than simply pushing a button in a software window but it returns the information you want.

Wingenious SSCommitted Points: 1648 More actions · Answer 6

Here's another tool...

http://www.microsoft.com/en-us/download/details.aspx?id=7826

Creator of SQLFacts, a free suite of tools for SQL Server database professionals.

texas1236 SSC Enthusiast Points: 198 More actions · Answer 7

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

frane.borozan SSC Veteran Points: 227 More actions · Answer 8

disclaimer: I work for the company behind SQLDocKit

We have developed a tool that will help you with that https://www.sqldockit.com

To differentiate from other vendors we have built snapshots and compare technology (ability to compare any setting of the server that you have today and how it was configured for example 2 months before, so you can see the differences, and you can compare two different SQL servers so you can find differences in the configuration) and Best Practices that checks your SQL server configuration with the best practices Microsoft recommends and explains to your what you need to change on your SQL.