mysql> select hostid from hosts where host = 'msk-BE-hub-dps-VPN201';
+-----------------+
| hostid          |
+-----------------+
| 300100000000012 |
+-----------------+

mysql> select itemid, hostid, description from items where hostid = 300100000000012;
+-----------------+-----------------+-------------+
| itemid          | hostid          | description |
+-----------------+-----------------+-------------+
| 300100000000009 | 300100000000012 | ICMP Loss   |
| 300100000000010 | 300100000000012 | ICMP RTT    |
+-----------------+-----------------+-------------+


mysql> select * from functions where itemid = 300100000000009;
+-----------------+-----------------+-----------------+----------+-----------+
| functionid      | itemid          | triggerid       | function | parameter |
+-----------------+-----------------+-----------------+----------+-----------+
| 300100000000076 | 300100000000009 | 300100000000009 | avg      | 300       |
| 300100000000106 | 300100000000009 | 300100000000027 | last     | #1        |
| 300100000000116 | 300100000000009 | 300100000000037 | last     | #2        |
| 300100000000039 | 300100000000009 | 300100000000010 | last     | 0         |
| 300100000000040 | 300100000000009 | 300100000000010 | prev     | 0         |
+-----------------+-----------------+-----------------+----------+-----------+


mysql> select expression, status, value, lastchange from triggers where triggerid = 300100000000009;
+-----------------------+--------+-------+------------+
| expression            | status | value | lastchange |
+-----------------------+--------+-------+------------+
| {300100000000076} >99 |      0 |     0 | 1289162029 |
+-----------------------+--------+-------+------------+

mysql> select *, from_unixtime(clock) from events where objectid = 300100000000009;
+-----------------+--------+--------+-----------------+------------+-------+--------------+-----------+---------------+----------------------+
| eventid         | source | object | objectid        | clock      | value | acknowledged | ns        | value_changed | from_unixtime(clock) |
+-----------------+--------+--------+-----------------+------------+-------+--------------+-----------+---------------+----------------------+
| 300000000000263 |      0 |      0 | 300100000000009 | 1289064949 |     0 |            0 | 508103234 |             1 | 2010-11-06 20:35:49  |
| 300000000000528 |      0 |      0 | 300100000000009 | 1289160709 |     0 |            0 | 206942424 |             0 | 2010-11-07 23:11:49  |
| 300000000000533 |      0 |      0 | 300100000000009 | 1289161609 |     0 |            0 | 136562369 |             0 | 2010-11-07 23:26:49  |
| 300000000000545 |      0 |      0 | 300100000000009 | 1289162029 |     0 |            0 | 531413811 |             0 | 2010-11-07 23:33:49  |
+-----------------+--------+--------+-----------------+------------+-------+--------------+-----------+---------------+----------------------+


MASTER DB:
mysql> select *, from_unixtime(clock) from events where objectid = 300100000000009;
+-----------------+--------+--------+-----------------+------------+-------+--------------+-----------+---------------+----------------------+
| eventid         | source | object | objectid        | clock      | value | acknowledged | ns        | value_changed | from_unixtime(clock) |
+-----------------+--------+--------+-----------------+------------+-------+--------------+-----------+---------------+----------------------+
| 300000000000263 |      0 |      0 | 300100000000009 | 1289064949 |     0 |            0 | 508103234 |             0 | 2010-11-06 20:35:49  |
| 300100000000015 |      0 |      0 | 300100000000009 | 1289160630 |     2 |            0 |         0 |             0 | 2010-11-07 23:10:30  |
| 300100000000024 |      0 |      0 | 300100000000009 | 1289161587 |     2 |            0 |         0 |             0 | 2010-11-07 23:26:27  |
| 300100000000033 |      0 |      0 | 300100000000009 | 1289161887 |     2 |            0 |         0 |             0 | 2010-11-07 23:31:27  |
+-----------------+--------+--------+-----------------+------------+-------+--------------+-----------+---------------+----------------------+