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>";
}
