How to upload data from Zabbix?

Question

linux

What is the query to find all eventlog from computer pc1 ?
the computer pc1 has hostid=10125 if you believe the address line:
to confirm that 10125 is pc1 made a request in the hosts table

. About 80 servers will be monitored, you need to pull out data by computer name and eventid in order to analyze it in excel.

Answer 1

select h.name, i.name, i.key_, hs.clock, hs.value
from 
  hosts h 
  join items i on h.hostid = i.hostid
  join history_log hs on i.itemid = hs.itemid
where h.name = 'zabbix'

Answer 2

Write a script and pull through the API?