Monitoring SQL Customfield Datasource

You can monitor your data sources using custom queries.

Here are the steps to do it:

Create a file two files named "AllConnections.json" and "AllConnectionsByDd.json" under the directory "<Path_To_Jira>\Application Data\JIRA\KeplerTechnologies\monitoring"

Fill the first file with this request for example : {"id":1,"name":"all connections","query":"show processList"}

Fill the second file with this request 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 the datasource to monitor

Here is the result: