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-19-2018 06:06 AM
Hi,
Can anyone please let me know the DB query to fetch Application and Node details from AppDynamics Controller.
Regards,
Anant Nayak
02-19-2018 06:30 AM
Hi Anant,
Please find the below query for retriveing Application and Node details from controller database. We strongly recommend you to run only select queries into the controller database.
select * from application;
select * from application_component_node;
Thanks,
Yogesh
02-19-2018 11:26 PM
Hi Yogesh,
Thanks for your reply. I am looking for Application name and its relevant Nodes ending with name 'bdc' in single query output.
Can you please let me know. Thanks
Regards,
Anant Nayak
02-20-2018 12:46 AM
Hi Anant,
Please find the below query and let us know if it helps. This will show Application, tier as well as nodes.
SELECT app.name AS application, tier.name AS tier, node.name AS node FROM application app, application_component tier, application_component_node node WHERE app.id = tier.application_id AND tier.id = node.application_component_id AND node.name like '%bdc' AND app.id = <app_id>; (replace <app_id>) wit hthe application id;
Thanks,
Yogesh
12-19-2018 10:57 PM
Hi Yogesh / Team,
Could you please help me with the query to know Controller Applications which are not collecting data from past 6 month. We want to delete them from the Controller UI / DB so that we have only the required Applications reporting. I believe this will improve the performance while accessing the UI , As currently the UI access is slow. Please let me know the delete command as well. Thanks
Regards,
Anant
User | Count |
---|---|
4 | |
4 | |
3 | |
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