public function get_fra_reclaimable() { $fra_reclaimable = 0; foreach ($this->instances as $instance) { $fra_reclaimable = parameter_actions::get_parameter_by_id(9004, $instance->db_id); $fra_reclaimable = $fra_reclaimable + $fra_reclaimable->current_value; } return round($fra_reclaimable / 1024 / 1024 / 1024, 0); }
session_start(); if ($_SESSION['login'] != true) { header("Location: login.php"); exit; } include_once "../classes/class_parameter.php"; include_once "../classes/class_parameter_actions.php"; include_once "../classes/class_instance.php"; include_once "../classes/class_instance_actions.php"; $instances_arr = instance_actions::get_instance_by_server($_POST['hostname']); foreach ($instances_arr as $instance) { $fra_space_obj = parameter_actions::get_parameter_by_id(1089, $instance->db_id); $fra_data[$instance->db_id]['fra_space'] = $fra_space_obj->get_current_value(); $fra_used_space_obj = parameter_actions::get_parameter_by_id(9003, $instance->db_id); $fra_data[$instance->db_id]['used_fra_space'] = $fra_used_space_obj->get_current_value(); $fra_reclaimable_space_obj = parameter_actions::get_parameter_by_id(9004, $instance->db_id); $fra_data[$instance->db_id]['reclaimable_fra_space'] = $fra_reclaimable_space_obj->get_current_value(); $fra_data[$instance->db_id]['used_fra_percentage'] = round($fra_used_space_obj->current_value / $fra_space_obj->current_value * 100, 0); $fra_data[$instance->db_id]['reclaimable_fra_percentage'] = round(($fra_used_space_obj->current_value - $fra_reclaimable_space_obj->current_value) / $fra_space_obj->current_value * 100, 0); } ?> <script> <?php foreach ($instances_arr as $instance) { ?> $(function() { var instance_fra_usage = <?php echo $fra_data[$instance->db_id]['used_fra_percentage']; ?> ; var instance_fra_reclaimable = <?php
<?php error_reporting(E_ALL); ini_set('display_errors', '1'); session_start(); if ($_SESSION['login'] != true) { header("Location: login.php"); exit; } include_once "../classes/class_parameter_actions.php"; include_once "../classes/class_parameter.php"; $parameter_obj = parameter_actions::get_parameter_by_id($_POST['parameter_id'], $_POST['instance_id']); ?> <div id="progress" class="progress"> <?php if ($parameter_obj->type != 2) { ?> <table> <thead> <tr> <th><span><?php echo $parameter_obj->name; ?> </span> <div class="chart_links"> <a onclick="load_parameter_chart (<?php echo $_POST['instance_id']; ?> , <?php echo $parameter_obj->parameter_id; ?>
static function send_fra_notification($server_obj, $email_address) { ############################################ # Server Overview ############################################ if ($server_obj->get_fra_used_percentage() < 70) { $fra_server_used_color = 'green'; } elseif ($server_obj->get_fra_used_percentage() < 90) { $fra_server_used_color = 'orange'; } else { $fra_server_used_color = 'red'; } $mail_text = '<h2>Server Overview</h2> <table> <tr> <td style="border: 1px dotted; padding: 5px; width: 200px;"><b>Hostname</b></td> <td style="border: 1px dotted; padding: 5px; width: 300px;">' . $server_obj->hostname . '</td> </tr> <tr> <td style="border: 1px dotted; padding: 5px; width: 200px;"><b>FRA Space (u30)</b></td> <td style="border: 1px dotted; padding: 5px; width: 300px;">' . $server_obj->get_fra_space() . 'GB</td> </tr> <tr> <td style="border: 1px dotted; padding: 5px; width: 200px;"><b>Assigned FRA Space</b></td> <td style="border: 1px dotted; padding: 5px; width: 300px; background: red; color: #fff;">' . $server_obj->get_fra_assigned() . 'GB (' . round($server_obj->get_fra_assigned() / $server_obj->get_fra_space() * 100, 0) . '% assigned)</td> </tr> <tr> <td style="border: 1px dotted; padding: 5px; width: 200px;"><b>FRA Space used</b></td> <td style="border: 1px dotted; padding: 5px; width: 300px; background: ' . $fra_server_used_color . '; color: #fff;">' . $server_obj->get_fra_used_space() . 'GB</td> </tr> </table> '; ############################################ # Database Overview ############################################ foreach ($server_obj->instances as $instance) { $fra_space_obj = parameter_actions::get_parameter_by_id(1089, $instance->db_id); $fra_data[$instance->db_id]['fra_space'] = $fra_space_obj->get_current_value(); $fra_used_space_obj = parameter_actions::get_parameter_by_id(9003, $instance->db_id); $fra_data[$instance->db_id]['used_fra_space'] = $fra_used_space_obj->get_current_value(); $fra_reclaimable_space_obj = parameter_actions::get_parameter_by_id(9004, $instance->db_id); $fra_data[$instance->db_id]['reclaimable_fra_space'] = $fra_reclaimable_space_obj->get_current_value(); $fra_data[$instance->db_id]['used_fra_percentage'] = round($fra_used_space_obj->current_value / $fra_space_obj->current_value * 100, 0); $fra_data[$instance->db_id]['reclaimable_fra_percentage'] = round(($fra_used_space_obj->current_value - $fra_reclaimable_space_obj->current_value) / $fra_space_obj->current_value * 100, 0); } $mail_text = $mail_text . '<h2>Databases</h2><table>'; foreach ($server_obj->instances as $instance) { if ($fra_data[$instance->db_id]['used_fra_percentage'] < 70) { $fra_db_used_color = 'green'; } elseif ($fra_data[$instance->db_id]['used_fra_percentage'] < 90) { $fra_db_used_color = 'orange'; } else { $fra_db_used_color = 'red'; } $mail_text = $mail_text . ' <tr> <td style="border: 1px dotted; padding: 5px; width: 75px;"><b>' . $instance->sid . '</b></td> <td style="border: 1px dotted; padding: 5px; width: 447px; background: ' . $fra_db_used_color . '; color: #fff;">' . $fra_data[$instance->db_id]['used_fra_space'] . ' ' . '/ ' . $fra_data[$instance->db_id]['fra_space'] . ' used (' . $fra_data[$instance->db_id]['reclaimable_fra_space'] . ' reclaimable)</td> </tr> '; } $mail_text = $mail_text . '</table>'; ############################################ # Send E-Mail ############################################ $subject = '[FRA-Monitor Alert] FRA over assigned on ' . $server_obj->get_hostname() . ' noapplix'; $headers = "From: FRA-Monitor\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; mail($email_address, $subject, $mail_text, $headers); echo $mail_text . '<br>'; echo "Mail has been sent!<br>"; }