topic Re: Database Query metrics to Dashboard in Splunk AppDynamics

Database Query metrics to Dashboard

CommunityUser — Mon, 15 May 2017 09:30:34 GMT

Hi,

Does anyone know a way to get the metrics shown in Database / Query Details page to a custom Dashboard? We would like to build a morning status dashboard that shows the execution times of certain queries that happen overnight.

br,

Antti

Re: Database Query metrics to Dashboard

Saradhi_Pothara — Mon, 15 May 2017 17:35:51 GMT

Hi Antti,

Only metrics available in database metric browser can be plotted in a custom dashboard. To see more information about a specific metric, double click any point on the graph and the Metric Browser opens displaying that metric.

https://docs.appdynamics.com/display/PRO43/Database+Dashboard

Regards,

Saradhi

Re: Database Query metrics to Dashboard

CommunityUser — Tue, 16 May 2017 06:21:49 GMT

Thanks for the quick answer. I know that anything in metric browser can be shown in dashboards but I was just thinking if there was a way to use some REST API or similar to fetch the query details to dashboard. Or if it was possible to create a metric of those query details. The query details data is somewhere in the controller database anyway. But this is what I was afraid that they can't be used in a dashboard.

Re: Database Query metrics to Dashboard

Saradhi_Pothara — Tue, 16 May 2017 06:31:33 GMT

Hi Antti,

These details are in events service elastic search and not in the mysql db. These dashbaords that you see is custom formatted information and not a simple metric and hence cannot be used in custom dashboards.

Regards,
Saradhi

Re: Database Query metrics to Dashboard

CommunityUser — Tue, 16 May 2017 06:46:35 GMT

Hi,

Thanks. This I didn't know. Now it makes sense that this information is not available.

br,

Antti