How to delete value from data collection?

[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...

---

[alk]

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]

Thanks Alex, i'll give it a try...

[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.

[Filipp Sudanov]

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

[sqk]

Thanks so much Filipp, I looked in the documentation but hadn't noticed it,
Alessio.