Ad Widget

**Aly** · 10-02-2010, 08:57

Use event.get();

**mvrk** · 12-02-2010, 10:42

with event.get(), i retrieve records like this :

[0] => Array
(
[eventid] => 3171523
[source] => 0
[object] => 0
[objectid] => 18916
[clock] => 1264501791
[value] => 0
[acknowledged] => 0
)

Whow do i transform this to the kind of info that shows in the dashboard latest 20 issues?

What does the objectid correspond to? triggerid?

I need something like:
HOSTNAME | ISSUE
server1 | CPU ocupation high (95%)

**nelsonab** · 12-02-2010, 13:01

Originally posted by mvrk

I need something like:
HOSTNAME | ISSUE
server1 | CPU ocupation high (95%)

To do that you'll have to dig a little deeper with the values returned. That's pretty much the way it's done in the Zabbix GUI code. You get an id, then look up the id, which gives you the name, and component parts and so forth. Trying to unravel trigger expressions in the DB... that can be painful... :-D

**Aly** · 12-02-2010, 13:28

Originally posted by mvrk

with event.get(), i retrieve records like this :

[0] => Array
(
[eventid] => 3171523
[source] => 0
[object] => 0
[objectid] => 18916
[clock] => 1264501791
[value] => 0
[acknowledged] => 0
)

Whow do i transform this to the kind of info that shows in the dashboard latest 20 issues?

What does the objectid correspond to? triggerid?

I need something like:
HOSTNAME | ISSUE
server1 | CPU ocupation high (95%)

1. objectid = triggerid if object = 0
2. set sortfield with limit.. because there could be > 100,000 events per trigger, I bet U don't need them all.
3. try adding params like:
select_hosts =>1, select_triggers=>1,extendoutput=>1

**jmusbach** · 20-12-2013, 17:54

Hello, I'm trying to do this as well but am finding it difficult and am wondering if anyone might be able to offer some tips. I currently have:

Code:

#!/usr/bin/perl

use ZabbixAPI;
use DateTime

my $counter=1;
my $zab=ZabbixAPI->new("http://zabbox.asfasf.com/zabbix/");
$zab->login("apiguy2","sfgdgdgsdgsr");

my $events=$zab->event_get(
        {
                output => 'extend',
                selectHosts => 'extend',
                selectTriggers => 'extend',
                value => 1,
                limit => 20
        }
);

for my $event (@$events) {
        my $dt=DateTime->from_epoch(epoch => $event->{clock});
        my $timestamp=$dt->day." ".$dt->month." ".$dt->year." ".$dt->hour.":".$dt->minute.":".$dt->second;

        print "Host: ".${$event->{hosts}}[0]->{name}." Issue: ".${$event->{triggers}}[0]->{description}." Last change: ".$timestamp."\n"; 
}

This works fine except the problem is that despite me filtering for only events that are marked as a problem (value => 1) I'm getting old events that're no longer problems. There's only 4 issues currently listed in the zabbix web ui's Last 20 Issues box but this API query's returning back events from several months ago. What am I missing? Thanks!

**jmusbach** · 24-12-2013, 19:40

Bump, anyone?

**Speedfight** · 04-04-2014, 15:08

add:

PHP Code:


only_true => true,

**jmusbach** · 04-04-2014, 16:38

Thanks but are you sure that's supported for event.get?

When I do that I get the error below.

Code:

malformed JSON string, neither array, object, number, string or atom, at character offset 0 (before "<html><head><title>O...") at (eval 4) line 163.

**Speedfight** · 07-04-2014, 10:31

Sorry my bad.

I did this for "trigger.get"

**kargh** · 07-04-2014, 12:49

Basically what you need to do is grab the last 20 events using event.get. Then you need to grab the event tree for each of the events so you can figure out duration (Current Event Time - Previous Event Time = Duration). You'll also need to grab the trigger for each of the events if you want to know what triggered the event.

I have code that does something similar. Let me see if I can modify it to work for you.

-- Jess

**kargh** · 07-04-2014, 13:56

I borrowed this code directly from the Zabbix source and modified it slightly so that it would work for what you want. Also, I use the PhpZabbixApi library. If you don't, then you'll have to change the API call to whatever method you prefer.

PHP Code:


$sortField = array('lastchange');

$sortOrder = array('DESC');



$eventsTimeFrame = $api->triggerGet(array(

     'groupids'      => null,

     'hostids'       => null,

     'monitored'     => true,

     'maintenance'   => false,

     'filter'        => array('value' => 1),

     'skipDependent' => true,

     'output'        => array('triggerid', 'state', 'error', 'url', 'expression', 'description', 'priority', 'lastchange'),

     'selectHosts'   => array('hostid', 'name'),

     'selectLastEvent' => array('eventid', 'acknowledged', 'objectid', 'clock', 'ns'),

     'sortfield'     => $sortField,

     'sortorder'     => $sortOrder,

     'limit'         => '20'

));





$eventsTimeFrame = json_decode(json_encode($eventsTimeFrame), true);

-- Jess

**Speedfight** · 07-04-2014, 15:26

@kargh

Thanks,

I builded somelike your code.

PHP Code:


    $data = array(

        'jsonrpc' => "2.0",

        'method' => "trigger.get",

        'params' => array(

            'output' => array('triggerid', 'state', 'error', 'url', 'expression', 'description', 'priority', 'lastchange'),

            'selectHosts' => array('hostid', 'name'),

            'selectLastEvent' => array('eventid', 'acknowledged', 'objectid', 'clock', 'ns'),

            'sortfield'     => "lastchange",

            'monitored'=> "true",

            'only_true' => "true",

            'maintenance' => "false",

            'limit' => "20",

        ),

        'id' => "1",

        'auth' => $authcode

    );

**jmusbach** · 07-04-2014, 19:43

Originally posted by Speedfight

Sorry my bad.

I did this for "trigger.get"

Oh hm ok, guess that's the method that's supposed to be used then. I'll look into changing my code to call that instead. Thanks.

EDIT: Thanks for the examples guys I'll check those out.

**kargh** · 07-04-2014, 21:40

You could probably do it another way but why reinvent the wheel when the work was already done by someone else?

Ad Widget

Zabbix API to get latest 20 issues

Zabbix API to get latest 20 issues

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment