Zabbix database, from wich table can I get the OS of the host?

[Molusco]

Hi, Im doing this query to get several colums of different tables, and now I need to get the hostname OS, from wich table can I get the OS of the host? and which column do I need?


select history.clock, hstgrp.name as hostgroup, hstgrp.groupid as hgid, hosts.name as hostname,
items.name as item, hosts.hostid, history.value as porcentaje, items.itemid,
applications.name as appname, applications.applicationid as appid, host_tag.value as ztag
FROM history
join items_applications on history.itemid = items_applications.itemid
join applications on items_applications.applicationid = applications.applicationid
join items on items.itemid = history.itemid
join hosts on items.hostid = hosts.hostid
full join host_tag on hosts.hostid = host_tag.hostid
join hosts_groups on hosts.hostid = hosts_groups.hostid
join hstgrp on hosts_groups.groupid = hstgrp.groupid

[cyber]

By default Zabbix server has no idea, what OS is on the host... you can query that info and store it in inventory or in item value.. Do you gather that info somehow from hosts? if yes and if you store it in inventory, then its "host_inventory"....