topic Re: Exporting result query logs - limit 1000 in Log Analytics

Export Dynatrace Log Query Results Beyond 1000 Row Limit

Ellery — Wed, 21 Jan 2026 10:59:44 GMT

Summary: This post addresses the 1000-row export limit in Dynatrace log queries and provides solutions for retrieving complete datasets. It suggests using API-based exports and query optimisation techniques.

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?

Re: Exporting result query logs - limit 1000

gbaudart — Wed, 10 Jan 2024 13:50:45 GMT

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

Re: Exporting result query logs - limit 1000

Ellery — Wed, 10 Jan 2024 14:05:32 GMT

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

Re: Exporting result query logs - limit 1000

gbaudart — Wed, 10 Jan 2024 14:54:21 GMT

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

| limit 10000

Re: Exporting result query logs - limit 1000

AurelienGravier — Thu, 11 Jan 2024 19:49:18 GMT

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