function add_host_based_graphs()
{
global $config;
debug("Adding Host Based Graphs");
/* check for host level graphs next data queries */
$host_cpu_dq = read_config_option("hmib_dq_host_cpu");
$host_disk_dq = read_config_option("hmib_dq_host_disk");
$host_users_gt = read_config_option("hmib_gt_users");
$host_procs_gt = read_config_option("hmib_gt_processes");
$hosts = db_fetch_assoc("SELECT host_id, host.description FROM plugin_hmib_hrSystem\n\t\tINNER JOIN host\n\t\tON host.id=plugin_hmib_hrSystem.host_id\n\t\tWHERE host_status=3 AND host.disabled=''");
if (sizeof($hosts)) {
foreach ($hosts as $h) {
debug("Processing Host '" . $h["description"] . "[" . $h["host_id"] . "]'");
if ($host_users_gt) {
debug("Processing Users");
hmib_gt_graph($h["host_id"], $host_users_gt);
} else {
debug("Users Graph Template Not Set");
}
if ($host_users_gt) {
debug("Processing Processes");
hmib_gt_graph($h["host_id"], $host_procs_gt);
} else {
debug("Processes Graph Template Not Set");
}
debug("Processing Disks");
if ($host_disk_dq) {
/* only numeric > 0 */
$regex = "^[1-9][0-9]*";
$field = "hrStorageSizeInput";
add_host_dq_graphs($h["host_id"], $host_disk_dq, $field, $regex);
}
if ($host_cpu_dq) {
add_host_dq_graphs($h["host_id"], $host_cpu_dq);
}
debug("Processing CPU");
}
} else {
debug("No Hosts Found");
}
}
function add_host_based_graphs()
{
global $config, $device_hashes, $device_query_hashes, $device_health_hashes;
debug('Adding Host Based Graphs');
/* check for host level graphs next data queries */
$host_cpu_dq = read_config_option('mikrotik_dq_host_cpu');
$host_users_dq = mikrotik_data_query_by_hash('ce63249e6cc3d52bc69659a3f32194fe');
$hosts = db_fetch_assoc("SELECT host_id, host.description, host.hostname \n\t\tFROM plugin_mikrotik_system\n\t\tINNER JOIN host\n\t\tON host.id=plugin_mikrotik_system.host_id\n\t\tWHERE host_status IN(0,3) AND host.disabled=''");
if (sizeof($hosts)) {
foreach ($hosts as $h) {
debug('Processing Host: ' . $h['description'] . ' [' . $h['hostname'] . ']');
foreach ($device_hashes as $hash) {
$template = mikrotik_template_by_hash($hash);
if (!empty($template)) {
debug('Processing ' . db_fetch_cell_prepared('SELECT name FROM graph_templates WHERE hash = ?', array($hash)));
mikrotik_gt_graph($h['host_id'], $template);
}
}
foreach ($device_query_hashes as $hash) {
$query = mikrotik_data_query_by_hash($hash);
if (!empty($query)) {
debug('Processing ' . db_fetch_cell_prepared('SELECT name FROM snmp_query WHERE hash = ?', array($hash)));
if ($hash == '7dd90372956af1dc8ec7b859a678f227') {
$exclusion = read_config_option('mikrotik_user_exclusion');
add_host_dq_graphs($h['host_id'], $query, 'userName', $exclusion, false);
} else {
add_host_dq_graphs($h['host_id'], $query);
}
}
}
$health = db_fetch_row_prepared('SELECT * FROM plugin_mikrotik_system_health WHERE host_id = ?', array($h['host_id']));
debug('Processing Health');
if (sizeof($health)) {
foreach ($device_health_hashes as $column => $hash) {
if (!empty($health[$column]) && $health[$column] != 'NULL') {
$template = mikrotik_template_by_hash($hash);
if (!empty($template)) {
debug('Processing ' . db_fetch_cell_prepared('SELECT name FROM graph_templates WHERE hash = ?', array($hash)));
mikrotik_gt_graph($h['host_id'], $template);
}
}
}
}
}
} else {
debug('No Hosts Found');
}
}
function add_host_based_graphs()
{
global $config;
debug('Adding Host Based Graphs');
/* check for host level graphs next data queries */
$host_cpu_dq = db_fetch_cell("SELECT id \n\t\tFROM snmp_query \n\t\tWHERE hash='0d1ab53fe37487a5d0b9e1d3ee8c1d0d'");
$host_disk_dq = db_fetch_cell("SELECT id \n\t\tFROM snmp_query \n\t\tWHERE hash='9343eab1f4d88b0e61ffc9d020f35414'");
$host_users_gt = db_fetch_cell("SELECT id\n\t\tFROM graph_templates\n\t\tWHERE hash='e8462bbe094e4e9e814d4e681671ea82'");
$host_procs_gt = db_fetch_cell("SELECT id\n\t\tFROM graph_templates\n\t\tWHERE hash='62205afbd4066e5c4700338841e3901e'");
$hosts = db_fetch_assoc("SELECT host_id, host.description FROM plugin_hmib_hrSystem\n\t\tINNER JOIN host\n\t\tON host.id=plugin_hmib_hrSystem.host_id\n\t\tWHERE host_status=3 AND host.disabled=''");
if (sizeof($hosts)) {
foreach ($hosts as $h) {
debug("Processing Host '" . $h['description'] . '[' . $h['host_id'] . "]'");
if ($host_users_gt) {
debug('Processing Users');
hmib_gt_graph($h['host_id'], $host_users_gt);
} else {
debug('Users Graph Template Not Set');
}
if ($host_users_gt) {
debug('Processing Processes');
hmib_gt_graph($h['host_id'], $host_procs_gt);
} else {
debug('Processes Graph Template Not Set');
}
debug('Processing Disks');
if ($host_disk_dq) {
/* only numeric > 0 */
$regex = '^[1-9][0-9]*';
$field = 'hrStorageSizeInput';
add_host_dq_graphs($h['host_id'], $host_disk_dq, $field, $regex);
}
if ($host_cpu_dq) {
add_host_dq_graphs($h['host_id'], $host_cpu_dq);
}
debug('Processing CPU');
}
} else {
debug('No Hosts Found');
}
}
function add_host_based_graphs()
{
global $config;
debug('Adding Host Based Graphs');
/* check for host level graphs next data queries */
$host_cpu_dq = read_config_option('mikrotik_dq_host_cpu');
$host_users_dq = mikrotik_data_query_by_hash('ce63249e6cc3d52bc69659a3f32194fe');
$host_users_gt = mikrotik_template_by_hash('99e37ff13139f586d257ba9a637d7340');
$host_procs_gt = mikrotik_template_by_hash('e797d967db24fd86341a8aa8c60fa9e0');
$host_disk_gt = mikrotik_template_by_hash('0ece13b90785aa04d1f554a093685948');
$host_mem_gt = mikrotik_template_by_hash('4396ae857c4f9bc5ed1f26b5361e42d9');
$host_cpu_gt = mikrotik_template_by_hash('7df474393f58bae8e8d6b85f10efad71');
$host_arp_gt = mikrotik_template_by_hash('32bd34d525944127063c2d94e2e8f1de');
$host_rts_gt = mikrotik_template_by_hash('8856e3943ecc70e5da835072f584d5a0');
$host_ppp_gt = mikrotik_template_by_hash('47ced1c199d83e8dd79c6ba594c4e3be');
$host_upt_gt = mikrotik_template_by_hash('7d8dc3050621a2cb937cac3895bc5d5b');
$hosts = db_fetch_assoc("SELECT host_id, host.description FROM plugin_mikrotik_system\n\t\tINNER JOIN host\n\t\tON host.id=plugin_mikrotik_system.host_id\n\t\tWHERE host_status=3 AND host.disabled=''");
if (sizeof($hosts)) {
foreach ($hosts as $h) {
debug("Processing Host '" . $h['description'] . '[' . $h['host_id'] . "]'");
if ($host_users_gt) {
debug('Processing Users');
mikrotik_gt_graph($h['host_id'], $host_users_gt);
} else {
debug('Users Graph Template Not Set');
}
if ($host_users_gt) {
debug('Processing Processes');
mikrotik_gt_graph($h['host_id'], $host_procs_gt);
} else {
debug('Processes Graph Template Not Set');
}
if ($host_disk_gt) {
debug('Processing Disk');
mikrotik_gt_graph($h['host_id'], $host_disk_gt);
} else {
debug('Disk Graph Template Not Set');
}
if ($host_mem_gt) {
debug('Processing Memory');
mikrotik_gt_graph($h['host_id'], $host_mem_gt);
} else {
debug('Memory Graph Template Not Set');
}
if ($host_cpu_gt) {
debug('Processing CPU');
mikrotik_gt_graph($h['host_id'], $host_cpu_gt);
} else {
debug('CPU Graph Template Not Set');
}
if ($host_arp_gt) {
debug('Processing ARP');
mikrotik_gt_graph($h['host_id'], $host_arp_gt);
} else {
debug('ARP Graph Template Not Set');
}
if ($host_rts_gt) {
debug('Processing Routes');
mikrotik_gt_graph($h['host_id'], $host_rts_gt);
} else {
debug('Routes Graph Template Not Set');
}
if ($host_ppp_gt) {
debug('Processing PPP Active');
mikrotik_gt_graph($h['host_id'], $host_ppp_gt);
} else {
debug('PPP Active Graph Template Not Set');
}
if ($host_upt_gt) {
debug('Processing Uptime');
mikrotik_gt_graph($h['host_id'], $host_upt_gt);
} else {
debug('Uptime Graph Template Not Set');
}
debug('Processing Users');
if ($host_users_dq) {
add_host_dq_graphs($h['host_id'], $host_users_dq);
}
debug('Processing CPU');
if ($host_cpu_dq) {
add_host_dq_graphs($h['host_id'], $host_cpu_dq);
}
}
} else {
debug('No Hosts Found');
}
}
function add_host_based_graphs()
{
global $config;
debug("Adding Host Based Graphs");
/* check for host level graphs next data queries */
$host_cpu_dq = read_config_option("mikrotik_dq_host_cpu");
$host_users_dq = read_config_option("mikrotik_dq_users");
$host_users_gt = read_config_option("mikrotik_gt_users");
$host_procs_gt = read_config_option("mikrotik_gt_processes");
$host_disk_gt = read_config_option("mikrotik_gt_disk");
$host_mem_gt = read_config_option("mikrotik_gt_memory");
$host_cpu_gt = read_config_option("mikrotik_gt_cpu");
$host_arp_gt = read_config_option("mikrotik_gt_arp");
$host_rts_gt = read_config_option("mikrotik_gt_routes");
$host_ppp_gt = read_config_option("mikrotik_gt_ppp");
$host_upt_gt = read_config_option("mikrotik_gt_uptime");
$hosts = db_fetch_assoc("SELECT host_id, host.description FROM plugin_mikrotik_system\n\t\tINNER JOIN host\n\t\tON host.id=plugin_mikrotik_system.host_id\n\t\tWHERE host_status=3 AND host.disabled=''");
if (sizeof($hosts)) {
foreach ($hosts as $h) {
debug("Processing Host '" . $h["description"] . "[" . $h["host_id"] . "]'");
if ($host_users_gt) {
debug("Processing Users");
mikrotik_gt_graph($h["host_id"], $host_users_gt);
} else {
debug("Users Graph Template Not Set");
}
if ($host_users_gt) {
debug("Processing Processes");
mikrotik_gt_graph($h["host_id"], $host_procs_gt);
} else {
debug("Processes Graph Template Not Set");
}
if ($host_disk_gt) {
debug("Processing Disk");
mikrotik_gt_graph($h["host_id"], $host_disk_gt);
} else {
debug("Disk Graph Template Not Set");
}
if ($host_mem_gt) {
debug("Processing Memory");
mikrotik_gt_graph($h["host_id"], $host_mem_gt);
} else {
debug("Memory Graph Template Not Set");
}
if ($host_cpu_gt) {
debug("Processing CPU");
mikrotik_gt_graph($h["host_id"], $host_cpu_gt);
} else {
debug("CPU Graph Template Not Set");
}
if ($host_arp_gt) {
debug("Processing ARP");
mikrotik_gt_graph($h["host_id"], $host_arp_gt);
} else {
debug("ARP Graph Template Not Set");
}
if ($host_rts_gt) {
debug("Processing Routes");
mikrotik_gt_graph($h["host_id"], $host_rts_gt);
} else {
debug("Routes Graph Template Not Set");
}
if ($host_ppp_gt) {
debug("Processing PPP Active");
mikrotik_gt_graph($h["host_id"], $host_ppp_gt);
} else {
debug("PPP Active Graph Template Not Set");
}
if ($host_upt_gt) {
debug("Processing Uptime");
mikrotik_gt_graph($h["host_id"], $host_upt_gt);
} else {
debug("Uptime Graph Template Not Set");
}
debug("Processing Users");
if ($host_users_dq) {
add_host_dq_graphs($h["host_id"], $host_users_dq);
}
debug("Processing CPU");
if ($host_cpu_dq) {
add_host_dq_graphs($h["host_id"], $host_cpu_dq);
}
}
} else {
debug("No Hosts Found");
}
}
