cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Seeing Database Queries

kasdev
Guide

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?

2 REPLIES 2

AntonPineiro
DynaMight Guru
DynaMight Guru

Hi,

I think that is not possible.

Best regards

❤️ Emacs ❤️ Vim ❤️ Bash ❤️ Perl

Yosi_Neuman
DynaMight Guru
DynaMight Guru

Hi @kasdev 

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

Yosi_Neuman_1-1716130026303.png

and use it as the entity ID for entities rest api 

Yosi_Neuman_5-1716130923234.png

The DB statements are under isServiceMethodOf

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

Yosi_Neuman_4-1716130775232.png

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

Yosi_Neuman_6-1716131014710.png

 

HTH

Yos 

 

 

 

dynatrace certificated professional - dynatrace master partner - Matrix Soft Ware Division - Israel

Featured Posts