[ZBXNEXT-683] delete individual values from db (spikes) Created: 2011 Mar 01  Updated: 2019 May 06

Status: Open
Project: ZABBIX FEATURE REQUESTS
Component/s: Frontend (F)
Affects Version/s: None
Fix Version/s: None

Type: New Feature Request Priority: Major
Reporter: matthias zeilinger Assignee: Unassigned
Resolution: Unresolved Votes: 28
Labels: history, items, spike, trends
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: JPEG File graph.jpg    
Issue Links:
Duplicate
is duplicated by ZBXNEXT-1479 Easy deletion of individual latest da... Closed

 Description   

it would be nice to delete individual values from the db in the frontend.
so if you have a downtime for maybe 10 min, and then you collect data with "delta (simple check)", you will get a huge delta.
if you look than into the graph, it looks not very nice.

br matthias



 Comments   
Comment by Bart Verwilst [ 2012 Jul 15 ]

The way i envision this is by adding a delete button next to every value in the 'latest values' list of a single item ( through Monitoring -> latest data -> Value X -> Graph -> Values ). That would make it so much easier to delete inappropriate single values.

Comment by Oleksii Zagorskyi [ 2013 Feb 19 ]

Users time to time have this problem, just a confirmation:
https://www.zabbix.com/forum/showthread.php?p=126654

Comment by Strahinja Kustudic [ 2013 Nov 25 ]

This feature would be awesome to have and probably not that hard to implement.

Comment by Marcio Campos [ 2016 Aug 07 ]

Any news about this issue?

Comment by Dominique [ 2018 Nov 22 ]

I'm still waiting for this feature, too. Would be really cool instead of always manually querying the database.

Comment by Cesar Murilo da Silva Junior [ 2019 Apr 26 ]

I also need this feature, there is an undesirable traffic value of 27 Tbits which I want to erase from the history. Is there any problem in deleting this amount directly from the database?

Comment by Dominique [ 2019 May 06 ]

I once wrote a short tutorial for myself:

  1. Get itemid from graph URL (for example: /history.php?action=showgraph&itemids[]=444871)
  2. Access Zabbix database.
  3. Find out which type your item has (uint, text, str, log) to know in which history table you have to search for:
    • history_uint
    • history_text
    • history_str
    • history_log
  4. Search the appropriate table with the itemid for the spike:
    zabbix=# select * from history_uint where itemid=444871 order by value DESC limit 5;
     itemid |   clock    |     value      |    ns
    --------+------------+----------------+-----------
     444871 | 1543993500 | 29729269162576 | 606002333
     444871 | 1543964400 |    32170824376 | 384896023
     444871 | 1543965000 |    30664167112 | 514850665
     444871 | 1543964700 |    29971309024 | 862951334
     444871 | 1543965300 |    26845634240 | 455393174
    (5 rows)
    
  5. Simply remove the obviously wrong value from the table:
    zabbix=# delete from history_uint where itemid=444871 and clock=1543993500 and value=29729269162576;
    DELETE 1
    
Generated at Sat Jun 14 17:22:48 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.