eduardosilva Posted April 17, 2011 Share Posted April 17, 2011 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! 0 Quote Link to comment Share on other sites More sharing options...
eduardosilva Posted April 26, 2011 Author Share Posted April 26, 2011 Sorry for double posting on my own post, but i need some help with this. Thanks 0 Quote Link to comment Share on other sites More sharing options...
bear Posted April 26, 2011 Share Posted April 26, 2011 Try this? SELECT COUNT(*) FROM `tbltickets` WHERE `status` = 'closed' Change the status to the one you need. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.