Click the device in the device list.
Select Device under Monitoring Templates in the left panel.
Select Add Local Template from the Action menu.
The Add Local Template dialog appears.
Enter a name of the template, and then click Submit.
Click the newly created template in the left panel.
Enter a name for the data source, select
SQLas the type, and then click Submit.
Double-click the newly created data source.
The Edit Data Source dialog appears.
Change options as needed.
Table 59.4. MySQL Server Transactions Data Source Options
Set the host name on which the database is located. This field accepts a TALES expression, such as
Set the port on which the database server is listening. If you do not specify a port number, then the default port for the database is used.
Specify the name of the database (required).
Specify a user name with permission to connect to the database and run queries.
Specify the user password.
Specify the SQL queries that this data source should execute. A summary of MySQL syntax is available at:
Click on thebutton to save your changes.
Zenoss creates a data point that corresponds to the total query time in milliseconds.
Click Test to verify that the database connection can be completed, and that the data returned from the queries are correct.
See Zenoss Administration for more information about setting up thresholds and graphs. To create data points that store the results of queries, see the section titled "Data Points."