Convert MDA Queries into DQL for Advanced Analytics

[Akhil-Jayendran]

Hello Team,

Is there a way to convert an MDA query into DQL or plot a chart on the dashboard without creating custom metrics?

I’m looking to split metrics from dt.service.request.count by dt.entity.cloud_application_instance. Any insights or suggestions would be appreciated.

Regards,

Akhil Jayendran

[p_devulapalli]

@Akhil-Jayendran Can you please try the below?

timeseries sum(dt.service.request.count), by: { dt.entity.cloud_application }
| fieldsAdd dt.entity.cloud_application.name = entityName(dt.entity.cloud_application)

[Akhil-Jayendran]

Hello @p_devulapalli ,

I would like to get the metrics split by pode level (dt.entity.cloud_application_instance) above one is only with workload level I think.

[p_devulapalli]

@Akhil-Jayendran I am bit doubtful if this metric can be split by pod, but I could be wrong .

[Akhil-Jayendran]

Hi @p_devulapalli  Even  I have the same feeling, but in the Dynatrace UI under MDA I can split this metric with pod name (service_instance) so I  still have the hope we can do it same  in the DQL with same metrics or any other metrics. 

[Akhil-Jayendran]

Does anyone have any insights on this? Is it achievable using DQL?

[IzabelaRokita]

Hey @Akhil-Jayendran ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

[Akhil-Jayendran]

Hi @IzabelaRokita , 
Not really, I think  it is not supported 

[Julius_Loman]

@Akhil-Jayendran not using built-in metics directly, as those do not contain this information. You can query it using spans (if you have Dynatrace SaaS with Traces in Grail), as this is a replacement for MDA in the Gen3. You just need to use a different ID - since service instance is not a common field in Grail. 

For example:

fetch spans
| filter request.is_root_span == true
| makeTimeseries count(), by: { dt.entity.process_group_instance }
| fieldsadd dt.entity.process_group_instance.name = entityName(dt.entity.process_group_instance)

See that in action in playground.