I'm trying to get some values out of the database for free memory stats for a specific host. I'm getting the item id as follows;
Its returning an itemid for me, lets say '1234' for the purpose of this post. When i query the history table as so:
It returns zero rows. However using the same method to retrieve the values for any other itemid works fine (cpu stats ect ect).
Where does zabbix keep its vm.memory.size[free] values? it doesnt seem to be a calculated item and the graphs are rendering for my full 6 month data set, just cant find it in the DB :-/
Code:
select i.itemid,v.hostid,v.host,i.description,i.lastvalue,i.key_ from hosts v, items i where v.hostid = i.hostid and v.host = 'mymachine' and i.key_ = 'vm.memory.size[free]';
Code:
select * from history where itemid = '1234' and clock > '1312260260';
Where does zabbix keep its vm.memory.size[free] values? it doesnt seem to be a calculated item and the graphs are rendering for my full 6 month data set, just cant find it in the DB :-/
Comment