Já sim, veja um exemplo:
ODBC CONNECT TO Zabbix (XUserId is SeEJfYRNJbaMXUVMXLRB, XPassword is XCVadANOQLZGGaBd);
hosts:
LOAD distinct
hostid,
host,
status as hoststatus,
available,
lastaccess,
name as hostname,
flags as hostflags,
groupname,
ApplyMap('t',host) as profile;
SQL SELECT h.*, g.name as groupname
FROM zabbix.items i
inner join zabbix.hosts h on h.hostid = i.hostid
inner join zabbix.hosts_groups hg on hg.hostid = h.hostid
inner join zabbix.items_applications ia on i.itemid = ia.itemid
inner join zabbix.groups g on g.groupid = hg.groupid
inner join zabbix.applications a on a.applicationid = ia.applicationid
where
a.name = 'Qlik'
and h.status = 0
and h.hostid not in (10084);
Store hosts into [$(PATH)\hosts.qvd](qvd);
itens:
LOAD distinct
itemid,
type,
hostid,
if(name like '*$1*', replace(name,'$1',TextBetween(key_,'[',':')),name) as itemname,
status as itemstatus,
units,
mtime,
flags as itemflags,
filter,
state;
SQL SELECT i.*
FROM zabbix.items i
inner join zabbix.hosts h on h.hostid = i.hostid
inner join zabbix.hosts_groups hg on hg.hostid = h.hostid
inner join zabbix.items_applications ia on i.itemid = ia.itemid
inner join zabbix.applications a on a.applicationid = ia.applicationid
where
a.name = 'Qlik'
and h.status = 0
and i.status = 0;
Store itens into [$(PATH)\itens.qvd](qvd);
