Alex-R

Hi, i try to create performance graph for Zabbix monitoring tool (host performance), but don't know how to do it. With two separate graphs it's work, but not both lines in one graph. Zabbix key for Free RAM is "vm.memory.size[free]", for Total RAM is "vm.memory.size[total]". I use two sql query like: mysql> SELECT items.name AS item_name, trends_uint.clock AS trends_clock, trends_uint.`value_avg` AS mem_total_value_avg FROM items, hosts, trends_uint WHERE items.itemid = trends_uint.itemid AND items.hostid=hosts.hostid AND hosts.host='vsrvlab02' AND items.key_='vm.memory.size[total]'; +--------------+--------------+---------------------+ | item_name | trends_clock | mem_total_value_avg | +--------------+--------------+---------------------+ | Total memory | 1355230800 | 52976156672 | | Total memory | 1355234400 | 52976156672 | | Total memory | 1355238000 | 52976156672 | | Total memory | 1355241600 | 52976156672 | | Total memory | 1355245200 | 52976156672 | | Total memory | 1355248800 | 52976156672 | and mysql> SELECT items.name AS item_name, trends_uint.clock AS trends_clock, trends_uint.`value_avg` AS mem_total_value_avg FROM items, hosts, trends_uint WHERE items.itemid = trends_uint.itemid AND items.hostid=hosts.hostid AND hosts.host='vsrvlab02' AND items.key_='vm.memory.size[available]'; +------------------+--------------+---------------------+ | item_name | trends_clock | mem_total_value_avg | +------------------+--------------+---------------------+ | Available memory | 1355227200 | 49191104253 | | Available memory | 1355230800 | 49189984722 | | Available memory | 1355234400 | 49189881979 | | Available memory | 1355238000 | 49188418544 | | Available memory | 1355241600 | 49187489093 | | Available memory | 1355245200 | 49186475540 | I've tried retrieve data from subreport, but it not worked for the graphs p.s. i'm not sql or BI guru, pls explain more detailed Thanks!

Can you explain how you're did it? RTNX variable is master report from? And it mapped via "Return Value" to subreport variable? Just in my case, i see mapped variable value on master report only when I place it as Text field, but not in Chart. When I select this variable in Chart and try to run report, it's fail with "Category series name is null". I've select Chart properties "Evaluation time" = Band and master (mapped) variables Calculation = System