Splunk AppDynamics

Database Query metrics to Dashboard

CommunityUser
Splunk Employee
Splunk Employee

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

Labels (1)
0 Karma
1 Solution

Saradhi_Pothara
Communicator

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

View solution in original post

0 Karma

Saradhi_Pothara
Communicator

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

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

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.

0 Karma

Saradhi_Pothara
Communicator

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

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

Hi,

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

br,

Antti

0 Karma
Get Updates on the Splunk Community!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...