Submitted by:

Egor Puzanov

This ZenPack provides ODBC monitoring of MS SQL databases. There are MsSql80Database (MS SQL 2000) and MsSql90Database (MS SQL 2005) templates available for binding and a community.odbc.MsSqlDatabaseMap zCollectorPlugin that the device will need to use.

• Database Files Size
• Database Used Space

Screenshots:

REQUIREMENTS:

• Zenoss Version: 2.5
• ZenPack Dependencies:  ODBC Datasource
  
• External Dependencies:
  • Requires either FreeTDS ODBC Driver or pyodbc to be installed
  • Requires FreeTDS ODBC Driver registered with name "FreeTDS". The following zProperties need configuration:
    • zMsSqlConnectionString - ODBC Connection String
    • zWinUser - username
    • zWinPassword - password

     Installation:

Source: http://zenpacks.zenoss.org/trac-zenpacks/browser/zenpacks/ZenPacks.community.MsSQLMon_ODBC

Tagged Releases:

• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/mssql-odbc-1.0
• http://zenpacks.zenoss.org/trac-zenpacks/browser/tags/mssql-odbc-2.0

Change History:

• 1.0 original release
• 2.0 updated to Zenoss 2.5 and use of ODBC driver or pyodbc
  

Trac tickets: http://zenpacks.zenoss.org/trac-zenpacks/report/1

Known issues: