Closed

Create SQL query for Zabbix events (MySQL)

This project was awarded to mahmoudgamal008 for $30 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$10 - $30 USD
Total Bids
13
Project 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

[url removed, login to view]

Here is a database model for MySQL Workbench: [url removed, login to view]

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online