how to remove old metrics from metric browser of appdynamics?

[mandar.kadam]

Hi all,

i need to remove all old data from metric browser

AppD still displays this in the metric browser. If you have a few this is not an issue but having hundreds of data you don't care about is annoying.

I was wondering if anyone has found a way of keeping just metrics for active instances and services

[herbomel.aurelien]

Hi,

We found a solution here, maybe it's can help you:

https://community.appdynamics.com/t5/Infrastructure-Server-Network/How-to-purge-Cloud-metrics-in-met...

You need to go to your serveur AppDynamics Platform, connect to DB:

/opt/appdynamics/platform/product/controller/bin/controller.sh login-db

Found the metric to delete:

example for me:

select id,name from metric where name like '%Active Direc%';

+--------+--------------------------------------------------------------------+
| id | name |
+--------+--------------------------------------------------------------------+
| 643176 | Custom Metrics|Services| |Active Directory Domain Services |
| 643177 | Custom Metrics|Services| |Active Directory Web Services |
| 643179 | Custom Metrics|Services| |Active Directory Domain Services |
| 643180 | Custom Metrics|Services| |Active Directory Web Services |
| 643182 | Custom Metrics|Services| |Active Directory Domain Services |
| 643183 | Custom Metrics|Services| |Active Directory Web Services |
+--------+--------------------------------------------------------------------+

With the ID you can delete all custom metric:

First: delete from metric_config_map where metric_id = '643176';

Second: delete from metric where id = '643176';

Wait 30 mins / 1 hours and refresh, the metric gone.

bye