topic Re: About Seeing Database Queries in Dynatrace API

Seeing Database Queries

kasdev — Fri, 07 Jun 2024 10:49:51 GMT

Hello. I want to see database queries via api but i dont know how to achieve it or if its possible. Anyone has an idea?

AntonPineiro — Fri, 17 May 2024 16:29:35 GMT

Hi,

I think that is not possible.

Best regards

Yosi_Neuman — Sun, 19 May 2024 15:04:47 GMT

To see the DB statements you need to utilize entities rest api few times,

First with service method group

For example we can filter the database service to show statements under SQL Queries or Procedures

Then we can pull the service method group from the URL

and use it as the entity ID for entities rest api

The DB statements are under isServiceMethodOf

the id's are again the ID's for entities rest api

Under detected name you will find the DB statement as shown in the UI

HTH

Yos