Exporting result query logs - limit 1000

[Ellery]

Hello dear community, I have a question. I need to export results from a log query that has more than 1000 records—there are approximately 30,000 records in total. Exporting every 1000 records individually is not feasible. Has anyone faced this issue, and how did you resolve it?

[gbaudart]

Hi @Ellery 

I think you may increase this limit to 10 000 with this "samplingratio" :

fetch logs, samplingRatio:10000

 Test it with 30 000 but this might not work.

This information can be found in the documentation : https://docs.dynatrace.com/docs/shortlink/dql-best-practices#utilize-available-sampling-options

[Ellery]

Unfortunately, it didn't work for me, as adding the limits doesn't display any results. 😞

[gbaudart · Accepted solution]

My bad 😅
Try to add this command in last line of your query :

| limit 10000

[AurelienGravier · Accepted solution]

Hello @Ellery ,

I Agree with @gbaudart, I use it on a notebook.
In addition, if you want to export the result, you can do it in CSV : 

Regards Aurelien