Showing results for 
Show  only  | Search instead for 
Did you mean: 

Delete a Database Agent from the Controller UI

New Poster

How do I delete a unused Database Agent from the Controller UI. I cant find any delete fromAppDynamics Agents-Database Agents.

Version 4.2.12


AppDynamics Team

Hi Andersson,


Could you please give a try with the suggestions listed here and let us know your observations


You can query database and find the entries which are not required based on the database agents you see on UI.


1) Navigate to <controller-install-dir>/bin folder


 cd <Controller_install_dir>/bin


2) For windows


controller.bat login-db


For Linux


./ login-db


3) mysql> select * from machine_instance;


Once you find the entries that needs to be cleaned up on UI.




4) Please execute the query like


update machine_instance set mark_for_delete=1 AND historical=1 where name LIKE '%db%';


I gave a sample query for matching names that starts with db. Please give the names accordingly. Once you set mark_for_delete as 1, it will clean up the entries on UI. Please wait for few mins say 2-3 for the entries to be disappeared from UI.


please make sure those db agent java processes are no longer in reporting state by killing those process. Otherwise they will reregister and get settled on UI.

Please let us know if you still face any issues.


If this doesn't work, then its a product limitation.




New Poster



This is a saas controller so I dont have access to servers. But when I looked today the unused DB agent is gone. :)



That's glad to hear. Please let us know if you need any more help on this issue. Else can we close this issue