Updated Build Release V0.9.05

Rating: No reviews yet
Downloads: 1980
Change Set: 67523
Released: Jan 29, 2012
Updated: Jan 29, 2012 by novaconceptsltd
Dev status: Stable Help Icon

Recommended Download

Application NCLSQLInventory-V0.9.05
application, 1411K, uploaded Jan 29, 2012 - 1980 downloads

Release Notes

Lots of Bug fixes. Primarily in the SSIS packages. Added some sprocs and changed several. Please see the change notes in the ZIP file.

If you have applied this previously, re-apply the sprocs from the change-set and apply the change scripts. the change scripts only update the couple of objects that cannot be readily updated by a drop/create. In this case it is a new record and a table change.

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.