Updated Build Release V0.9.02

Rating: No reviews yet
Downloads: 8
Change Set: 66598
Released: Dec 6, 2011
Updated: Dec 6, 2011 by novaconceptsltd
Dev status: Stable Help Icon

Recommended Download

Application NCLSQLInventory-V0.9.02
application, 461K, uploaded Dec 6, 2011 - 8 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.

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

Additional documentation and reports will be forthcoming..

Reviews for this release

No reviews yet for this release.