API-only metrics - Oracle database insights

Babar_Qayyum — Thu, 15 Jun 2023 11:52:32 GMT

Dear All,

How to obtain the Oracle database insights API-only metrics (These metrics are not charted in Dynatrace but can be accessed through calls to the Dynatrace API.) and use them in a presentable way?

Regards,

Babar

Re: API-only metrics - Oracle database insights

ryan_ott — Thu, 22 Jul 2021 13:45:44 GMT

Hi Babar,

These metrics and their data points can be pulled via an API call to the following endpoint: '/api/v2/metrics/query'. You can provide the metricSelector (as mentioned here - metric keys: https://www.dynatrace.com/support/help/shortlink/database-insights#api-only-metrics ), resolution, starttime, endtime, and entitySelector for filtering. You can play around with these API queries interactively through the API explorer built-in to Dynatrace - accessible by clicking the person icon in the top right of your environment and then selecting 'Environment API v2', in this case.

For presenting the data, I would recommend using any tool that can dynamically import data from Web API calls, such as Excel or PowerBI. Both of which provide powerful charting and reporting capabilities.

Hope this helps.

-Ryan

topic API-only metrics - Oracle database insights in Open Q&A

API-only metrics - Oracle database insights

Re: API-only metrics - Oracle database insights