You can monitor your data sources using custom queries .Here are the steps to do itand following the above steps:
- Create
...
- two files named "AllConnections.json" and "AllConnectionsByDd.json" under the directory "<Path_To_Jira>\Application Data\JIRA\KeplerTechnologies\monitoring"
- Fill in the first file with
...
- a query. For example : {"id":1,"name":"all connections","query":"show processList"}
- Fill in the second file with
...
- another query. For example: {"id":2,"name":"All connecions By database","query":"SELECT count(id) as number,db ,user,host,command FROM INFORMATION_SCHEMA.PROCESSLIST group by db;"}
- In JIRA > Manage Apps > SQL Customfield Administration > Monitoring > Select
Here is the resultThe result is shown below:
