Checking raw data

[youngryan]

While I continue to fight with getting GD working to see graphs, I'd like to confirm my data is being collected. I've not used SQL before, and am stumbling my way through the manual.

Is the following the correct way to see all data collected? Since I'm only seeing a single row, so I assume it isn't working (only one stat captured). This is likely related to my previous post which is now remaining in Active status, but still showing error. I was expecting to see a row for each poll/stat collected.

Why is it showing 'interfaces.ifTable.ifEntry.ifInOctets.1' in snmp_oid? I'm collecting data with a script rather than snmp. I suppose it could be a default.

mysql> use zabbix
mysql> select * from items where itemid = 17319;
+--------+------+----------------+-----------------------------------------+-----------+--------+---------------------------+---------------------------------+-------+---------+--------+------------+------------+------------+------------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+------------------------------------------------------------------+-------------+------------+------------+------------+
| itemid | type | snmp_community | snmp_oid                                | snmp_port | hostid | description               | key_                            | delay | history | trends | nextcheck  | lastvalue  | lastclock  | prevvalue  | status | value_type | trapper_hosts | units | multiplier | delta | prevorgvalue | snmpv3_securityname | snmpv3_securitylevel | snmpv3_authpassphrase | snmpv3_privpassphrase | formula | error                                                            | lastlogsize | logtimefmt | templateid | valuemapid |
+--------+------+----------------+-----------------------------------------+-----------+--------+---------------------------+---------------------------------+-------+---------+--------+------------+------------+------------+------------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+------------------------------------------------------------------+-------------+------------+------------+------------+
|  17319 |    0 | public         | interfaces.ifTable.ifEntry.ifInOctets.1 |       161 |  10008 | myswitch Po1 inoctets | bps[myswitch,Port-channel1] |    30 |      90 |    365 | 1153344990 | 2658664446 | 1153344961 | 2444762998 |      0 |          3 |               | bytes |          0 |     0 |         NULL |                     |                    0 |                       |                       | 1       | Port number must be numeric in [bps[v,Port-channel1]] |           0 |            |          0 |          0 |
+--------+------+----------------+-----------------------------------------+-----------+--------+---------------------------+---------------------------------+-------+---------+--------+------------+------------+------------+------------+--------+------------+---------------+-------+------------+-------+--------------+---------------------+----------------------+-----------------------+-----------------------+---------+------------------------------------------------------------------+-------------+------------+------------+------------+
1 row in set (0.00 sec)

[befortin]

See, lastvalue = 1153344961 and prevvalue = 0, so it looks to me like it's working. For the other values, you'll have to take a look at the "history" table.