Find Jobs
Hire Freelancers

Create SQL query for Zabbix events (MySQL)

$10-30 USD

Completed
Posted over 7 years ago

$10-30 USD

Paid on delivery
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]
Project ID: 11567748

About the project

11 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 0 day
4.9 (40 reviews)
5.6
5.6
11 freelancers are bidding on average $29 USD for this job
User Avatar
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 in 1 day
4.9 (395 reviews)
7.7
7.7
User Avatar
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 in 1 day
5.0 (17 reviews)
5.3
5.3
User Avatar
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 day
4.9 (14 reviews)
4.4
4.4
User Avatar
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 days
5.0 (23 reviews)
4.1
4.1
User Avatar
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 in 1 day
5.0 (2 reviews)
2.3
2.3
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I work every day making SQL querys
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ARGENTINA
Benavidez, Argentina
5.0
3
Payment method verified
Member since Nov 24, 2010

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.