Ad Widget

Collapse

Need workaround for key data stored incorrectly in DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vlturner
    Junior Member
    • Aug 2011
    • 28

    #1

    Need workaround for key data stored incorrectly in DB

    Zabbix stores the key data in the following ways

    1) As Is
    2) Delta
    3) Delta per second

    The problem is is that the data should be stored in the DB in the "As Is" format.
    Then it should be presented as one of the three. This way you can retrieve the as is data when needed for other forms of analysis. You can build new key data from analysis of a number of other keys.

    What I need is a way to take a key as it comes in in the as is format, and gets plugged into another key as delta or delta per sec.

    Key 1 ( as is ) --> macro(key2 = key1) --> Key 2 ( delta || delta per sec )

    Any suggestions without having to write perl to query mysql and then use sender api to write out the new key?
Working...