Maintenance Mode Query

[gelowe]

I would like to get a mysql query i can run against the zabbix DB that tells me what servers are in maint mode. Problem we are having is sometimes servers are left in maint mode for too long and we don't see alerts. I am well aware of using timer to expire in maint but I would still like a way via SCRIPT that i could find out what systems are still in maint mode.

[gelowe]

I figured it out

run this query against the DB


SELECT host
FROM `hosts`
WHERE maintenance_status <>0 and status = 0