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

Tool for SQL Inventory Expand / Collapse
Author
Message
Posted Thursday, September 12, 2013 7:57 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 9:19 AM
Points: 20, Visits: 138
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!
Post #1494421
Posted Friday, September 13, 2013 2:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 141, Visits: 495
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.
Post #1494503
Posted Friday, September 13, 2013 2:44 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 9:14 AM
Points: 141, Visits: 495
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.
Post #1494504
Posted Friday, September 13, 2013 2:58 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:53 AM
Points: 13,890, Visits: 28,285
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
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1494511
Posted Saturday, September 14, 2013 9:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 12:46 AM
Points: 16, Visits: 460
It's called POwerDoc it's very good

http://sqlpowerdoc.codeplex.com/


http://sqldbawithabeard.com Its where I blog

SQL South West UK User Grouphttp://sqlsouthwest.co.uk/
Post #1494819
Posted Wednesday, September 25, 2013 6:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:40 AM
Points: 324, Visits: 534
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.
Post #1498284
Posted Thursday, September 26, 2013 9:26 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, October 18, 2014 11:57 PM
Points: 78, Visits: 1,013
Here's another tool...

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



Post #1499158
Posted Friday, April 11, 2014 1:39 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 1:22 PM
Points: 4, Visits: 192
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
Post #1561120
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse