Splunk AppDynamics

Delete a Database Agent from the Controller UI

Pär_Andersson
Engager

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

Labels (1)
0 Karma
1 Solution

Rajesh_Putta
Communicator

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

View solution in original post

0 Karma

Pär_Andersson
Engager

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

0 Karma

Rajesh_Putta
Communicator

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

0 Karma

Rajesh_Putta
Communicator

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

Get Updates on the Splunk Community!

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...

AppDynamics is now part of Splunk Ideas

Hello Splunkers, We have exciting news for you! AppDynamics has been added to the Splunk Ideas Portal. Which ...

Advanced Splunk Data Management Strategies

Join us on Wednesday, May 14, 2025, at 11 AM PDT / 2 PM EDT for an exclusive Tech Talk that delves into ...