Improvements - Allow to use variables on multiquery items
Database monitoring agent for zabbix
Brought to you by:
kiu345
Menu
▾
▴
#8 Improvements - Allow to use variables on multiquery items
Allow to use variables on multiquery items
Check This example:
<parms type="oracle" prefix="oracle.">
<server>
<discovery time="60" item="event.discovery" names="EVENT_NAME|EVENT_ITEM">
select 'event 1', 'eventitem1' from dual
</discovery>
<multiquery time="60" items="event.value1[%1].2|event.value3[%1].3|event.value3[%1].4" type="column">
select 'eventitem1','value1,'value2','value3' from dual
</multiquery>
</server>
</parms>
where :
event.value1[%1].2
<item_name>[%column positon number].<column position="" number="" where="" value="" will="" be="" extracted=""></column></item_name>
This is only a example, if this already exists please show me how I can do that.
I really need this improvement, this will decrease the number of queries in 80%.
Will improve performance and decrease database overhead caused by dababix.
I'll try to work on this asap...
Diff:
I put in hold the development of scripts for Oracle Monitoring. This will help me a lot. Using LLD we are monitoring around 500 items. But we had to execute same query many times to get column, with this improvement a single query will generate and monitor 70 items at same time.
Thank you.
Any updates? I'll be glad if you help me on this.