Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

Analytics - Search and Analyze - Download CSV - 1000 record limit?

Chidi.uchegbu
New Poster

Analytics - Search and Analyze - Download CSV - 1000 record limit?

Hi, Did you get a solution to this??

Analytics - Search and Analyze - Download CSV - 1000 record limit?
8 REPLIES 8
Mohammed.Rayan
AppDynamics Team

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Hi Chidi,

 

In 4.2  version when doing an advanced ADQL query you can add "limit 20000" to have up to 20000 items returned in a CSV export. Please find the doc link below which explains about the LIMIT clause

 

https://docs.appdynamics.com/display/PRO42/LIMIT+Clause

 

 

Hope this helps

 

Regards,

Mohammed Rayan



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Nina.Wolinsky
AppDynamics Team

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Hi @Chidi.uchegbu @Mohammed.Rayan - Circling back on this thread, were you referring to the download csv record limit or the LIMIT clause in the query @Chidi.uchegbu?

 

In 4.5, we've expanded the analytics export capability by increasing the number of rows that can be exported to CSV to 65,000. Hope that information helps! If you were referring to the LIMIT clause in the query and not the CSV record limit, that is a separate feature and is unrelated to the recent update.  


Thanks,
Nina, UX Writer on Product Design




Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Hi @Nina.Wolinsky,

And is it possible to increase this 65k limit?

Thanks,

Mikel.

Nina.Wolinsky
AppDynamics Team

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Hi @Mikel.Osinalde Aztiria  - No, it's not possible to increase that limit. Per our docs, "The maximum number of records exported for a non-aggregation query is 65000. Use the LIMIT clause to restrict the records to a number below the upper bound. The LIMIT clause does not return any additional records that satisfy the export selection criteria."

 

Here is more information on Search Analytics Data: 

https://docs.appdynamics.com/display/PRO45/Search+Analytics+Data

 

Let us know if you have any other questions!


Thanks,
Nina, UX Writer on Product Design




Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Vishwanath.Nair
Producer

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Are there any plans to increase this 65K limit for exporting into CSV ?

 

We are monitoring internet banking applications with millions of transactions and 65K severely limits our ability to export important transaction data.

Ryan.Paredez
Community Manager

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Hi @Vishwanath.Nair 

 

I just heard back from the product team.

 

The following property is the max number of records returned when the query is an aggregation query. ( Elastic search puts this limit to 10000, so we can not have more than 10k records returned for aggregation query)
query.max.top.level.aggregation.level.limit=1000
For non-aggregation queries,  this is governed by the dynamic property “query.max.export.results.limit”.
and currently, this value is 65kBoth these limits on aggr and non aggr queries are configurable property for ADQL for CSV export.  ( with a hardcoded max limit of 10k on aggr query put by Elastic search)

Thanks,
Ryan, AppDynamics Community Manager



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.
Vishwanath.Nair
Producer

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Thanks for this, @Ryan.Paredez 

 

For non-aggregation queries, is there a max limit for the property “query.max.export.results.limit" ?

 

Regards,

Vish

Ryan.Paredez
Community Manager

Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?

Hi @Vishwanath.Nair,

 

The limit is 65k


Thanks,
Ryan, AppDynamics Community Manager



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.