how to retrieve latest data in mysql?

[jains]

hi,
my issue is related to zabbix and mysql.
I wish to see "Latest Data" in mysql but unfortunately cannot find in any of the zabbix database tables.

any help would be highly appreicated.
thanks

[Calimero]

Field 'lastvalue' in table 'items' ?

[trikke]

Hi,

check lastvalue in items table!

greets
Patrick

[jains]

Thanks for yuor suggestions..
however, when i try the 'lastvalue' , the column only shows NULL..
is it possible that there might be some other way to retrieve the lastest data in mysql?

[rue]

Have a look at the history-tables... .

history
history_log
history_str
history_sync
history_text
history_uint

You should find the history of all values for all items defined there.

E.g. "select * from history;" would give you all historic rercords for all sensors that deliver float values... .

cheers

Rü