select i.itemid, i.hostid, i.status, i.type, i.value_type, i.key_, i.snmp_oid, i.ipmi_sensor, i.delay, i.trapper_hosts, i.logtimefmt, CASE WHEN i.type in (13,14,11,15) THEN i.params ELSE NULL end, ir.state, i.authtype, i.username, i.password, i.publickey, i.privatekey, i.flags, i.interfaceid, ir.lastlogsize, ir.mtime, i.history, i.trends, i.inventory_link, i.valuemapid, i.units, ir.error, i.jmx_endpoint, i.master_itemid, i.timeout, i.url, i.query_fields, CASE WHEN i.type in (19) THEN i.posts ELSE NULL end, i.status_codes, i.follow_redirects, i.post_type, i.http_proxy, CASE WHEN i.type in (19) THEN i.headers ELSE NULL end, i.retrieve_mode, i.request_method, i.output_format, i.ssl_cert_file, i.ssl_key_file, i.ssl_key_password, i.verify_peer, i.verify_host, i.allow_traps, i.templateid, null from items i inner join hosts h on i.hostid=h.hostid join item_rtdata ir on i.itemid=ir.itemid where h.status in (0,1) and i.flags<>2;
0001-.-ZBX-22363-fixed-dbschema-and-dbpatch-for-testing.patch
Archive.7z
screenshot-1.png
Team A
