Creating a trigger report.
I've got a somewhat unique situation. I need to regularly create reports from Zabbix for a different team. The report needs to show all of the triggers grouped by host for a given Zabbix group. Essentially, someone wants to see all the alert e-mails they could potentially receive from Zabbix.
Building the report was easy except for one point. I used MySQL Workbench to generate a query which prompts for the Zabbix group name. The problem I have is that I cannot figure out an easy way to fill the macros. For the report I'm generating, the team doesn't want to see "Free disk space less than {$DISKFREE_CRIT}%", they want to see "Free disk space less than 5%". I have worked around this by using REPLACE and manually filling in the values, but this is becoming difficult to manage
Has anyone else dealt with a similar situation and found a good solution?
Building the report was easy except for one point. I used MySQL Workbench to generate a query which prompts for the Zabbix group name. The problem I have is that I cannot figure out an easy way to fill the macros. For the report I'm generating, the team doesn't want to see "Free disk space less than {$DISKFREE_CRIT}%", they want to see "Free disk space less than 5%". I have worked around this by using REPLACE and manually filling in the values, but this is becoming difficult to manage
Has anyone else dealt with a similar situation and found a good solution?