Ad Widget

Collapse

error in events history SQL query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sunadmn
    Member
    Zabbix Certified Specialist
    • Aug 2006
    • 38

    #1

    error in events history SQL query

    Hey all I have this error when I am trying to pull even history has anyone seen this?

    Error in query [select distinct a.clock,a.value,a.triggerid from alarms a,functions f,items i where a.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=hg.hostid and hg.groupid=7 order by clock desc limit 1000] [Unknown table 'hg' in where clause]
Working...