# Export Dynatrace Log Query Results Beyond 1000 Row Limit

**URL:** <https://community.dynatrace.com/t/export-dynatrace-log-query-results-beyond-1000-row-limit/43542>\
**Category:** Logs\
**Tags:** logs\
**Created:** [January 10, 2024, 12:34pm UTC](https://community.dynatrace.com/t/export-dynatrace-log-query-results-beyond-1000-row-limit/43542 "2024-01-10T12:34:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ellery](https://avatars.discourse-cdn.com/v4/letter/e/5e9695/32.png) [@Ellery](https://community.dynatrace.com/u/Ellery)\
**Post date:** [January 10, 2024, 12:34pm UTC](https://community.dynatrace.com/t/export-dynatrace-log-query-results-beyond-1000-row-limit/43542/1 "2024-01-10T12:34:27Z")

</div>

_Summary:&nbsp;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?

 ![Ellery_0-1704889881201.png](https://global.discourse-cdn.com/dynatrace/original/3X/7/f/7fe596389b08934fddb8f7917fb037e7e0388115.png)

 ![Ellery_1-1704890028462.png](https://global.discourse-cdn.com/dynatrace/original/2X/a/a2662c93f8aac7c0f9e9768a29d7dbe4c79b2ff1.png)

---

<div class="post-metadata">

**Author:** ![gbaudart](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gbaudart](https://community.dynatrace.com/u/gbaudart)\
**Post date:** [January 10, 2024, 1:50pm UTC](https://community.dynatrace.com/t/export-dynatrace-log-query-results-beyond-1000-row-limit/43542/2 "2024-01-10T13:50:45Z")

</div>

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

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

```markup
fetch logs, samplingRatio:10000

```

Test it with 30 000 but&nbsp;this might not work.

This information can be found in the documentation :&nbsp;[DQL best practices — Dynatrace Docs](https://docs.dynatrace.com/docs/shortlink/dql-best-practices#utilize-available-sampling-options)

---

<div class="post-metadata">

**Author:** ![Ellery](https://avatars.discourse-cdn.com/v4/letter/e/5e9695/32.png) [@Ellery](https://community.dynatrace.com/u/Ellery)\
**Post date:** [January 10, 2024, 2:05pm UTC](https://community.dynatrace.com/t/export-dynatrace-log-query-results-beyond-1000-row-limit/43542/3 "2024-01-10T14:05:32Z")

</div>

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

 ![Ellery_0-1704895522934.png](https://global.discourse-cdn.com/dynatrace/original/3X/4/9/49f43ad7df04e9fd19bf80c3bef8ea1c5d97d578.png)

---

<div class="post-metadata">

**Author:** ![gbaudart](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@gbaudart](https://community.dynatrace.com/u/gbaudart)\
**Post date:** [January 10, 2024, 2:54pm UTC](https://community.dynatrace.com/t/export-dynatrace-log-query-results-beyond-1000-row-limit/43542/4 "2024-01-10T14:54:21Z")

</div>

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

```markup
| limit 10000

```

---

<div class="post-metadata">

**Author:** ![agravier](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/agravier/32/29303_2.png) [@agravier](https://community.dynatrace.com/u/agravier)\
**Post date:** [January 11, 2024, 7:49pm UTC](https://community.dynatrace.com/t/export-dynatrace-log-query-results-beyond-1000-row-limit/43542/5 "2024-01-11T19:49:18Z")

</div>

Hello [@Ellery](https://community.dynatrace.com/user/65321)&nbsp;,

I Agree with&nbsp;[@gbaudart](https://community.dynatrace.com/user/64996), I use it on a notebook.  
In addition, if you want to export the result, you can do it in CSV :

 ![AurelienGravier_0-1705002426265.png](https://global.discourse-cdn.com/dynatrace/original/3X/9/7/975910a2e2382ab0602a5090550ccf008e3931d9.png)

Regards Aurelien