cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Exporting result query logs - limit 1000

Ellery
Helper

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

Ellery_1-1704890028462.png

 

 

4 REPLIES 4

gbaudart
DynaMight Champion
DynaMight Champion

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

Observability Consultant - Dynatrace Professional Certified

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

Ellery_0-1704895522934.png

 

gbaudart
DynaMight Champion
DynaMight Champion

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

| limit 10000

 

Observability Consultant - Dynatrace Professional Certified

AurelienGravier
DynaMight Champion
DynaMight Champion

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 : 

 

AurelienGravier_0-1705002426265.png

 

Regards Aurelien

Observability consultant - Dynatrace Associate/Pro/Services certified

Featured Posts