I need to extract some data from my Zabbix database(I'm using MySQL - percona 5.6). What I need is an SQL query or set of queries that shows the total number of events(problem status) per trigger severity, grouped by month. What I want is something like this:
+----------+---------------+---------------+----------------+----------------+
| Month | Total Warning | Total Average | Total Critical | Total Disaster |
+----------+---------------+---------------+----------------+----------------+
| 2016-Jan | 1254 | 93 | 133 | 13 |
| 2016-Feb | 11 | 111 | 100 | 900 |
| 2016-Mar | 1249 | 92 | 3 | 0 |
+----------+---------------+---------------+----------------+----------------+
You must be familiar with Zabbix database schema for Zabbix 2.4 to do this
[login to view URL]
Here is a database model for MySQL Workbench: [login to view URL]
I have more than 5 years of professional and practical experience in .MySQL and database development.
I have more than 1800 answers in Stackoverflow(Q&A Site)
[login to view URL]
With my knowledge and background, I am confident I can make an immediate contribution to you. I'm looking forward to have the opportunity to work with you.
I have read your project details, and I am interested in offering my services.
I provide 100% satisfaction guaranteed on all my work.
Contact me at your soonest convenience so we may get your solution delivered quickly.
Thanks,
coderXO
Yes, We are familiar with Zabbix database schema for Zabbix 2.4.
I have read your requirement and we can easily Create SQL query for Zabbix events (MySQL).
We have 4+ years experienced MySql DBA team.
We will happy to allocate that to your project.
You can ask me any questions about MySql we will give you the perfect answer at that moment.
Thanks
Hiren
Hello..sir
I'm sure I can work for you with minimal amount of fee.
I have great experience of Linux Administration and Network Monitoring.
Contact me to negotiate about your issue.
Thanks....