dbforbix - 'explode' a resultset to graph-items dinamicaly

[ekanegae]

hi,

We're running zabbix 2.2.x and we have already installed dbforbix last week and some Oracle items are already working fine - data collect, charts, triggers.

But the items we're already measuring are 'numeric/scalar' values, such as 'uptime', 'archivelog' or 'number of active sessions'.

I created a new dbforbix item, named "sessions per user", and also wrote the proper query at query file as:

sessions_per_user.Query=select s.username,count(s.sid) as total from v$session s where s.username is not null group by s.username

sessions_per_user.NoDataFound=none

...and this query returns something like:

USERNAME   | TOTAL
-----------+-------
Jason      |  7
Bob        |  2
Admin_user |  5

My question: is there anyway to configure this dbforbix item and populate a Graph automatically where each user will be represented as colored graph line and Y axis will represent the "TOTAL" column?

Or may I have to create 3 dbforbix items/queries - one for each user I what to monitor ?