Hello there,
I know that this is a bit off topic, but I would like to monitor my tickets using zabbix. The basic idea is to run a bash script for querying the mysql database of whmcs and then return the ticket count to zabbix.
Since I'm not familiar with whmcs database, or even not very familiar with mysql at all, can someone helpme with those queries? (I can handle with the rest, but the queries are a bit complicated for me)
I would need to get the counts for tickets:
- Awaiting reply
- All active tickets
- Closed tickets
It would also be great if I could get a count for tickets "Awaiting reply" with "High Priority" is this possible?
Thank you!