Infrastructure (Server, Database)

cancel
Showing results for 
Search instead for 
Did you mean: 

Delete a Database Agent from the Controller UI

SOLVED
Highlighted
New Contributor

Delete a Database Agent from the Controller UI

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

Delete a Database Agent from the Controller UI
3 REPLIES
Moderator

Re: Delete a Database Agent from the Controller UI

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

New Contributor

Re: Delete a Database Agent from the Controller UI

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

Moderator

Re: Delete a Database Agent from the Controller UI

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