SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Tool for SQL Inventory


Tool for SQL Inventory

Author
Message
will75
will75
SSC Veteran
SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)SSC Veteran (205 reputation)

Group: General Forum Members
Points: 205 Visits: 177
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!
DanAzz24
DanAzz24
Mr or Mrs. 500
Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)

Group: General Forum Members
Points: 565 Visits: 647
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
DanAzz24
Mr or Mrs. 500
Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)Mr or Mrs. 500 (565 reputation)

Group: General Forum Members
Points: 565 Visits: 647
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
Grant Fritchey
SSC Guru
SSC Guru (220K reputation)SSC Guru (220K reputation)SSC Guru (220K reputation)SSC Guru (220K reputation)SSC Guru (220K reputation)SSC Guru (220K reputation)SSC Guru (220K reputation)SSC Guru (220K reputation)

Group: General Forum Members
Points: 220842 Visits: 33549
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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
mrrobsewell
mrrobsewell
SSC Veteran
SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)SSC Veteran (220 reputation)

Group: General Forum Members
Points: 220 Visits: 684
It's called POwerDoc it's very good

http://sqlpowerdoc.codeplex.com/

http://sqldbawithabeard.com Its where I blog
PASS PowerShell Virtual Group http://sqlps.io
SQL Community Slack Channel http://sqlps.io/slack
The Best PowerShell Module for the Modern SQL DBA http://dbatools.io
PASS PowerShell Virtual Group YouTube Channel - Subscribe to get notified of new videos http://sqlps.io/video
SQL South West UK User Group http://sqlsouthwest.co.uk/
kevaburg
kevaburg
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10595 Visits: 1211
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
Wingenious
SSChasing Mays
SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)SSChasing Mays (658 reputation)

Group: General Forum Members
Points: 658 Visits: 1155
Here's another tool...

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



texas1236
texas1236
SSC-Enthusiastic
SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)SSC-Enthusiastic (102 reputation)

Group: General Forum Members
Points: 102 Visits: 220
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
frane.borozan
SSC-Enthusiastic
SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)SSC-Enthusiastic (151 reputation)

Group: General Forum Members
Points: 151 Visits: 7
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search