Monitoring SQL Customfield Datasource
- Amine BOUSSAIDI
- Atimene nazim
Owned by Amine BOUSSAIDI
You can monitor your data sources using custom queries and 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
The result is shown below:
