Can Anyone help me with an SQL query for zabbix Database?

[sandeep.parekh]

Hi,

Thanks you for seeing the post.

I am very new to zabbix. Recently started using it. I want to create a safety report.

I want to get list of all the triggers which are enabled in a particular template but disabled in the hosts where the template is applied.

I am very new to zabbix database. any help is greatly appreciated.

Thanks in advance.

Sandeep