Deleting values

[nabberuk]

i have an issue in that i monitor the change in total number of prints from various photocopiers (simple change). The first time Zabbix grabs this data it seems to be a really high number, the 2nd grab of data it then starts producing normal values - i'm guessing this is because it has 2 values to compare.

I'm now trying to remove the first data grab as it's throwing off totals in Grafana. I've looked at the database and noticed they are stored in history_uint, I've done a test delete of the entry, but when looking at the latest data, graph i still have a massive spike. Where else is this data store?

I've attached the item in question and also the graph showing the spike.

[ingus.vilnis]

Do the same for values of this item ID in trends_uint table.

[nabberuk]

I've deleted the record in that table too and the spike is still appearing in the graph.

[zhura]

same question here - how to delete values from mysql zabbix DB which messing graphs?
maybe some tools exist for manually alter mysql db? yet unable to find one...

[Karunur]

i have an issue in that i monitor the change in total number of prints from various photocopiers (simple change). The first time Zabbix grabs this AC Market data it seems to be a really high number, the 2nd grab of data it then starts producing normal Tutuapp values - i'm guessing this is because it has 2 values to compare.

I'm now trying to remove the first data grab as it's throwing off totals in Grafana. I've looked at the database and noticed they are stored in history_uint, I've done a test delete of the entry, but when Cokernutx looking at the latest data, graph i still have a massive spike. Where else is this data store?

I've attached the item in question and also the graph showing the spike.

I also deleted the rocord in that table too. spike still appearing, Yet unable to find better solution.