Ad Widget

Collapse

Zabbix 2.2 : item lastvalue

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • patrick
    Member
    • Oct 2004
    • 57

    #1

    Zabbix 2.2 : item lastvalue

    Hi,
    How can I get an item last value?
    I have an external php tool to create a web page and I need to get an item last value.
    With Zabbix 1.8, I used a mysql request like this : "SELECT `itemid`, `name`, `lastvalue` FROM `items` WHERE `name` LIKE ..."
    But now in 2.2 I get this error "Unknown column 'lastvalue' ...".
    Lastvalue is not a field of table items in 2.2. Where can I find it?
    Thanks
    Patrick
  • Alexei
    Founder, CEO
    Zabbix Certified Trainer
    Zabbix Certified SpecialistZabbix Certified Professional
    • Sep 2004
    • 5654

    #2
    You can find it in historical tables, have a look at API method history.get.
    Alexei Vladishev
    Creator of Zabbix, Product manager
    New York | Tokyo | Riga
    My Twitter

    Comment

    • patrick
      Member
      • Oct 2004
      • 57

      #3
      Thank you Alexei. I found it in history_uint table
      Patrick

      Comment

      Working...