Create SQL query for Zabbix events (MySQL)

$10-30 USD

Tamamlandı

İlan edilme:

7 yıldan fazla önce

$10-30 USD

Teslimde ödenir

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

Proje No: 11567748

Proje hakkında

11 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 8 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@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 0 gün içinde

4,9

(40 değerlendirme)

5,6

11 freelancer bu proje için ortalama $29 USD teklif veriyor

@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 1 gün içinde

4,9

(395 değerlendirme)

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 1 gün içinde

5,0

(17 değerlendirme)

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 0 gün içinde

4,9

(14 değerlendirme)

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 3 gün içinde

5,0

(23 değerlendirme)

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 1 gün içinde