Delete a Database Agent from the Controller UI

[Pär_Andersson]

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

[Pär_Andersson]

Hi,

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

\Pär

[Rajesh_Putta · Accepted solution]

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

Thanks

Rajesh

[Rajesh_Putta]

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

./controller.sh login-db

3) mysql> select * from machine_instance;

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

Example

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.

Thanks

Rajesh