Concluído

Create SQL query for Zabbix events (MySQL)

Job Description:

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]

Habilidades: Linux, MySQL, SQL

Sobre o Cliente:
( 3 comentários ) Benavidez, Argentina

ID do Projeto: #11567748

Concedido a:

mahmoudgamal008

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] Mais

$30 USD em 0 dias
(40 Comentários)
5.6

11 freelancers estão ofertando em média $29 nesse trabalho

toinnisfree

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 q Mais

$45 USD em 1 dia
(395 Comentários)
7.7
OrangeTechsol

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 Mais

$55 USD em 1 dia
(17 Comentários)
5.3
dsasoftware

Hola! El caso parece sencillo. Nos proporcionas una copia de la base de datos o acceso por el puerto 3306. Podremos hacerlo. Contactanos!

$25 USD in 0 dias
(14 Comentários)
4.4
davedcb

Hello, I am interested in your project. I am a software engineer and I have professional experience with MySQL. Thank you, Best regards, David

$30 USD in 3 dias
(23 Comentários)
4.1
c0deg0d

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....

$15 USD em 1 dia
(2 Comentários)
2.3
bseenu

I can give it a shot, is there a dump available which i can load into mysql and work on the query to group by month wise

$20 USD em 1 dia
(0 Comentários)
0.0
marianob88

I work every day making SQL querys

$25 USD em 1 dia
(0 Comentários)
0.0