Updated Build Release V0.9.04

Rating: No reviews yet
Downloads: 81
Change Set: 66684
Released: Dec 12, 2011
Updated: Dec 12, 2011 by novaconceptsltd
Dev status: Stable Help Icon

Recommended Download

Application NCLSQLInventory-V0.9.04
application, 812K, uploaded Dec 12, 2011 - 81 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 effectively the same as V0.9.03 with an updated repository side SaveInstanceInfoFromWMI sproc.

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.