Problems Application Summary

[MarwanC]

I am trying to extract valuable metrics that are a similar view in the application problem summary but I do not know where to extract these info from (see the screen shot)

Any DQL (or typescript) or any hint how extract this is much appreciated.

Marwan...

[deni]

Hi @MarwanC ,

I would suggest to start from here:

fetch dt.davis.problems
| join [
  fetch events
], on: { left[event.id] == right[event.id]}

If you give some more concrete example on what final table you expect to see I can try to help more.

Regards, Deni

[MarwanC]

Thank you Deni, I meant the name of the column for the exact metrics shown in the problems application

[MarwanC]

Thanks Deni, thanks for filling in the blanks, this is indeed what I was looking for for linking problems with number of events, and this DQL does the job now (I added the latest obe below) Hoever, I need all other data, affect infra, affected, services , SLO (see screen shot I provided above) per problem and I must have all the data in order to build the relevance model to a particular problem. I will share my finding for other to benefit, but for now here the problem vs events relevance metric, fetch dt.davis.problems
| join [
fetch events
], on: { left[event.id] == right[event.id]}
| fields event.kind, right.affected_entity_types, display_id
| summarize count(), by: display_id

[MarwanC]

Hi Deni, Any further thoughts on how to extract the table similar to the table in the problem application (see attached screenshot). Thanks for your support. The join is the key to resolve this puzzle 🙂