how to get lastest value from mysql?

[heimouren]

I am a newer.
I configured a item,I want to get lastest value from mysql.
I don't know how to get the value.
some one help me.
I use the zabbix version that is 2.4.0.

[tchjts1]

Why would you want to get it from MySql?
Instead, go to Monitoring --> Latest Data and click on the "Graph" link all the way out to the right for your specific item. After the graph comes up, you can change the upper right dropdown box from "Graph" to Latest Values"

[heimouren]

Why would you want to get it from MySql?
Instead, go to Monitoring --> Latest Data and click on the "Graph" link all the way out to the right for your specific item. After the graph comes up, you can change the upper right dropdown box from "Graph" to Latest Values"

I want to show the latest data in map.and I have integrated with google map.
so I want to get the latest Data from mysql

[aib]

The short answer - for the map you can use the structure:

{hostname:itemname.last(0)}

Please, feel free to use the real Hostname and the real Itemname in the theoretical structure.

[heimouren]

The short answer - for the map you can use the structure:

{hostname:itemname.last(0)}

Please, feel free to use the real Hostname and the real Itemname in the theoretical structure.

you don't understand what I mean.
you give the expression that is not I want.



you can see the picture above.

so you will understand.

I want to show infos in google map.

some one help me!!!!

[aib]

OK

You cannot describe what you want - because of that I use the general answer.

1) You would like to "show infos on the graph". Which kind of "infos" ? CPU idle time? CPU user time? Free space on C: drive? Free inodes on \ ?
Be more precise and ask a smart question

For example, to show information about CPU Load for CDN-5 on Zabbix map, you can use expression:

{cnd-5:system.cpu.util[,idle].last(0)}

2) About Google maps integration. In the topic https://www.zabbix.com/forum/showthread.php?t=14434 it was requested 5 years ago. Is still not finished. You can ask the developers team to pay more attention for that, but nobody can guarantee that it will be done soon.

Sorry, I cannot really help you.

[heimouren]

OK

You cannot describe what you want - because of that I use the general answer.

1) You would like to "show infos on the graph". Which kind of "infos" ? CPU idle time? CPU user time? Free space on C: drive? Free inodes on \ ?
Be more precise and ask a smart question

For example, to show information about CPU Load for CDN-5 on Zabbix map, you can use expression:

{cnd-5:system.cpu.util[,idle].last(0)}

2) About Google maps integration. In the topic https://www.zabbix.com/forum/showthread.php?t=14434 it was requested 5 years ago. Is still not finished. You can ask the developers team to pay more attention for that, but nobody can guarantee that it will be done soon.

Sorry, I cannot really help you.

first of all,thank you for your reply.
I just want to know how to get the specify item latest data from mysql.
If I get that I will know how to show infos in google map.
In mysql there is a table named history_uint,some items that there are no datas in this table.I know there is relation between items , history* and trend*.
But I don't know how.

[aib]

Try to use Zabbix API

https://www.zabbix.com/documentation/2.4/manual/api

and API Libraries

http://zabbix.org/wiki/Docs/api/libraries

I hope it helps.

[heimouren]

Try to use Zabbix API

https://www.zabbix.com/documentation/2.4/manual/api

and API Libraries

http://zabbix.org/wiki/Docs/api/libraries

I hope it helps.

I use api to get the latest value.
for example,
request:

{ "jsonrpc": "2.0", "method": "history.get", "params": { "output": "extend", "history": 0, "itemids": "23985", "sortfield": "clock", "sortorder": "DESC", "limit": 10 }, "auth": "a4fa1a7d7db775ec975df2fcb9daa876", "id": 32 }

result:

{ "jsonrpc": "2.0", "method": "history.get", "params": { "output": "extend", "history": 0, "itemids": "23985", "sortfield": "clock", "sortorder": "DESC", "limit": 10 }, "auth": "a4fa1a7d7db775ec975df2fcb9daa876", "id": 32 }

array(3) { ["jsonrpc"]=> string(3) "2.0" ["result"]=> array(0) { } ["id"]=> int(32) }

no result.

but this request return result,
request:

{ "jsonrpc": "2.0", "method": "history.get", "params": { "output": "extend", "history": 0, "itemids": "23698", "sortfield": "clock", "sortorder": "DESC", "limit": 10 }, "auth": "872d494bdd4c1249c2ca56f2129927ff", "id": 2 }

result:

array(3) { ["jsonrpc"]=> string(3) "2.0" ["result"]=> array(10) { [0]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416369358" ["value"]=> string(6) "0.1212" ["ns"]=> string(9) "608058291" } [1]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416369298" ["value"]=> string(6) "0.2465" ["ns"]=> string(9) "568117856" } [2]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416369238" ["value"]=> string(6) "0.0627" ["ns"]=> string(9) "649285866" } [3]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416369178" ["value"]=> string(6) "0.0835" ["ns"]=> string(9) "655900119" } [4]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416369118" ["value"]=> string(6) "0.0502" ["ns"]=> string(9) "798489016" } [5]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416369058" ["value"]=> string(6) "0.0251" ["ns"]=> string(9) "986785041" } [6]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416368998" ["value"]=> string(6) "0.0711" ["ns"]=> string(9) "488228193" } [7]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416368938" ["value"]=> string(6) "0.0376" ["ns"]=> string(9) "945367472" } [8]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416368879" ["value"]=> string(6) "0.0418" ["ns"]=> string(8) "13008726" } [9]=> array(4) { ["itemid"]=> string(5) "23698" ["clock"]=> string(10) "1416368818" ["value"]=> string(6) "0.0418" ["ns"]=> string(9) "425590063" } } ["id"]=> int(2) }

I found that their value_types are different.

mysql> select value_type from items where itemid in('23698','23985'); 
+------------+
| value_type |
+------------+
|          0 |
|          3 |
+------------+

why?

[Colttt]

maybe you want something like this: https://support.zabbix.com/browse/ZBXNEXT-1332 ?