Ad Widget

Collapse

Extracting values from database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • kaya
    Junior Member
    • Jan 2011
    • 2

    #1

    Extracting values from database

    Hi,

    I would like to extract values as a csv file to be able to incorporate them into personalized excel graphs.

    I tried looking at the database, and found out that the data seems to be stored into "history" table. I can't however find out what the clock format is.

    Can someone help me ? Or is there a simpler way to get a human readable extract ?

    Thanks
  • nelsonab
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2006
    • 1233

    #2
    unixtimestamp
    RHCE, author of zbxapi
    Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
    Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

    Comment

    • kaya
      Junior Member
      • Jan 2011
      • 2

      #3
      Thanks !

      So I guess there's no other way than to look into the database

      Comment

      • nelsonab
        Senior Member
        Zabbix Certified SpecialistZabbix Certified Professional
        • Sep 2006
        • 1233

        #4
        The API has some rudimentary calls. You can do some of this with Zabcon, but my development machine is powered off right now. I'll try and post something in a little bit.
        RHCE, author of zbxapi
        Ansible, the missing piece (Zabconf 2017): https://www.youtube.com/watch?v=R5T9NidjjDE
        Zabbix and SNMP on Linux (Zabconf 2015): https://www.youtube.com/watch?v=98PEHpLFVHM

        Comment

        Working...