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
03-19-2018 12:35 PM
Does AppD externally publish the data model for the Controller metrics repository stored in MySQL? Rather than use the UI, I would like to submit SQL queries directly to MySQL to produce customized charts and reports requested by the customer. I can query the MySQL INFORMATION_SCHEMA, but details about how tables are related would shorten the cycle. The REST URL API has been recommended to me, but SQL would be simpler and faster. The other reason I need SQL access is that the customer wants to archive metrics data beyond the 365 day retention for multi-year capacity planning. I will need an easy way to export metric data that will be aging off. Has anyone done this? TIA!
03-19-2018 09:40 PM
Hi,
Sorry but unfortunately, the database architecture is used for internal purpose only and we do not publish this publicly. Please let us know if you are looking for any specific data so that we could share the specific SQL if we are having it handy. And yes, we would suggest using the REST APIs to retrieve the data from the controller.
Let us know if you have any questions on this.
Thanks,
Yogesh
03-20-2018 03:27 PM
Yogesh,
Attached is the HDFS disk utilization spreadsheet I am asked to create each week. Each tab represents a data node in the cluster. There are two columns on each tab for each of the 8 relevant disk devices, "Space Used" and "Space Available". Each row displays an observation by hour.
Please send me a sample of the SQL necessary to produce at least one tab of this spreadsheet.
Thanks,
Frank
05-10-2018 02:24 PM
Hi frank - you can get this information using the rest Apis. I have written a web based data extraction tool for the community which does this and I would be happy to add what you are looking for into it.
https://www.chickenkatsu.co.uk/apps/reporter/
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form