Overwrite old values with zabbix_sender

[TobiasKWF]

Hey guys,

we use zabbix_sender for importing files with timestamps and values since 1 year.
We now see an "feature/problem" after reimporting old values (ex. 2 Days old).
We thing zabbix overwrite old values with the new values when we import them again . But Zabbix create an "trend" graph with red,green and yellow lines in the last_data_graph...

Is there an command or solution to say zabbix overwrite old values with the new one we import. We don't want to clear the item values complete , we only want to reimport these 10-20 values right values...

Thx Tobias

[ingus.vilnis]

Hello and welcome to Zabbix forums!

!! What I am going to suggest you can seriously harm your database and cause loss of Zabbix data!

Now that I have warned you, I can tell you one possible solution.
Every Zabbix item has its itemID. You can find item values in history* and trends* tables. History tables contain all data points but trends keep averaged data per each hour.

You can find your item ID e.g. by opening the host configuration in web interface and then opening selected item. Item ID can be seen in URL field in browser.

Then you can connect to your Zabbix database and with SQL commands delete the values for this item ID from trends or trends_uint tables.

Hope this helps!

Best Regards,
Ingus