Mysql: get hostid

[LPby]

I have triggerid, how can I get hostid for this trigger directly from mysql database? Thanks in advance!

[LPby]

Solved by myself:

#!/bin/bash

for TRID in $(mysql -uroot -e "select triggerid from zabbix.triggers where status=0 and value=1" | sed '1d')
do
    ITMID=$(mysql -uroot -e "select itemid from zabbix.functions where triggerid=$TRID" | sed '1d')
    HOSTID=$(mysql -uroot -e "select hostid from zabbix.items where itemid=$ITMID" | sed '1d')
    HOSTNAME=$(mysql -uroot -e "select name from zabbix.hosts where hostid=$HOSTID" | sed '1d')
    echo "TriggerId: $TRID"
    echo "ItemID: $ITMID"
    echo "HostID: $HOSTID"
    echo "Hostname: $HOSTNAME"
    echo
done

[ableev]

Try this one:

SELECT t.triggerid AS TriggerId, i.itemid AS ItemID, h.hostid AS HostID FROM zabbix.triggers t JOIN functions f ON f.triggerid=t.triggerid JOIN items i ON i.itemid=f.itemid JOIN hosts h ON h.hostid=i.hostid where t.status=0 and t.value=1 \G

One and fast select