Grafana - Icinga2 with MySql as datasource

Hi Team,

We are trying to integrate Icinga2 with Grafana as the visualization platform. In our setup, MySQL is being used the data source for Grafana as we have used the same as the Icinga2 database.

our requirement is to bring the performance data into Grafana dashboard by adding panels that would show the utilization graphs.

Upon checking the Icinga database, we have seen the perfdata is being stored as text.

Much appreciated, if someone could help us in achieving this. We tried out few queries, in pulling the data.