requet Mysql for extract all last values for a host

[aminos1985]

Hi,

I look through internet a shema of the database of Zabbix, but i don't found...

I need a query MySQL allowing extract all last values (Latest data) for a host.

help me please

[aminos1985]

No HELP

No help

[zaicnupagadi]

So the resolution is very easy man,

1. Just enable the mysql logging query - here you have everything nicely written -> http://www.redips.net/mysql/query-logging/

and try to make a situation you are written about, and search for it in that log - you will clearly see what operations has been done

2. ...or the second thing:
Simply install "MySQL Workbech" -> http://wb.mysql.com/ (it is more clear on windows in application for me) - and search for the phrase you are interested about in the database - also quite simple, and later step after step (primary key by primary key ) you will find the solution.

I will be on work today on the second shift, so if I would have a little time I will check it for you - no pb man.

And now I will have a question to you! - do you know how to prepare dynamic view/map/group ?? I have written a post on this forum - http://www.zabbix.com/forum/showthread.php?t=20196 I would be appreciate for help.

Cheers!
Pawel

[aminos1985]

Thinks MAN