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.
Can anyone please let me know the DB query to fetch Application and Node details from AppDynamics Controller.
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;
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;
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