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
02-27-2017 03:06 AM
02-27-2017 10:49 AM
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..
03-01-2017 01:54 AM
Hari,
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.
03-01-2017 04:58 PM
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
03-03-2017 02:55 AM
Hari,
i have attached the screenshot of ADSQL mobile_snapshot table,where it has 1046 reords.when Executing simple select * queries. we could get only 1000 records.
03-20-2017 07:53 AM
Hi
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.
Thanks
Arun
10-22-2018 02:24 PM - edited 10-22-2018 02:55 PM
Hi @SR.Arun
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.
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form