Business iQ (Analytics)

cancel
Showing results for 
Search instead for 
Did you mean: 

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

New Poster

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

Hi, Did you get a solution to this??
Re: Analytics - Search and Analyze - Download CSV - 1000 record limit?
4 REPLIES 4
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.
Moderator

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, 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.
Highlighted

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

Hi @Nina.Wolinsky,

And is it possible to increase this 65k limit?

Thanks,

Mikel.

Moderator

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, 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.