Page History
...
We create a CSC like any other monitor. Go to monitors page and select ' Add new monitor' from the drop-down
- Enter the name of the counter being added.
- Type in the name of the group to which this counter is being added.
- Choose the type of counter as Custom SQL.
- Formula: A MySQL server parameter that would be is needed to compute the value of this counter.
- Value: This defines a function that computes the value. Here is Below, you can find a template:
Code Block | ||
---|---|---|
| ||
function() { var sqlObject = MONyog.UserObject('<Name of your Custom SQL Object>'); if (!sqlObject || !sqlObject.isEnabled() || !MONyog.MySQL.Custom.Available) return '(n/a)'; /* You will have to call select here to fetch the resultset. */ var resultSet = sqlObject.select(); var results = ''; /* results holds the resultset in the form of array of row(s).*/ /*Get column(s) for each row from the result set */ for (i in resultSet) { if (resultSet.length > 0) results += '<br>'; results += resultSet[i].<Column name in resultset> + '.' + resultSet[i].<Column name in resultset>; } if (results.length == 0) results = 'None'; return results; } |
- Description: Description of Monitor/Advisor.
- Advice Text: Advise text to the Monitor/Advisor being added.
Scroll pdf ignore |
---|
IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |
...