from zabbix_api import ZabbixAPI
import codecs

server = "https://localhost"
username = "Admin"
password = "zabbix"

zapi = ZabbixAPI(server=server, path="", log_level=0)
zapi.login(username, password)

out_file = codecs.open('output.csv', 'w', 'utf-8')
groupid = 264

INTERFACE_TYPE = {
    "1": "Zabbix Agent",
    "2": "SNMP"
}

hosts = zapi.host.get({"groupids": groupid, "filter": {"status": 0}})

out_file.write("host_name,host_alias,ip,dns,item,trigger name,trigger expression\n")

for host in hosts:
    host_id = host['hostid']
    host_name = host['host']
    host_alias = host['name']
    interface = zapi.hostinterface.get({"hostids": host_id})[0]
    interface_ip = interface['ip']
    interface_dns = interface['dns']
    interface_type = INTERFACE_TYPE[interface['type']]
    items = zapi.item.get({"hostids": host_id})
    for item in items:
        item_id = item['itemid']
        item_name = item['name']
        triggers = zapi.trigger.get({"itemids": item_id})
        for trigger in triggers:
            trigger_id = trigger['triggerid']
            trigger_description = trigger['description']
            trigger_expression = trigger['expression']

            out_file.write(u"{0};{1};{2};{3};{4};{5};{6}\n".format(
                host_name,
                host_alias,
                interface_ip,
                interface_dns,
                item_name,
                trigger_description,
                trigger_expression)
            )