topic Re: Problems export script in Alerting

Problems export script

gurugogi — Wed, 15 Nov 2023 13:00:02 GMT

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 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.

Re: Problems export script

AntonPineiro — Thu, 16 Nov 2023 04:33:57 GMT

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. You do not need programming skills for that.

Best regards

Re: Problems export script

Yosi_Neuman — Thu, 16 Nov 2023 10:22:13 GMT

Hi @gurugogi

Try to use the code from the attached file

HTH

Yos

Re: Problems export script

gurugogi — Thu, 16 Nov 2023 11:03:54 GMT

Hi @Yosi_Neuman
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.

Re: Problems export script

gurugogi — Thu, 16 Nov 2023 11:36:27 GMT

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.

Re: Problems export script

Yosi_Neuman — Thu, 16 Nov 2023 15:09:18 GMT

Hi @gurugogi

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

Yos

Re: Problems export script

Gogi — Thu, 16 Nov 2023 15:40:09 GMT

@Yosi_Neuman Script is working now, thanks.

Does it include problems with "evidenceDetails" field

Re: Problems export script

Yosi_Neuman — Thu, 16 Nov 2023 17:00:40 GMT

You are welcome @Gogi

In order to include evidenceDetails please add , "fields" : 'evidenceDetails' to request_params

HTH

Yos

Re: Problems export script

gurugogi — Fri, 17 Nov 2023 04:02:40 GMT

I have added fields" : 'evidenceDetails' 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.

Re: Problems export script

Yosi_Neuman — Sat, 18 Nov 2023 16:41:37 GMT

Here it goes

Re: Problems export script

steven_v — Sun, 19 Nov 2023 05:14:12 GMT

Awesome script @Yosi_Neuman

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

Re: Problems export script

gurugogi — Sun, 19 Nov 2023 06:52:00 GMT

@Yosi_Neuman

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: managementZoneIds("mZId-1", "mzId-2").
Management zone name: managementZones("value-1","value-2")

Thanks

Re: Problems export script

Yosi_Neuman — Sun, 19 Nov 2023 19:33:11 GMT

Happy to assist @steven_v

Re: Problems export script

Yosi_Neuman — Sun, 19 Nov 2023 19:34:47 GMT

Hi @gurugogi

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

HTH

Yos