Inital Release Build V0.9.01

Rating: No reviews yet
Downloads: 11
Change Set: 66581
Released: Dec 5, 2011
Updated: Dec 5, 2011 by novaconceptsltd
Dev status: Stable Help Icon

Recommended Download

Application NCLSQLInventory-V0.9.01
application, 445K, uploaded Dec 5, 2011 - 11 downloads

Release Notes

This is the initial build release including both the base database components and the supporting SSIS packages.

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.