How to delete value from data collection?

Started by sqk, March 17, 2026, 11:59:09 AM

Previous topic - Next topic

sqk

Hello, noted an abnormal value on snmp collected value and want to remove it, but from client and webui "Delete value" has no effect, how can we remove it from collected data?

Netxms server, client and webui versions are 6.0.5, thanks in advance...

Alex Kirhenshtein

You can delete is directly from the database, it's stored in the table idata_N, where N is node id (e.g. idata_100).

Item ID can be found in table items (filter by node_id and name / description)

sqk


sqk

I successfully deleted the data from the DB, but invalid values continue to arrive from the device...

Is there a way to filter and invalidate them directly as a transformation script?

I tried replacing them with NULL, but they appear as "zero" values in the graphs...

Thanks in advance,
ALessio.