NetXMS Support Forum

English Support => General Support => Topic started by: sqk on March 17, 2026, 11:59:09 AM

Title: How to delete value from data collection?
Post by: sqk on March 17, 2026, 11:59:09 AM
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...
Title: Re: How to delete value from data collection?
Post by: Alex Kirhenshtein on March 20, 2026, 12:48:45 PM
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)
Title: Re: How to delete value from data collection?
Post by: sqk on March 20, 2026, 02:42:25 PM
Thanks Alex, i'll give it a try...
Title: Re: How to delete value from data collection?
Post by: sqk on April 15, 2026, 01:29:19 PM
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.
Title: Re: How to delete value from data collection?
Post by: Filipp Sudanov on April 16, 2026, 03:00:06 PM
You can do
return DataCollection::ERROR;
this will prevent storing of a value into the DB, DCI will show <ERROR>.

These constants can be found here: https://netxms.org/documentation/nxsl-latest/#const-dci-exitcode
Title: Re: How to delete value from data collection?
Post by: sqk on April 16, 2026, 03:51:35 PM
Thanks so much Filipp, I looked in the documentation but hadn't noticed it,
Alessio.