topic Re: Delete a Database Agent from the Controller UI in Splunk AppDynamics

Delete a Database Agent from the Controller UI

Pär_Andersson — Wed, 03 May 2017 07:56:53 GMT

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

Re: Delete a Database Agent from the Controller UI

Rajesh_Putta — Thu, 04 May 2017 12:30:14 GMT

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

Re: Delete a Database Agent from the Controller UI

Pär_Andersson — Thu, 04 May 2017 12:38:18 GMT

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

Re: Delete a Database Agent from the Controller UI

Rajesh_Putta — Thu, 04 May 2017 12:39:28 GMT

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