Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
05-04-2017 05:27 AM - last edited on 03-16-2021 01:36 PM by Ryan.Paredez
Hi, Did you get a solution to this??
05-04-2017 05:37 AM
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
07-26-2018 09:01 AM
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
02-01-2019 05:52 AM
02-01-2019 09:38 AM
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
03-16-2021 01:43 AM
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.
03-29-2021 10:27 AM
I just heard back from the product team.
query.max.top.level.aggregation.level.limit=1000
Thanks,
Ryan, Cisco 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.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
03-30-2021 10:15 PM
Thanks for this, @Ryan.Paredez
For non-aggregation queries, is there a max limit for the property “query.max.export.results.limit" ?
Regards,
Vish
04-01-2021 02:57 PM
Hi @Vishwanath.Nair,
The limit is 65k
Thanks,
Ryan, Cisco 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.
Check out Observabiity in Action
new deep dive videos weekly in the Knowledge Base.
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form