# Problems export script

**URL:** <https://community.dynatrace.com/t/problems-export-script/42629>\
**Category:** Alerting\
**Tags:** problem-detection, problem-notification, davis, problems-classic\
**Created:** [November 15, 2023, 1:00pm UTC](https://community.dynatrace.com/t/problems-export-script/42629 "2023-11-15T13:00:02Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![gurugogi](https://avatars.discourse-cdn.com/v4/letter/g/87869e/32.png) [@gurugogi](https://community.dynatrace.com/u/gurugogi)\
**Post date:** [November 15, 2023, 1:00pm UTC](https://community.dynatrace.com/t/problems-export-script/42629/1 "2023-11-15T13:00:02Z")

</div>

Hi all,

Please let me know anyone has written python script to export Problems data from API V2.  
API V2-\> Problems → List problems observed within the specified time frame.

Challenge I faced : with&nbsp;evidenceDetails field we can export only 10 problems once, suppose I have 1000 problems in last 1 month then I have to run this API 100 times manually with nextPage key.

Please help.

Thanks.

---

<div class="post-metadata">

**Author:** ![AntonPineiro](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/antonpineiro/32/49_2.png) [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\
**Post date:** [November 16, 2023, 4:32am UTC](https://community.dynatrace.com/t/problems-export-script/42629/2 "2023-11-16T04:32:18Z")

</div>

Hi,

You can use Bash, Perl, Python, Go, Ruby, Powershell… Almost all languages have libraries do make HTTP requests and parse JSON answer.

Something to explore would be using [DQL to get Davis AI information](https://docs.dynatrace.com/docs/shortlink/davis-dql-examples#basic-davis-problem-examples). You do not need programming skills for that.

Best regards

---

<div class="post-metadata">

**Author:** ![Yosi\_Neuman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/yosi_neuman/32/9845_2.png) [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\
**Post date:** [November 16, 2023, 10:22am UTC](https://community.dynatrace.com/t/problems-export-script/42629/3 "2023-11-16T10:22:13Z")

</div>

Hi&nbsp;[@gurugogi](https://community.dynatrace.com/user/61893)

Try to use the code from the attached file

HTH

Yos&nbsp;  
[FeatchProblems.py.txt](https://community.dynatrace.com/uploads/short-url/c4rKkg9lhX4uBnY1jiDwv8NW5ZL.txt) (3.2 KB)

---

<div class="post-metadata">

**Author:** ![gurugogi](https://avatars.discourse-cdn.com/v4/letter/g/87869e/32.png) [@gurugogi](https://community.dynatrace.com/u/gurugogi)\
**Post date:** [November 16, 2023, 11:03am UTC](https://community.dynatrace.com/t/problems-export-script/42629/4 "2023-11-16T11:03:54Z")

</div>

Hi&nbsp;[@Yosi\_Neuman](https://community.dynatrace.com/user/6931)&nbsp;  
Thanks for providing script.

Iam getting certificate error "urllib3.exceptions.SSLError: [SSL: CERTIFICATE\_VERIFY\_FAILED] certificate verify failed: self signed certificate in certificate chain (\_ssl.c:1007).

Please check attach output.

"  
[py-error-logs-dt.txt](https://community.dynatrace.com/uploads/short-url/qlmwwQJjiHfK7HEKdCHDMFK9ybW.txt) (4.67 KB)

---

<div class="post-metadata">

**Author:** ![gurugogi](https://avatars.discourse-cdn.com/v4/letter/g/87869e/32.png) [@gurugogi](https://community.dynatrace.com/u/gurugogi)\
**Post date:** [November 16, 2023, 11:36am UTC](https://community.dynatrace.com/t/problems-export-script/42629/5 "2023-11-16T11:36:27Z")

</div>

I used verify=true in “requests.get” and certificate error is fixed now but script is not getting completed just its keep on running in loop.

PFA snapshot.

 ![Screenshot 2023-11-16 at 5.05.33 PM.png](https://global.discourse-cdn.com/dynatrace/original/3X/1/5/15cba60150e478ef9e9837c2979c1df4e6ee3ad3.png)

---

<div class="post-metadata">

**Author:** ![Yosi\_Neuman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/yosi_neuman/32/9845_2.png) [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\
**Post date:** [November 16, 2023, 1:56pm UTC](https://community.dynatrace.com/t/problems-export-script/42629/6 "2023-11-16T13:56:57Z")

</div>

Hi&nbsp;[@gurugogi](https://community.dynatrace.com/user/61893)

My bad, gave you a not complete code … try the attached one see if its works for you

Just tried that with 10 days and its look like its working

 ![Yosi_Neuman_0-1700143380073.png](https://global.discourse-cdn.com/dynatrace/original/3X/5/e/5eb16e226b77ee22cbc7acb043de0ae176f87a6b.png)

Yos&nbsp;  
[FeatchProblems.py.txt](https://community.dynatrace.com/uploads/short-url/5muzxerY3zluOpX1JwHTHtoprdz.txt) (3.83 KB)

---

<div class="post-metadata">

**Author:** ![Gogi](https://avatars.discourse-cdn.com/v4/letter/g/958977/32.png) [@Gogi](https://community.dynatrace.com/u/Gogi)\
**Post date:** [November 16, 2023, 3:40pm UTC](https://community.dynatrace.com/t/problems-export-script/42629/7 "2023-11-16T15:40:09Z")

</div>

[@Yosi\_Neuman](https://community.dynatrace.com/user/6931)&nbsp;Script is working now, thanks.

Does it include problems with “evidenceDetails” field

---

<div class="post-metadata">

**Author:** ![Yosi\_Neuman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/yosi_neuman/32/9845_2.png) [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\
**Post date:** [November 16, 2023, 5:00pm UTC](https://community.dynatrace.com/t/problems-export-script/42629/8 "2023-11-16T17:00:40Z")

</div>

You are welcome&nbsp;[@Gogi](https://community.dynatrace.com/user/50971)

In order to include&nbsp;evidenceDetails please add&nbsp;_ **, “fields” : ‘evidenceDetails’** &nbsp;_to request\_params

 ![Yosi_Neuman_0-1700153940955.png](https://global.discourse-cdn.com/dynatrace/original/2X/9/960beb6f15bcc2175300a7578e32d7369ffb042c.png)

HTH

Yos

---

<div class="post-metadata">

**Author:** ![gurugogi](https://avatars.discourse-cdn.com/v4/letter/g/87869e/32.png) [@gurugogi](https://community.dynatrace.com/u/gurugogi)\
**Post date:** [November 17, 2023, 4:02am UTC](https://community.dynatrace.com/t/problems-export-script/42629/9 "2023-11-17T04:02:40Z")

</div>

I have added&nbsp;_ **fields" : ‘evidenceDetails’** &nbsp;_to request\_params, still I see same columns is csv, please refer attached snapshot.

whether its possible to add one more column to print ProblemID?

Thanks.

 ![Screenshot 2023-11-17 at 9.29.04 AM.png](https://global.discourse-cdn.com/dynatrace/original/3X/0/1/0100107ee39beab8a95e5bc53d3eb519a7702bfb.png)

---

<div class="post-metadata">

**Author:** ![Yosi\_Neuman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/yosi_neuman/32/9845_2.png) [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\
**Post date:** [November 18, 2023, 4:37pm UTC](https://community.dynatrace.com/t/problems-export-script/42629/10 "2023-11-18T16:37:13Z")

</div>

Here it goes&nbsp;  
[FeatchProblems.py.txt](https://community.dynatrace.com/uploads/short-url/5NHcLGwFNUhGow8pIc8vaFS86Sf.txt) (4.22 KB)

---

<div class="post-metadata">

**Author:** ![steven\_v](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/steven_v/32/34338_2.png) [@steven\_v](https://community.dynatrace.com/u/steven_v)\
**Post date:** [November 19, 2023, 5:14am UTC](https://community.dynatrace.com/t/problems-export-script/42629/11 "2023-11-19T05:14:12Z")

</div>

Awesome script&nbsp;[@Yosi\_Neuman](https://community.dynatrace.com/user/6931)

We have python scripts to export Problem data as well but haven’t found a efficient way to parse nextKeyPages. Will definitely be taking a look at what you’ve set up and improve ours.

Cheers,

Steven

---

<div class="post-metadata">

**Author:** ![gurugogi](https://avatars.discourse-cdn.com/v4/letter/g/87869e/32.png) [@gurugogi](https://community.dynatrace.com/u/gurugogi)\
**Post date:** [November 19, 2023, 6:52am UTC](https://community.dynatrace.com/t/problems-export-script/42629/12 "2023-11-19T06:52:00Z")

</div>

[@Yosi\_Neuman](https://community.dynatrace.com/user/6931)

Thanks its working.

please is it possible to add Problem selector filed also , I want to export problems data based on MZ names so that we will have problems count for each application in last 1 mont.

Management zone ID:&nbsp;managementZoneIds(“mZId-1”, “mzId-2”).  
Management zone name:&nbsp;managementZones(“value-1”,“value-2”)

Thanks

---

<div class="post-metadata">

**Author:** ![Yosi\_Neuman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/yosi_neuman/32/9845_2.png) [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\
**Post date:** [November 19, 2023, 7:33pm UTC](https://community.dynatrace.com/t/problems-export-script/42629/13 "2023-11-19T19:33:11Z")

</div>

Happy to assist&nbsp;[@steven\_v](https://community.dynatrace.com/user/23430)&nbsp;:fist\_bump:

---

<div class="post-metadata">

**Author:** ![Yosi\_Neuman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/yosi_neuman/32/9845_2.png) [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\
**Post date:** [November 19, 2023, 7:34pm UTC](https://community.dynatrace.com/t/problems-export-script/42629/14 "2023-11-19T19:34:47Z")

</div>

Hi&nbsp;[@gurugogi](https://community.dynatrace.com/user/61893)

With the attached py you can add MZ as 3ed parameter (only one at a time)

HTH

Yos&nbsp;  
[FeatchProblems.py.txt](https://community.dynatrace.com/uploads/short-url/5jsHzK9bahEFM45ercqGnH6HtEQ.txt) (4.47 KB)
