How to quickly find with Unknown status?

[QwErTy_LoGiC]

Hello,

I am wondering if anyone knows how to quickly find triggers with an Unknown status. Right now, I am having troubles finding 2 triggers which have an unknown status among the 6000 other triggers...

Any help appreciated!

[zabbix_zen]

I *think* it's something like,

select triggerid, from_unixtime(lastchange), description, status, value, priority from triggers where status = 2;

[QwErTy_LoGiC]

Thanks!

Should of thought about an SQL query...

Thanks for the tip!