Required Database Query to fetch Application and Server details from AppDynamics Controller

[Anant_P_Nayak]

Hi,

Can anyone please let me know the DB query to fetch Application and Node details from AppDynamics Controller.

Regards,

Anant Nayak

[Yogesh_Chouk]

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

[Anant_P_Nayak]

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

[Yogesh_Chouk]

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

[Anant_P_Nayak]

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