PHP simple functions to get performance data from Nagios database

Given a nagios database (I can provide one sql file with all the tables and data for testing purposes), I would like to have coded two similar functions creating queries that use the NDOUtils DB model ([url removed, login to view])

1) function report_nagios_services ($array_of_service_IDs, $date, $type)

It returns 5 arrays (or 1 array of 5 arrays) that shows how long each monitor has been ok, warning, unknown, undetermined or critical.

$type can have 3 values: day, month or year using $date as reference: day means apply the function to the nagios data of the date $date, month means apply the function to the nagios data of the 30 last days before $date (including $date) and year means 365 days before $date (including $date)

For instance report_nagios_services(array(1,2,3),$date,"day")

returns

$result_ok = [100,52,27]

$result_warning = [0,48,0]

$result_unknown = [0,0,0]

$result_undetermined = [0,0,0]

$result_critical = [0,0,73]

which means that service_id 1 has been OK all the time so far today, service_id 2 has been ok 52% of the time and in warning 48%, and service_id 3 has been ok 27% of the time and critical 73% of the time. For each service_id, the5 values should always sum the same value.

Please note that I will need a different array for each state, or an array of arrays as $result['ok'], $result['warning'], etc.

2) function report_nagios_hosts ($array_of_host_IDs, $date, $type) similar to the previous but for a list of hosts instead of for a list of services

I will have more complex nagios queries after these first two. This project is just a proof of concepts of the skills of the coder.

Linux MySQL PHP SQL

プロジェクトID: #5707327

プロジェクトについて