Zabbix backend help! greatly needed.

[jjer]

Hi guys,

Firstly let me introduce myself to the community. Im very new to Zabbix and my supervisor wants me to generate reports by using mysql query on the Zabbix backend database.

Reports should be generated on a monthly basis but I dont understand how the time in Zabbix is presented. How should my query be structured so that query limits to the particular month? (eg. ddmmyyyyhhmmss?) The other problems I faced is which table should i get my data from, history or history_str?

I preach to all the kind professionals here in this community, any kind of possible help would be greatly appreciated. Thank you guys

[Aly]

1. Time stored in UNIX TIMESTAMP
2. pickup table by data type (float - history, str - history_str, int - history_uint and etc.)

That helped?

[jjer]

oh man, that helped me greatly!

therefore for example, for generate data on cpu avalibility i should get from history_str (string) or history_uint (int) if i need to transfer it to excel.

And also, what does history_uint_sync does?

Im so sorry, could someone help?