topic Re: Store custom problem notifications data in to sql server in Dynatrace API

Store custom problem notifications data in to SQL server

Koteswar — Tue, 20 Aug 2024 14:11:22 GMT

Hi Team,

Greetings of the day.

I am new to dynatrace.My question is how to store custom problem notifications data in to
sql server database using Dynatrace API.I am unfamiliar with a best way to achieve this.
Please share any recommendations for how to achieve this.

Thanks in advance!

Re: Store custom problem notifications data in to sql server

Mizső — Wed, 23 Nov 2022 12:57:42 GMT

Hi @Koteswar

You should use the Probelm APIv2. You need an API token with probelm.read scope.

Collect the closed custom severity problem ids for the last day (-1d):

curl -X GET https://your_environment/api/v2/problems?from=-1d&problemSelector=severityLevel%28%22CUSTOM_ALERT%22%29%2Cstatus%28%22closed%22%29 -H "accept: application/json; charset=utf-8" -H "Authorization: Api-Token YOUR TOKEN

Use the collected problem ids (bold in the middle is an individual prolem id), then you will receive the details of this individual problem.

curl -X GET https:// your_environment/api/v2/problems/-7695485534087673753_1669185960000V2 -H "accept: application/json; charset=utf-8" -H "Authorization: Api-Token YOUR TOKEN"

I have already attached a sample response from an individual custom problem.

I hope it helps to start build your process.

Best regards,

Mizső

Re: Store custom problem notifications data in to sql server

Koteswar — Thu, 24 Nov 2022 02:11:32 GMT

@MizsőThank you for quick response. Yes the above information is helpful but my specific requirement is automatically to save problem notification(log) data to sql server for further investigation. Please advise on this.

Thanks in advance!

Re: Store custom problem notifications data in to sql server

Mizső — Thu, 24 Nov 2022 06:06:20 GMT

Hi @Koteswar,

I think there is not other way to pull problem data from DT. You should build your auto process for this procedure.

Best regards,

Mizső

Re: Store custom problem notifications data in to sql server

Koteswar — Thu, 24 Nov 2022 09:14:40 GMT

Hi @Mizső thank you for sharing the information.

Please advise on my second question, I have created alerting profile and linked with email alert notification. Test email is triggering and receiving email alert successfully but when the problem has notified in Dynatrace, email alert is not triggering.

Many Thanks.

Re: Store custom problem notifications data in to sql server

Yosi_Neuman — Thu, 24 Nov 2022 09:48:23 GMT

Hi @Koteswar

For automate this procedure you can build ActiveGate extension

HTH

Yos