Create SQL query for Zabbix events (MySQL)

$10-30 USD

Selesai

Disiarkan

lebih dari 7 tahun yang lalu

$10-30 USD

Dibayar semasa penghantaran

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]

Linux

MySQL

SQL

ID Projek: 11567748

Tentang projek

11 cadangan

Projek jarak jauh

Aktif 8 tahun yang lalu

Ingin menjana wang?

Alamat e-mel

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda

Dapatkan bayaran untuk kerja anda

Tuliskan cadangan anda

Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

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

$30 USD dalam 0 hari

4.9

(40 ulasan)

5.6

11 pekerja bebas membida secara purata $29 USD untuk pekerjaan ini

@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 quickly. Thanks, coderXO

$45 USD dalam 1 hari

4.9

(395 ulasan)

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

$55 USD dalam 1 hari

5.0

(17 ulasan)

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 dalam 0 hari

4.9

(14 ulasan)

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 dalam 3 hari

5.0

(23 ulasan)

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 dalam 1 hari