Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.
AppDynamics customers and established members should click the sign in button to authenticate.
Arun, you mention "extract metrics" as well as ADQL in your ask. So I'm a bit confused about your exact ask. If you could kindly elaborate with sample data format / use case, that would help refine our response. But incase you were not already aware, we provide a couple of API options to extract data out
- see https://docs.appdynamics.com/display/PRO42/Metric+and+Snapshot+API - which should address your need to extract all the metrics
- see https://docs.appdynamics.com/display/PRO42/Analytics+Events+API for the Analytics data extraction technique
If the above links don't help give you an idea, please provide us an example of what you are looking for..
My requirement is,I need to pull down different metrics(log,Transaction,session) information for our mobile application to Hadoop enviorment.
I could pull data from search --> Advance (ADSQL),but i could extract only 1000 records,i could not pull beyond that.
I have more than 5000 records.i need to extract all this records at single stretch.
is there possbile way I could schedule export from AppyDynamics ?
your help is appreciated here.
Arun, if your ADQL query is anything but a simple SELECT * type query(what is called as aggregate queries), then there is a current limitation of 1000 Results. This is something that is being considered for improvement shortly. But this is a limitation today.
If its a simple SELECT * type query and still hitting this limit, please post back with a live example..Thanks
do you have date convesion function available in ADSQL.When we try to extract date which is (30/02/17 8:02:15 PM) it was unreadable format 1.49E+12.
how can i convert this date into timestamp.
Have you found out the solution to the problem?
Note that Application Analytics support 1,000,000 business transaction events per 24-hour period. There is no date conversion function currently available in ADQL. However, keep an eye on the upcoming release updates, we will release the functionality soon.
We would also recommend referring to the following ADQL Data doc to learn more about how to collect various types of data for analytics.
Hope it helps.