mysql

[BusteR81]

how do i execute a mysql command to grab triggers that are TRUE for any hosts in a zabbix database ?

[Tenzer]

I haven't tried it extensively, but I think this does what you request:
SELECT * FROM triggers WHERE status != 0;

[BusteR81]

i tried that before. Field status means either enable (0) and disabled (1)

status doesn't means TRUE or FALSE. what i need to to extract triggers that are currently TRUE (eg, from overview.php) from a Mysql console

[trikke]

SELECT * FROM triggers WHERE value != 0 maybe? As far as I know, value 0 = OFF and value 1 = ON

Greets
Patrick