Updated Build Release V0.9.03

Rating: No reviews yet
Downloads: 25
Change Set: 66609
Released: Dec 7, 2011
Updated: Dec 7, 2011 by novaconceptsltd
Dev status: Stable Help Icon

Recommended Download

Application NCLSQLInventory-V0.9.03
application, 811K, uploaded Dec 7, 2011 - 25 downloads

Release Notes

This is an updated build release including both the base database components and the supporting SSIS packages. This version includes collection of the sp_configure data for MSSQL Servers. Also included is the vMaster* views that are provided to give a unified view of the MasterEventLog table for various known processes. This update is primarily for the remote side. However the remote side is NOT required for the repository side to work correctly.

The Remote side is a logging framework which includes components for SSIS logging and misc event logging. This also includes 2 server level triggers, neither is required, one logs all logons and the other tracks all non temporary (#, ##) object manipulation. Of the two it is recommended that the DDL activity trigger be used.

The Repository side must be a SQL 2008+ server.

To build the database please open, modify with the appropriate paths, and execute the sql script: CreateDBAObjectsDatabase.sql

Once that is complete you can open and execute the sql script: DBAObjectsDB_Build.sql

The primary two SSIS packages are:
GetServerInfo.dtsx
GetMachineInfo.dtsx

To add servers for inventorying execute this statement in the DBAObjects database for each SQL Server to inventory:
EXEC dbo.InsSrvrInstnc @SrvrInstncFullName 'YourSQLServerName', @SrvrInstncTypeId = 1 -- for MSSQL

Example:
EXEC dbo.InsSrvrInstnc @SrvrInstncFullName '(local)', @SrvrInstncTypeId = 1
EXEC dbo.InsSrvrInstnc @SrvrInstncFullName 'SQLServer01', @SrvrInstncTypeId = 1

Documentation regarding the Remote Side is included with this release.
Additional documentation and reports will be forthcoming..

Reviews for this release

No reviews yet for this release.