How to extract reported problems from Dynatrace-based applications?

[raz]

Hi All,

How to extract reported problems from Dynatrace-based applications?

Appreciate your advice on this, please.

[arturo_mondelo · Accepted solution]

Hi Raz,
I would bet for the use case to get the app related problems (per app, or for all your apps) with the API Problems API v2 - GET problems list | Dynatrace Docs. With them, you can get each problem in detail with each problem ID using Problems API v2 - GET problems details | Dynatrace Docs
Hope it helps!

[raz]

Hi,

Hello @arturo_mondelo 

Great thanks for the response...Just wanted to confirm if the attached link highlights the way to get all the alert details from the problem dashboard as I don't find an option to export the JSON in the problem dashboard.If the user  have no access to the settings,any restriction in extracting the details?.

Regards,

[arturo_mondelo]

Hi @raz ,

No, users don't need extra rights on the tool or be part of specific group/s.

Users will need an API token with read problems rights. They can query all the problems they may be affected by (by app, Alerting Profile...) or get the details of specific problems.

Hope this clarifies your doubt!

Thanks

[raz]

Thank you @arturo_mondelo.

But the point is I need to extract the problem details, right now the work is done manually and time consuming.

When I check on the problem dashboard, I couldn't find an option to export. Even if I see it on the main dashboard, Json file extracted mention the properties with tags: -top,left,right and width, color which is nothing but the configuration properties.

My requirement is to get all the problem details such as failure rate,response time degradation with the root cause into an excel without manually navigating into each problem detail. How can we do this effectively to replace this manual task.

Hope you understand the query and thank you so much for the support..

Awaiting your valuable response!

[PedroDeodato · Accepted solution]

Hey, @raz !

On the first link that @arturo_mondelo sent, he mentions the Problems API, where you can get precisely what you're needing 🙂 

If you scroll down to the Response body JSON model section, there is a JSON example.

If you query that API, you'll get a response similar to that one: A JSON array with each element representing a Problem, containing the elements you stated (Problem description, Affected Entities, Root Cause, etc.).

Each Problem object contains a string "problemid".

With each "problemid", you can query the second API that Arturo linked, getting the detail of each problem with more info.

With some logic, you could create a script that for each problemid on the first list, queries the second API and gives you the details you need!

What you seem to be doing is to export the JSON of a dashboard, which - in fact - does not give you any details on the data itself, but rather on the configuration of the dashboard visual elements 😉

To create the Excel you needed, APIs should be the way to go!

Hope this helps 🙂

[raz]

Hello @PedroDeodato ,

Thank you for the great explanation..

I would also like to know which tool or interface  is widely used to execute the API query.

[raz]

Hi @PedroDeodato ,

I uses Dynatrace Rest API within the environment to execute the API and it throws 401-unauthorised access issue.

It looks like this is due to no tokens passed in the headed. Could you please guide me how to get the API token.

[AntonioSousa]

@raz,

Not sure if you've got it working on your side? I believe you are using the swagger interface that Dynatrace provides.If that's the case, you have to press the padlock and then enter a corresponding token for the API being executed: