function templates()
{
global $colors, $thold_actions, $item_rows;
template_request_validation();
?>
<script type="text/javascript">
<!--
function applyTHoldFilterChange(objForm) {
strURL = '?rows=' + objForm.rows.value;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
function importTemplate() {
strURL = '?action=import';
document.location = strURL;
}
-->
</script>
<?php
html_start_box('<strong>Threshold Templates</strong>', '100%', $colors['header'], '3', 'center', 'thold_templates.php?action=add');
?>
<tr bgcolor='#<?php
print $colors["panel"];
?>
' class='noprint'>
<td class='noprint'>
<form name='listthold' action='thold_templates.php'>
<table cellpadding='0' cellspacing='0'>
<tr class='noprint'>
<td width='20'>
Search:
</td>
<td width='144'>
<input type='text' name='filter' size='20' value='<?php
print $_REQUEST["filter"];
?>
'>
</td>
<td width='1'>
Rows:
</td>
<td width='1'>
<select name='rows' onChange='applyTHoldFilterChange(document.listthold)'>
<option value='-1'<?php
if ($_REQUEST["rows"] == "-1") {
?>
selected<?php
}
?>
>Default</option>
<?php
if (sizeof($item_rows)) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'";
if ($_REQUEST["rows"] == $key) {
print " selected";
}
print ">" . $value . "</option>\n";
}
}
?>
</select>
</td>
<td width='1'>
<input type="submit" value="Go">
</td>
<td width='1'>
<input id="clear" name="clear" type="submit" value="Clear">
</td>
<td width='1'>
<input id="import" name="import" type="button" value="Import" onClick="importTemplate()">
</td>
</tr>
</table>
</form>
</td>
</tr>
<?php
html_end_box();
$sql_where = '';
$limit = ' LIMIT ' . $_REQUEST["rows"] * ($_REQUEST['page'] - 1) . "," . $_REQUEST["rows"];
$order = "ORDER BY " . $_REQUEST['sort_column'] . " " . $_REQUEST['sort_direction'];
if (strlen($_REQUEST["filter"])) {
$sql_where .= (strlen($sql_where) ? " AND" : "WHERE") . " thold_template.name LIKE '%%" . $_REQUEST["filter"] . "%%'";
}
define('MAX_DISPLAY_PAGES', 21);
$total_rows = db_fetch_cell("SELECT count(*) FROM thold_template");
$template_list = db_fetch_assoc("SELECT * FROM thold_template {$sql_where} {$order} {$limit}");
if ($total_rows) {
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $_REQUEST["rows"], $total_rows, "thold_templates.php?tab=thold");
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\r\n\t\t\t\t<td colspan='10'>\r\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\t<strong><< ";
if ($_REQUEST["page"] > 1) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("thold_templates.php?filter=" . $_REQUEST["filter"] . "&page=" . ($_REQUEST["page"] - 1)) . "'>";
}
$nav .= "Previous";
if ($_REQUEST["page"] > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\tShowing Rows " . ($_REQUEST["rows"] * ($_REQUEST["page"] - 1) + 1) . " to " . ($total_rows < read_config_option("num_rows_device") || $total_rows < $_REQUEST["rows"] * $_REQUEST["page"] ? $total_rows : $_REQUEST["rows"] * $_REQUEST["page"]) . " of {$total_rows} [{$url_page_select}]\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\t<strong>";
if ($_REQUEST["page"] * $_REQUEST["rows"] < $total_rows) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("thold_templates.php?filter=" . $_REQUEST["filter"] . "&page=" . ($_REQUEST["page"] + 1)) . "'>";
}
$nav .= "Next";
if ($_REQUEST["page"] * $_REQUEST["rows"] < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\n";
} else {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\r\n\t\t\t\t<td colspan='10'>\r\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\tNo Rows Found\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\n";
}
/* print checkbox form for validation */
print "<form name='chk' method='post' action='thold_templates.php'>\n";
html_start_box('', '100%', $colors['header'], '3', 'center', '');
print $nav;
html_header_sort_checkbox(array('name' => array('Name', 'ASC'), 'data_template_name' => array('Data Template', 'ASC'), 'data_source_name' => array('DS Name', 'ASC'), 'thold_type' => array('Type', 'ASC'), 'nosort1' => array('High/Up', ''), 'nosort2' => array('Low/Down', ''), 'nosort3' => array('Trigger', ''), 'nosort4' => array('Duration', ''), 'nosort5' => array('Repeat', '')), $_REQUEST['sort_column'], $_REQUEST['sort_direction'], false);
$i = 0;
$types = array('High/Low', 'Baseline Deviation', 'Time Based');
if (sizeof($template_list)) {
foreach ($template_list as $template) {
switch ($template['thold_type']) {
case 0:
# hi/lo
$value_hi = thold_format_number($template['thold_hi']);
$value_lo = thold_format_number($template['thold_low']);
$value_trig = $template['thold_fail_trigger'];
$value_duration = '';
$value_warning_hi = thold_format_number($template['thold_warning_hi']);
$value_warning_lo = thold_format_number($template['thold_warning_low']);
$value_warning_trig = $template['thold_warning_fail_trigger'];
$value_warning_duration = '';
break;
case 1:
# baseline
$value_hi = $template['bl_pct_up'] . (strlen($template['bl_pct_up']) ? '%' : '-');
$value_lo = $template['bl_pct_down'] . (strlen($template['bl_pct_down']) ? '%' : '-');
$value_trig = $template['bl_fail_trigger'];
$step = db_fetch_cell("SELECT rrd_step \r\n\t\t\t\t\t\tFROM data_template_data \r\n\t\t\t\t\t\tWHERE data_template_id=" . $template['data_template_id'] . "\r\n\t\t\t\t\t\tLIMIT 1");
$value_duration = $template['bl_ref_time_range'] / $step;
break;
case 2:
#time
$value_hi = thold_format_number($template['time_hi']);
$value_lo = thold_format_number($template['time_low']);
$value_trig = $template['time_fail_trigger'];
$value_duration = $template['time_fail_length'];
break;
}
form_alternate_row_color($colors["alternate"], $colors["light"], $i, 'line' . $template["id"]);
$i++;
form_selectable_cell('<a class="linkEditMain" href="' . htmlspecialchars('thold_templates.php?action=edit&id=' . $template['id']) . '">' . ($template['name'] == '' ? $template['data_template_name'] . ' [' . $template['data_source_name'] . ']' : $template['name']) . '</a>', $template["id"]);
form_selectable_cell($template['data_template_name'], $template["id"]);
form_selectable_cell($template['data_source_name'], $template["id"]);
form_selectable_cell($types[$template['thold_type']], $template["id"]);
form_selectable_cell($value_hi, $template["id"]);
form_selectable_cell($value_lo, $template["id"]);
$trigger = plugin_thold_duration_convert($template['data_template_id'], $value_trig, 'alert', 'data_template_id');
form_selectable_cell(strlen($trigger) ? "<i>" . $trigger . "</i>" : "-", $template["id"]);
$duration = plugin_thold_duration_convert($template['data_template_id'], $value_duration, 'time', 'data_template_id');
form_selectable_cell(strlen($duration) ? $duration : "-", $template["id"]);
form_selectable_cell(plugin_thold_duration_convert($template['data_template_id'], $template['repeat_alert'], 'repeat', 'data_template_id'), $template['id']);
form_checkbox_cell($template['data_template_name'], $template["id"]);
form_end_row();
}
print $nav;
} else {
print "<tr><td><em>No Threshold Templates</em></td></tr>\n";
}
html_end_box(false);
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($thold_actions);
print "</form>\n";
}
function tholds()
{
global $config, $colors, $thold_bgcolors, $device_actions, $item_rows;
/* ================= input validation ================= */
input_validate_input_number(get_request_var_request("data_template_id"));
input_validate_input_number(get_request_var_request("host_id"));
input_validate_input_number(get_request_var_request("page"));
input_validate_input_number(get_request_var_request("triggered"));
input_validate_input_number(get_request_var_request("rows"));
/* ==================================================== */
/* clean up search string */
if (isset($_REQUEST["filter"])) {
$_REQUEST["filter"] = sanitize_search_string(get_request_var("filter"));
}
/* clean up sort_column */
if (isset($_REQUEST["sort_column"])) {
$_REQUEST["sort_column"] = sanitize_search_string(get_request_var("sort_column"));
}
/* clean up search string */
if (isset($_REQUEST["sort_direction"])) {
$_REQUEST["sort_direction"] = sanitize_search_string(get_request_var("sort_direction"));
}
/* if the user pushed the 'clear' button */
if (isset($_REQUEST["clear"])) {
kill_session_var("sess_thold_current_page");
kill_session_var("sess_thold_filter");
kill_session_var("sess_thold_data_template_id");
kill_session_var("sess_thold_host_id");
kill_session_var("sess_thold_rows");
kill_session_var("sess_thold_triggered");
kill_session_var("sess_thold_sort_column");
kill_session_var("sess_thold_sort_direction");
unset($_REQUEST["page"]);
unset($_REQUEST["filter"]);
unset($_REQUEST["data_template_id"]);
unset($_REQUEST["host_id"]);
unset($_REQUEST["rows"]);
unset($_REQUEST["triggered"]);
unset($_REQUEST["sort_column"]);
unset($_REQUEST["sort_direction"]);
} else {
/* if any of the settings changed, reset the page number */
$changed = 0;
$changed += thold_request_check_changed('filter', 'sess_thold_filter');
$changed += thold_request_check_changed('data_template_id', 'sess_thold_data_template_id');
$changed += thold_request_check_changed('host_id', 'sess_thold_host_id');
$changed += thold_request_check_changed('rows', 'sess_thold_rows');
$changed += thold_request_check_changed('triggered', 'sess_thold_triggered');
$changed += thold_request_check_changed('sort_column', 'sess_thold_sort_column');
$changed += thold_request_check_changed('sort_direction', 'sess_thold_sort_direction');
if ($changed) {
$_REQUEST['page'] = '1';
}
}
/* remember these search fields in session vars so we don't have to keep passing them around */
load_current_session_value("page", "sess_thold_current_page", "1");
load_current_session_value("filter", "sess_thold_filter", "");
load_current_session_value("triggered", "sess_thold_triggered", read_config_option("thold_filter_default"));
load_current_session_value("data_template_id", "sess_thold_data_template_id", "-1");
load_current_session_value("host_id", "sess_thold_host_id", "-1");
load_current_session_value("rows", "sess_thold_rows", read_config_option("alert_num_rows"));
load_current_session_value("sort_column", "sess_thold_sort_column", "thold_alert");
load_current_session_value("sort_direction", "sess_thold_sort_direction", "DESC");
/* if the number of rows is -1, set it to the default */
if ($_REQUEST["rows"] == -1 || !isset($_REQUEST["rows"])) {
$_REQUEST["rows"] = read_config_option("alert_num_rows");
if ($_REQUEST["rows"] < 2) {
$_REQUEST["rows"] = 30;
}
}
?>
<script type="text/javascript">
<!--
function applyTHoldFilterChange(objForm) {
strURL = '?tab=thold&triggered=' + objForm.triggered.value;
strURL = strURL + '&data_template_id=' + objForm.data_template_id.value;
strURL = strURL + '&host_id=' + objForm.host_id.value;
strURL = strURL + '&rows=' + objForm.rows.value;
strURL = strURL + '&filter=' + objForm.filter.value;
document.location = strURL;
}
-->
</script>
<?php
html_start_box("<strong>Threshold Status</strong>", "100%", $colors["header"], "3", "center", "");
form_thold_filter();
html_end_box();
/* build the SQL query and WHERE clause */
if ($_REQUEST['sort_column'] == 'lastread') {
$sort = $_REQUEST['sort_column'] . "/1";
} else {
$sort = $_REQUEST['sort_column'];
}
$limit = ' LIMIT ' . $_REQUEST["rows"] * ($_REQUEST['page'] - 1) . "," . $_REQUEST["rows"];
$sql_where = '';
/* triggered filter */
if ($_REQUEST['triggered'] == '-1') {
/* return all rows */
} else {
if ($_REQUEST['triggered'] == '0') {
$sql_where = "WHERE thold_data.thold_enabled='off'";
}
/*disabled*/
if ($_REQUEST['triggered'] == '2') {
$sql_where = "WHERE thold_data.thold_enabled='on'";
}
/* enabled */
if ($_REQUEST['triggered'] == '1') {
$sql_where = "WHERE (thold_data.thold_alert!=0 OR thold_data.bl_alert>0)";
}
/* breached */
if ($_REQUEST['triggered'] == '3') {
$sql_where = "WHERE ((thold_data.thold_alert!=0 AND thold_data.thold_fail_count >= thold_data.thold_fail_trigger) OR (thold_data.bl_alert>0 AND thold_data.bl_fail_count >= thold_data.bl_fail_trigger))";
}
/* triggered */
}
if (strlen($_REQUEST["filter"])) {
$sql_where .= (strlen($sql_where) ? " AND" : "WHERE") . " thold_data.name LIKE '%%" . $_REQUEST["filter"] . "%%'";
}
/* data template id filter */
if ($_REQUEST['data_template_id'] != '-1') {
$sql_where .= (strlen($sql_where) ? " AND" : "WHERE") . " thold_data.data_template=" . $_REQUEST['data_template_id'];
}
/* host id filter */
if ($_REQUEST['host_id'] != '-1') {
$sql_where .= (strlen($sql_where) ? " AND" : "WHERE") . " thold_data.host_id=" . $_REQUEST['host_id'];
}
/* thold permissions */
$current_user = db_fetch_row('SELECT * FROM user_auth WHERE id=' . $_SESSION['sess_user_id']);
$sql_where .= (strlen($sql_where) ? " AND " : "WHERE ") . get_graph_permissions_sql($current_user['policy_graphs'], $current_user['policy_hosts'], $current_user['policy_graph_templates']);
$total_rows_sql = "SELECT * FROM thold_data\r\n\t\tLEFT JOIN user_auth_perms\r\n\t\tON ((thold_data.graph_id=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=1\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ")\r\n\t\tOR (thold_data.host_id=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=3\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ")\r\n\t\tOR (thold_data.graph_template=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=4\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . "))\r\n\t\t{$sql_where}";
$total_rows = sizeof(db_fetch_assoc($total_rows_sql));
/* get the thold records */
$sql = "SELECT * FROM thold_data\r\n\t\tLEFT JOIN user_auth_perms\r\n\t\tON ((thold_data.graph_id=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=1\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ")\r\n\t\tOR (thold_data.host_id=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=3\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ")\r\n\t\tOR (thold_data.graph_template=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=4\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . "))\r\n\t\t{$sql_where}\r\n\t\tORDER BY {$sort} " . $_REQUEST['sort_direction'] . $limit;
$result = db_fetch_assoc($sql);
html_start_box('', '100%', $colors['header'], '4', 'center', '');
if ($total_rows) {
/* generate page list */
$url_page_select = get_page_list($_REQUEST["page"], MAX_DISPLAY_PAGES, $_REQUEST["rows"], $total_rows, "thold_graph.php?tab=thold");
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\r\n\t\t\t\t<td colspan='13'>\r\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\t<strong><< ";
if ($_REQUEST["page"] > 1) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("thold_graph.php?filter=" . $_REQUEST["filter"] . "&page=" . ($_REQUEST["page"] - 1)) . "'>";
}
$nav .= "Previous";
if ($_REQUEST["page"] > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\tShowing Rows " . ($_REQUEST["rows"] * ($_REQUEST["page"] - 1) + 1) . " to " . ($total_rows < read_config_option("num_rows_device") || $total_rows < $_REQUEST["rows"] * $_REQUEST["page"] ? $total_rows : $_REQUEST["rows"] * $_REQUEST["page"]) . " of {$total_rows} [{$url_page_select}]\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\t<strong>";
if ($_REQUEST["page"] * $_REQUEST["rows"] < $total_rows) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("thold_graph.php?filter=" . $_REQUEST["filter"] . "&page=" . ($_REQUEST["page"] + 1)) . "'>";
}
$nav .= "Next";
if ($_REQUEST["page"] * $_REQUEST["rows"] < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\n";
} else {
$nav = "<tr bgcolor='#" . $colors["header"] . "'>\r\n\t\t\t\t<td colspan='13'>\r\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\tNo Rows Found\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\n";
}
print $nav;
$display_text = array('nosort' => array('Actions', ''), 'name' => array('Name', 'ASC'), 'id' => array('ID', 'ASC'), 'thold_type' => array('Type', 'ASC'), 'nosort2' => array('Trigger', 'ASC'), 'nosort3' => array('Duration', 'ASC'), 'repeat_alert' => array('Repeat', 'ASC'), 'nosort4' => array('Warn Hi/Lo', 'ASC'), 'nosort5' => array('Alert Hi/Lo', 'ASC'), 'nosort6' => array('BL Hi/Lo', 'ASC'), 'lastread' => array('Current', 'ASC'), 'thold_alert' => array('Triggered', 'ASC'), 'thold_enabled' => array('Enabled', 'ASC'));
html_header_sort($display_text, $_REQUEST['sort_column'], $_REQUEST['sort_direction']);
$timearray = array(1 => '5 Minutes', 2 => '10 Minutes', 3 => '15 Minutes', 4 => '20 Minutes', 6 => '30 Minutes', 8 => '45 Minutes', 12 => 'Hour', 24 => '2 Hours', 36 => '3 Hours', 48 => '4 Hours', 72 => '6 Hours', 96 => '8 Hours', 144 => '12 Hours', 288 => '1 Day', 576 => '2 Days', 2016 => '1 Week', 4032 => '2 Weeks', 8640 => '1 Month');
$c = 0;
$i = 0;
$types = array('High/Low', 'Baseline Deviation', 'Time Based');
if (count($result)) {
foreach ($result as $row) {
$c++;
$alertstat = 'no';
$bgcolor = 'green';
if ($row['thold_type'] == 0) {
if ($row['thold_alert'] != 0) {
$alertstat = 'yes';
if ($row['thold_fail_count'] >= $row['thold_fail_trigger']) {
$bgcolor = 'red';
} elseif ($row['thold_warning_fail_count'] >= $row['thold_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} elseif ($row['thold_type'] == 2) {
if ($row['thold_alert'] != 0) {
$alertstat = 'yes';
if ($row['thold_fail_count'] >= $row['time_fail_trigger']) {
$bgcolor = 'red';
} elseif ($row['thold_warning_fail_count'] >= $row['time_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} else {
if ($row['bl_alert'] == 1) {
$alertstat = 'baseline-LOW';
$bgcolor = $row['bl_fail_count'] >= $row['bl_fail_trigger'] ? 'orange' : 'yellow';
} elseif ($row['bl_alert'] == 2) {
$alertstat = 'baseline-HIGH';
$bgcolor = $row['bl_fail_count'] >= $row['bl_fail_trigger'] ? 'orange' : 'yellow';
}
}
if ($row['thold_enabled'] == 'off') {
form_alternate_row_color($thold_bgcolors['grey'], $thold_bgcolors['grey'], $i, 'line' . $row["id"]);
$i++;
} else {
form_alternate_row_color($thold_bgcolors[$bgcolor], $thold_bgcolors[$bgcolor], $i, 'line' . $row["id"]);
$i++;
}
print "<td width='1%' style='white-space:nowrap;' nowrap>";
if (api_user_realm_auth('thold_add.php')) {
print '<a href="' . htmlspecialchars($config['url_path'] . 'plugins/thold/thold.php?rra=' . $row["rra_id"] . '&view_rrd=' . $row["data_id"]) . '"><img src="' . $config['url_path'] . 'plugins/thold/images/edit_object.png" border="0" alt="" title="Edit Threshold"></a>';
}
if ($row["thold_enabled"] == 'on') {
print '<a href="' . htmlspecialchars($config['url_path'] . 'plugins/thold/thold.php?id=' . $row["id"] . '&action=disable') . '"><img src="' . $config['url_path'] . 'plugins/thold/images/disable_thold.png" border="0" alt="" title="Disable Threshold"></a>';
} else {
print '<a href="' . htmlspecialchars($config['url_path'] . 'plugins/thold/thold.php?id=' . $row["id"] . '&action=enable') . '"><img src="' . $config['url_path'] . 'plugins/thold/images/enable_thold.png" border="0" alt="" title="Enable Threshold"></a>';
}
print "<a href='" . htmlspecialchars($config['url_path'] . "graph.php?local_graph_id=" . $row['graph_id'] . "&rra_id=all") . "'><img src='" . $config['url_path'] . "plugins/thold/images/view_graphs.gif' border='0' alt='' title='View Graph'></a>";
print "<a href='" . htmlspecialchars($config['url_path'] . "plugins/thold/thold_graph.php?tab=log&threshold_id=" . $row["id"] . "&status=-1") . "'><img src='" . $config['url_path'] . "plugins/thold/images/view_log.gif' border='0' alt='' title='View Threshold History'></a>";
print "</td>";
print "<td width='28%'>" . ($row['name'] != '' ? $row['name'] : 'No name set') . "</td>";
print "<td width='10'>" . $row["id"] . "</td>";
print "<td nowrap style='white-space:nowrap;' width='120'>" . $types[$row['thold_type']] . "</td>";
switch ($row['thold_type']) {
case 0:
print "<td nowrap style='white-space:nowrap;' width='80'><i>" . plugin_thold_duration_convert($row['rra_id'], $row['thold_fail_trigger'], 'alert') . "</i></td>";
print "<td width='80'>N/A</td>";
break;
case 1:
print "<td nowrap style='white-space:nowrap;' width='80'><i>" . plugin_thold_duration_convert($row['rra_id'], $row['bl_fail_trigger'], 'alert') . "</i></td>";
print "<td nowrap style='white-space:nowrap;' width='80'>" . $timearray[$row['bl_ref_time_range'] / 300] . "</td>";
break;
case 2:
print "<td nowrap style='white-space:nowrap;' width='80'><i>" . $row['time_fail_trigger'] . " Triggers</i></td>";
print "<td nowrap style='white-space:nowrap;' width='80'>" . plugin_thold_duration_convert($row['rra_id'], $row['time_fail_length'], 'time') . "</td>";
break;
default:
print "<td width='80'>N/A</td>";
print "<td width='80'>N/A</td>";
}
print "<td nowrap style='white-space:nowrap;' width='80'>" . ($row['repeat_alert'] == '' ? '' : plugin_thold_duration_convert($row['rra_id'], $row['repeat_alert'], 'repeat')) . "</td>";
print "<td nowrap style='white-space:nowrap;' width='80'>" . ($row['thold_type'] == 1 ? "N/A" : ($row['thold_type'] == 2 ? thold_format_number($row['time_warning_hi']) . '/' . thold_format_number($row['time_warning_low']) : thold_format_number($row['thold_warning_hi']) . '/' . thold_format_number($row['thold_warning_low']))) . "</td>";
print "<td width='80'>" . ($row['thold_type'] == 1 ? "N/A" : ($row['thold_type'] == 2 ? thold_format_number($row['time_hi']) . '/' . thold_format_number($row['time_low']) : thold_format_number($row['thold_hi']) . '/' . thold_format_number($row['thold_low']))) . "</td>";
print "<td width='80'>" . ($row['thold_type'] == 1 ? $row['bl_pct_up'] . (strlen($row['bl_pct_up']) ? '%' : '-') . '/' . $row['bl_pct_down'] . (strlen($row['bl_pct_down']) ? '%' : '-') : 'N/A') . "</td>";
print "<td width='80'>" . thold_format_number($row['lastread']) . "</td>";
print "<td width='80'>" . ($row['thold_alert'] ? "yes" : "no") . "</td>";
if ($row['thold_enabled'] == 'off') {
print "<td width='40'><b>Disabled</b></td>";
} else {
print "<td width='40'>Enabled</td>";
}
form_end_row();
}
} else {
form_alternate_row_color($colors['alternate'], $colors['light'], 0);
print '<td colspan=12><center>No Thresholds</center></td></tr>';
}
print $nav;
html_end_box(false);
thold_legend();
//thold_display_rusage();
}
function tholds()
{
global $config, $device_actions, $item_rows, $thold_classes, $thold_states;
/* ================= input validation and session storage ================= */
$filters = array('rows' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'page' => array('filter' => FILTER_VALIDATE_INT, 'default' => '1'), 'filter' => array('filter' => FILTER_CALLBACK, 'pageset' => true, 'default' => '', 'options' => array('options' => 'sanitize_search_string')), 'sort_column' => array('filter' => FILTER_CALLBACK, 'default' => 'name', 'options' => array('options' => 'sanitize_search_string')), 'sort_direction' => array('filter' => FILTER_CALLBACK, 'default' => 'ASC', 'options' => array('options' => 'sanitize_search_string')), 'data_template_id' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'host_id' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'), 'status' => array('filter' => FILTER_VALIDATE_INT, 'pageset' => true, 'default' => '-1'));
validate_store_request_vars($filters, 'sess_thold');
/* ================= input validation ================= */
/* if the number of rows is -1, set it to the default */
if (get_request_var('rows') == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = get_request_var('rows');
}
html_start_box(__('Threshold Status'), '100%', '', '3', 'center', '');
form_thold_filter();
html_end_box();
/* build the SQL query and WHERE clause */
if (get_request_var('sort_column') == 'lastread') {
$sort = get_request_var('sort_column') . "/1";
} else {
$sort = get_request_var('sort_column');
}
$limit = ' LIMIT ' . $rows * (get_request_var('page') - 1) . ',' . $rows;
$sql_where = '';
/* status filter */
if (get_request_var('status') == '-1') {
/* return all rows */
} else {
if (get_request_var('status') == '0') {
$sql_where = "(td.thold_enabled='off'";
}
/*disabled*/
if (get_request_var('status') == '2') {
$sql_where = "(td.thold_enabled='on'";
}
/* enabled */
if (get_request_var('status') == '1') {
$sql_where = "((td.thold_alert!=0 OR td.bl_alert>0)";
}
/* breached */
if (get_request_var('status') == '3') {
$sql_where = "(((td.thold_alert!=0 AND td.thold_fail_count >= td.thold_fail_trigger) OR (td.bl_alert>0 AND td.bl_fail_count >= td.bl_fail_trigger))";
}
/* status */
}
if (strlen(get_request_var('filter'))) {
$sql_where .= (strlen($sql_where) ? ' AND' : '(') . " td.name LIKE '%" . get_request_var('filter') . "%'";
}
/* data template id filter */
if (get_request_var('data_template_id') != '-1') {
$sql_where .= (strlen($sql_where) ? ' AND' : '(') . ' td.data_template_id=' . get_request_var('data_template_id');
}
/* host id filter */
if (get_request_var('host_id') != '-1') {
$sql_where .= (strlen($sql_where) ? ' AND' : '(') . ' td.host_id=' . get_request_var('host_id');
}
if ($sql_where != '') {
$sql_where .= ')';
}
$tholds = get_allowed_thresholds($sql_where, $sort . ' ' . get_request_var('sort_direction'), $rows * (get_request_var('page') - 1) . ", {$rows}", $total_rows);
$nav = html_nav_bar('thold_graph.php?action=thold', MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 13, 'Thresholds', 'page', 'main');
print $nav;
html_start_box('', '100%', '', '4', 'center', '');
$display_text = array('nosort' => array('display' => __('Actions'), 'sort' => '', 'align' => 'left'), 'name' => array('display' => __('Name'), 'sort' => 'ASC', 'align' => 'left'), 'id' => array('display' => __('ID'), 'sort' => 'ASC', 'align' => 'right'), 'thold_type' => array('display' => __('Type'), 'sort' => 'ASC', 'align' => 'left'), 'lastread' => array('display' => __('Current'), 'sort' => 'ASC', 'align' => 'right'), 'nosort4' => array('display' => __('Warn Hi/Lo'), 'sort' => 'ASC', 'align' => 'right'), 'nosort5' => array('display' => __('Alert Hi/Lo'), 'sort' => 'ASC', 'align' => 'right'), 'nosort6' => array('display' => __('BL Hi/Lo'), 'sort' => 'ASC', 'align' => 'right'), 'nosort2' => array('display' => __('Trigger'), 'sort' => 'ASC', 'align' => 'right'), 'nosort3' => array('display' => __('Duration'), 'sort' => 'ASC', 'align' => 'right'), 'repeat_alert' => array('display' => __('Repeat'), 'sort' => 'ASC', 'align' => 'right'), 'thold_alert' => array('display' => __('Triggered'), 'sort' => 'ASC', 'align' => 'right'));
html_header_sort($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false, 'thold_graph.php?action=thold');
$step = read_config_option('poller_interval');
include $config['base_path'] . '/plugins/thold/includes/arrays.php';
$c = 0;
$i = 0;
if (sizeof($tholds)) {
foreach ($tholds as $row) {
$c++;
$alertstat = 'No';
$bgcolor = 'green';
if ($row['thold_type'] == 0) {
if ($row['thold_alert'] != 0) {
$alertstat = __('Yes');
if ($row['thold_fail_count'] >= $row['thold_fail_trigger']) {
$bgcolor = 'red';
} elseif ($row['thold_warning_fail_count'] >= $row['thold_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} elseif ($row['thold_type'] == 2) {
if ($row['thold_alert'] != 0) {
$alertstat = 'Yes';
if ($row['thold_fail_count'] >= $row['time_fail_trigger']) {
$bgcolor = 'red';
} elseif ($row['thold_warning_fail_count'] >= $row['time_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} else {
if ($row['bl_alert'] == 1) {
$alertstat = __('Baseline-LOW');
$bgcolor = $row['bl_fail_count'] >= $row['bl_fail_trigger'] ? 'orange' : 'yellow';
} elseif ($row['bl_alert'] == 2) {
$alertstat = __('Baseline-HIGH');
$bgcolor = $row['bl_fail_count'] >= $row['bl_fail_trigger'] ? 'orange' : 'yellow';
}
}
if ($row['thold_enabled'] == 'off') {
print "<tr class='selectable " . $thold_states['grey']['class'] . "' id='line" . $row['id'] . "'>\n";
} else {
print "<tr class='selectable " . $thold_states[$bgcolor]['class'] . "' id='line" . $row['id'] . "'>\n";
}
print "<td width='1%' style='white-space:nowrap;'>";
if (api_user_realm_auth('thold.php')) {
print '<a href="' . htmlspecialchars($config['url_path'] . 'plugins/thold/thold.php?action=edit&id=' . $row['id']) . '"><img src="' . $config['url_path'] . 'plugins/thold/images/edit_object.png" border="0" alt="" title="' . __('Edit Threshold') . '"></a>';
}
if ($row['thold_enabled'] == 'on') {
print '<a class="hyperLink" href="' . htmlspecialchars($config['url_path'] . 'plugins/thold/thold_graph.php?action=disable&id=' . $row['id']) . '"><img src="' . $config['url_path'] . 'plugins/thold/images/disable_thold.png" border="0" alt="" title="' . __('Disable Threshold') . '"></a>';
} else {
print '<a class="hyperLink" href="' . htmlspecialchars($config['url_path'] . 'plugins/thold/thold_graph.php?action=enable&id=' . $row['id']) . '"><img src="' . $config['url_path'] . 'plugins/thold/images/enable_thold.png" border="0" alt="" title="' . __('Enable Threshold') . '"></a>';
}
print "<a href='" . htmlspecialchars($config['url_path'] . 'graph.php?local_graph_id=' . $row['local_graph_id'] . '&rra_id=all') . "'><img src='" . $config['url_path'] . "plugins/thold/images/view_graphs.gif' border='0' alt='' title='" . __('View Graph') . "'></a>";
print "<a class='hyperLink' href='" . htmlspecialchars($config['url_path'] . 'plugins/thold/thold_graph.php?action=log&threshold_id=' . $row['id'] . '&status=-1') . "'><img src='" . $config['url_path'] . "plugins/thold/images/view_log.gif' border='0' alt='' title='" . __('View Threshold History') . "'></a>";
print '</td>';
print "<td class='left nowrap'>" . ($row['name'] != '' ? $row['name'] : 'No name set') . '</td>';
print "<td class='right'>" . $row['id'] . '</td>';
print "<td class='left nowrap'>" . $thold_types[$row['thold_type']] . '</td>';
print "<td class='right'>" . thold_format_number($row['lastread']) . '</td>';
print "<td class='right nowrap'>" . ($row['thold_type'] == 1 ? __('N/A') : ($row['thold_type'] == 2 ? thold_format_number($row['time_warning_hi']) . '/' . thold_format_number($row['time_warning_low']) : thold_format_number($row['thold_warning_hi']) . '/' . thold_format_number($row['thold_warning_low']))) . '</td>';
print "<td class='right'>" . ($row['thold_type'] == 1 ? __('N/A') : ($row['thold_type'] == 2 ? thold_format_number($row['time_hi']) . '/' . thold_format_number($row['time_low']) : thold_format_number($row['thold_hi']) . '/' . thold_format_number($row['thold_low']))) . '</td>';
print "<td class='right'>" . ($row['thold_type'] == 1 ? $row['bl_pct_up'] . (strlen($row['bl_pct_up']) ? '%' : '-') . '/' . $row['bl_pct_down'] . (strlen($row['bl_pct_down']) ? '%' : '-') : __('N/A')) . '</td>';
switch ($row['thold_type']) {
case 0:
print "<td class='right nowrap'><i>" . plugin_thold_duration_convert($row['local_data_id'], $row['thold_fail_trigger'], 'alert') . '</i></td>';
print "<td class='right'>" . __('N/A') . "</td>";
break;
case 1:
print "<td class='right nowrap'><i>" . plugin_thold_duration_convert($row['local_data_id'], $row['bl_fail_trigger'], 'alert') . '</i></td>';
print "<td class='right nowrap'>" . $timearray[$row['bl_ref_time_range'] / 300] . '</td>';
break;
case 2:
print "<td class='right nowrap'><i>" . $row['time_fail_trigger'] . ' Triggers</i></td>';
print "<td class='right nowrap'>" . plugin_thold_duration_convert($row['local_data_id'], $row['time_fail_length'], 'time') . '</td>';
break;
default:
print "<td class='right'>" . __('N/A') . "</td>";
print "<td class='right'>" . __('N/A') . "</td>";
}
print "<td class='right nowrap'>" . ($row['repeat_alert'] == '' ? '' : plugin_thold_duration_convert($row['local_data_id'], $row['repeat_alert'], 'repeat')) . '</td>';
print "<td class='right'>" . $alertstat . '</td>';
form_end_row();
}
} else {
print '<tr class="even"><td class="center" colspan="13">' . __('No Thresholds') . '</td></tr>';
}
html_end_box(false);
if (sizeof($tholds)) {
print $nav;
}
thold_legend();
//thold_display_rusage();
}
function list_tholds()
{
global $thold_states, $config, $host_id, $timearray, $thold_types;
$thold_actions = array(1 => __('Delete'), 2 => __('Disable'), 3 => __('Enable'), 4 => __('Reapply Suggested Names'), 5 => __('Propagate Template'));
thold_request_validation();
/* if the number of rows is -1, set it to the default */
if (get_request_var('rows') == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = get_request_var('rows');
}
$statefilter = '';
if (isset_request_var('state')) {
if (get_request_var('state') == '-1') {
$statefilter = '';
} else {
if (get_request_var('state') == '0') {
$statefilter = "thold_data.thold_enabled='off'";
}
if (get_request_var('state') == '2') {
$statefilter = "thold_data.thold_enabled='on'";
}
if (get_request_var('state') == '1') {
$statefilter = '(thold_data.thold_alert!=0 OR thold_data.bl_alert>0)';
}
if (get_request_var('state') == '3') {
$statefilter = '((thold_data.thold_alert!=0 AND thold_data.thold_fail_count >= thold_data.thold_fail_trigger) OR (thold_data.bl_alert>0 AND thold_data.bl_fail_count >= thold_data.bl_fail_trigger))';
}
}
}
top_header();
$sql_where = '';
$sort = get_request_var('sort_column');
$limit = ' LIMIT ' . $rows * (get_request_var('page') - 1) . ", {$rows}";
if (!isempty_request_var('host_id') && get_request_var('host_id') != '-1') {
$sql_where .= (!strlen($sql_where) ? '(' : ' AND ') . "td.host_id = " . get_request_var('host_id');
}
if (!isempty_request_var('data_template_id') && get_request_var('data_template_id') != '-1') {
$sql_where .= (!strlen($sql_where) ? '(' : ' AND ') . "td.data_template_id = " . get_request_var('data_template_id');
}
if ($statefilter != '') {
$sql_where .= (!strlen($sql_where) ? '(' : ' AND ') . "{$statefilter}";
}
if ($sql_where != '') {
$sql_where .= ')';
}
$tholds = get_allowed_thresholds($sql_where, $sort . ' ' . get_request_var('sort_direction'), $rows * (get_request_var('page') - 1) . ", {$rows}", $total_rows);
$data_templates = db_fetch_assoc("SELECT DISTINCT data_template.id, data_template.name\n\t\tFROM data_template\n\t\tINNER JOIN thold_data \n\t\tON thold_data.data_template_id = data_template.id\n\t\tORDER BY data_template.name");
html_start_box(__('Threshold Management'), '100%', '', '3', 'center', 'thold.php?action=add');
?>
<tr class='even'>
<td>
<form id='listthold' action='thold.php' method='post'>
<table class='filterTable'>
<tr>
<td>
<?php
print __('Search');
?>
</td>
<td>
<input type='text' id='filter' size='25' value='<?php
print get_request_var('filter');
?>
'>
</td>
<?php
print html_host_filter(get_request_var('host_id'));
?>
<td>
<?php
print __('Template');
?>
</td>
<td>
<select id='data_template_id' onChange='applyFilter()'>
<option value='-1'><?php
print __('Any');
?>
</option>
<?php
foreach ($data_templates as $row) {
echo "<option value='" . $row['id'] . "'" . (isset_request_var('data_template_id') && $row['id'] == get_request_var('data_template_id') ? ' selected' : '') . '>' . $row['name'] . '</option>';
}
?>
</select>
</td>
<td>
<?php
print __('State');
?>
</td>
<td>
<select id='state' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('state') == '-1') {
?>
selected<?php
}
?>
><?php
print __('All');
?>
</option>
<option value='1'<?php
if (get_request_var('state') == '1') {
?>
selected<?php
}
?>
><?php
print __('Breached');
?>
</option>
<option value='3'<?php
if (get_request_var('state') == '3') {
?>
selected<?php
}
?>
><?php
print __('Triggered');
?>
</option>
<option value='2'<?php
if (get_request_var('state') == '2') {
?>
selected<?php
}
?>
><?php
print __('Enabled');
?>
</option>
<option value='0'<?php
if (get_request_var('state') == '0') {
?>
selected<?php
}
?>
><?php
print __('Disabled');
?>
</option>
</select>
</td>
<td>
<input type='button' id='refresh' value='<?php
print __('Go');
?>
' title='<?php
print __('Apply Filters');
?>
' onClick='applyFilter()'>
</td>
<td>
<input type='button' id='clear' value='<?php
print __('Clear');
?>
' title='<?php
print __('Return to Defaults');
?>
' onClick='clearFilter()'>
</td>
</tr>
</table>
<input type='hidden' name='search' value='search'>
<input type='hidden' id='page' value='<?php
print get_filter_request_var('page');
?>
'>
</form>
<script type='text/javascript'>
function applyFilter() {
strURL = 'thold.php?header=false&host_id=' + $('#host_id').val();
strURL += '&state=' + $('#state').val();
strURL += '&data_template_id=' + $('#data_template_id').val();
strURL += '&filter=' + $('#filter').val();
loadPageNoHeader(strURL);
}
function clearFilter() {
strURL = 'thold.php?header=false&clear=1';
loadPageNoHeader(strURL);
}
$(function() {
$('#listthold').submit(function(event) {
event.preventDefault();
applyFilter();
});
});
</script>
</td>
</tr>
<?php
html_end_box();
$nav = html_nav_bar('thold.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 14, __('Thresholds'), 'page', 'main');
form_start('thold.php', 'chk');
print $nav;
html_start_box('', '100%', '', '4', 'center', '');
$display_text = array('name' => array('display' => __('Name'), 'sort' => 'ASC', 'align' => 'left'), 'id' => array('display' => __('ID'), 'sort' => 'ASC', 'align' => 'right'), 'thold_type' => array('display' => __('Type'), 'sort' => 'ASC', 'align' => 'right'), 'data_source' => array('display' => __('DSName'), 'sort' => 'ASC', 'align' => 'right'), 'lastread' => array('display' => __('Current'), 'sort' => 'ASC', 'align' => 'right', 'tip' => __('The last measured value for the Data Source')), 'thold_hi' => array('display' => __('High'), 'sort' => 'ASC', 'align' => 'right', 'tip' => __('High Threshold values for Warning/Alert')), 'thold_low' => array('display' => __('Low'), 'sort' => 'ASC', 'align' => 'right', 'tip' => __('Low Threshold values for Warning/Alert')), 'nosort3' => array('display' => __('Trigger'), 'sort' => '', 'align' => 'right'), 'nosort4' => array('display' => __('Duration'), 'sort' => '', 'align' => 'right'), 'repeat_alert' => array('display' => __('Repeat'), 'sort' => 'ASC', 'align' => 'right'), 'thold_alert' => array('display' => __('Triggered'), 'sort' => 'ASC', 'align' => 'right'), 'template_enabled' => array('display' => __('Templated'), 'sort' => 'ASC', 'align' => 'right'));
html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false);
$c = 0;
$i = 0;
if (sizeof($tholds)) {
foreach ($tholds as $thold_data) {
$c++;
$grapharr = db_fetch_row('SELECT DISTINCT graph_templates_item.local_graph_id
FROM graph_templates_item, data_template_rrd
WHERE (data_template_rrd.local_data_id=' . $thold_data['local_data_id'] . '
AND data_template_rrd.id=graph_templates_item.task_item_id)');
$local_graph_id = $grapharr['local_graph_id'];
$alertstat = __('No');
$bgcolor = 'green';
if ($thold_data['thold_type'] == 0) {
if ($thold_data['thold_alert'] != 0) {
$alertstat = __('Yes');
if ($thold_data['thold_fail_count'] >= $thold_data['thold_fail_trigger']) {
$bgcolor = 'red';
} elseif ($thold_data['thold_warning_fail_count'] >= $thold_data['thold_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} elseif ($thold_data['thold_type'] == 2) {
if ($thold_data['thold_alert'] != 0) {
$alertstat = __('Yes');
if ($thold_data['thold_fail_count'] >= $thold_data['time_fail_trigger']) {
$bgcolor = 'red';
} elseif ($thold_data['thold_warning_fail_count'] >= $thold_data['time_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} else {
if ($thold_data['bl_alert'] == 1) {
$alertstat = __('baseline-LOW');
$bgcolor = $thold_data['bl_fail_count'] >= $thold_data['bl_fail_trigger'] ? 'orange' : 'yellow';
} elseif ($thold_data['bl_alert'] == 2) {
$alertstat = __('baseline-HIGH');
$bgcolor = $thold_data['bl_fail_count'] >= $thold_data['bl_fail_trigger'] ? 'orange' : 'yellow';
}
}
$data_source = db_fetch_cell_prepared('SELECT data_source_name FROM data_template_rrd WHERE id = ?', array($thold_data['data_template_rrd_id']));
if ($thold_data['thold_enabled'] == 'off') {
print "<tr class='selectable " . $thold_states['grey']['class'] . "' id='line" . $thold_data['id'] . "'>\n";
} else {
print "<tr class='selectable " . $thold_states[$bgcolor]['class'] . "' id='line" . $thold_data['id'] . "'>\n";
}
form_selectable_cell(filter_value($thold_data['name'] != '' ? $thold_data['name'] : $thold_data['name_cache'] . ' [' . $thold_data['data_source_name'] . ']', get_request_var('filter'), 'thold.php?action=edit&id=' . $thold_data['id']) . '</a>', $thold_data['id'], '', 'text-align:left');
form_selectable_cell($thold_data['id'], $thold_data['id'], '', 'text-align:right');
form_selectable_cell($thold_types[$thold_data['thold_type']], $thold_data['id'], '', 'text-align:right');
form_selectable_cell($data_source, $thold_data['id'], '', 'text-align:right');
switch ($thold_data['thold_type']) {
case 0:
form_selectable_cell(thold_format_number($thold_data['lastread']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell(thold_format_number($thold_data['thold_warning_hi']) . ' / ' . thold_format_number($thold_data['thold_hi']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell(thold_format_number($thold_data['thold_warning_low']) . ' / ' . thold_format_number($thold_data['thold_low']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell('<i>' . plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['thold_fail_trigger'], 'alert') . '</i>', $thold_data['id'], '', 'text-align:right');
form_selectable_cell(__('N/A'), $thold_data['id'], '', 'text-align:right');
break;
case 1:
form_selectable_cell(thold_format_number($thold_data['lastread']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell(thold_format_number($thold_data['thold_warning_hi']) . ' / ' . thold_format_number($thold_data['thold_hi']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell(thold_format_number($thold_data['thold_warning_low']) . ' / ' . thold_format_number($thold_data['thold_low']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell('<i>' . plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['bl_fail_trigger'], 'alert') . '</i>', $thold_data['id'], '', 'text-align:right');
form_selectable_cell($timearray[$thold_data['bl_ref_time_range'] / 300], $thold_data['id'], '', 'text-align:right');
break;
case 2:
form_selectable_cell(thold_format_number($thold_data['lastread']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell(thold_format_number($thold_data['time_warning_hi']) . ' / ' . thold_format_number($thold_data['time_hi']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell(thold_format_number($thold_data['time_warning_low']) . ' / ' . thold_format_number($thold_data['time_low']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell('<i>' . __('%d Triggers', $thold_data['time_fail_trigger']) . '</i>', $thold_data['id'], '', 'text-align:right');
form_selectable_cell('<i>' . plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['time_fail_length'], 'time') . '</i>', $thold_data['id'], '', 'text-align:right');
break;
default:
form_selectable_cell(thold_format_number($thold_data['lastread']), $thold_data['id'], '', 'text-align:right');
form_selectable_cell('- / -', $thold_data['id'], '', 'text-align:right');
form_selectable_cell('- / -', $thold_data['id'], '', 'text-align:right');
form_selectable_cell(__('N/A'), $thold_data['id'], '', 'text-align:right');
form_selectable_cell(__('N/A'), $thold_data['id'], '', 'text-align:right');
}
form_selectable_cell($thold_data['repeat_alert'] == '' ? '' : plugin_thold_duration_convert($thold_data['local_data_id'], $thold_data['repeat_alert'], 'repeat'), $thold_data['id'], '', 'text-align:right');
form_selectable_cell($alertstat, $thold_data['id'], '', 'text-align:right');
if ($thold_data['thold_template_id'] != 0) {
form_selectable_cell($thold_data['template_enabled'] == '' ? __('No') : __('Yes'), $thold_data['id'], '', 'text-align:right');
} else {
form_selectable_cell(__('No'), $thold_data['id'], '', 'text-align:right');
}
form_checkbox_cell($thold_data['name'], $thold_data['id'], '', 'text-align:left');
form_end_row();
}
} else {
print "<tr class='even'><td colspan='14'><center>" . __('No Thresholds') . "</center></td></tr>\n";
}
html_end_box(false);
if (sizeof($tholds)) {
print $nav;
}
thold_legend();
draw_actions_dropdown($thold_actions);
if (isset($host_id) && $host_id != '') {
print "<input type='hidden' name='host_id' value='{$host_id}'>";
}
form_end();
bottom_footer();
}
function thold_check_threshold($rra_id, $data_id, $name, $currentval, $cdef)
{
global $config, $plugins, $debug;
thold_debug("Checking Threshold: DS:{$name} RRA_ID:{$rra_id} DATA_ID:{$data_id} VALUE:{$currentval}");
$debug = false;
// Do not proceed if we have chosen to globally disable all alerts
if (read_config_option('thold_disable_all') == 'on') {
thold_debug('Threshold checking is disabled globally');
return;
}
$alert_exempt = read_config_option('alert_exempt');
/* check for exemptions */
$weekday = date('l');
if (($weekday == 'Saturday' || $weekday == 'Sunday') && $alert_exempt == 'on') {
thold_debug('Threshold checking is disabled by global weekend exemption');
return;
}
/* Get all the info about the item from the database */
$item = db_fetch_assoc("SELECT * FROM thold_data WHERE thold_enabled='on' AND data_id=" . $data_id);
/* return if the item doesn't exist, which means its disabled */
if (!isset($item[0])) {
thold_debug('Threshold is disabled');
return;
}
$item = $item[0];
/* check for the weekend exemption on the threshold level */
if (($weekday == 'Saturday' || $weekday == 'Sunday') && $item['exempt'] == 'on') {
thold_debug('Threshold checking is disabled by global weekend exemption');
return;
}
/* don't alert for this host if it's selected for maintenance */
if (api_plugin_is_enabled('maint') || in_array('maint', $plugins)) {
include_once $config["base_path"] . '/plugins/maint/functions.php';
if (plugin_maint_check_cacti_host($item['host_id'])) {
thold_debug('Threshold checking is disabled by maintenance schedule');
return;
}
}
$graph_id = $item['graph_id'];
/* only alert if Host is in UP mode (not down, unknown, or recovering) */
$h = db_fetch_row('SELECT * FROM host WHERE id=' . $item['host_id']);
if ($h['status'] != 3) {
thold_debug('Threshold checking halted by Host Status (' . $h['status'] . ')');
return;
}
/* pull the cached name, if not present, it means that the graph hasn't polled yet */
$t = db_fetch_assoc('SELECT id, name, name_cache
FROM data_template_data
WHERE local_data_id = ' . $rra_id . '
ORDER BY id
LIMIT 1');
/* pull a few default settings */
$global_alert_address = read_config_option('alert_email');
$global_notify_enabled = read_config_option('alert_notify_default') == 'on';
$logset = read_config_option('alert_syslog') == 'on';
$deadnotify = read_config_option('alert_deadnotify') == 'on';
$realert = read_config_option('alert_repeat');
$alert_trigger = read_config_option('alert_trigger');
$alert_bl_trigger = read_config_option('alert_bl_trigger');
$httpurl = read_config_option('alert_base_url');
$thold_show_datasource = read_config_option('thold_show_datasource');
$thold_send_text_only = read_config_option('thold_send_text_only');
$thold_alert_text = read_config_option('thold_alert_text');
$thold_warning_text = read_config_option('thold_warning_text');
/* remove this after adding an option for it */
$thold_show_datasource = true;
$trigger = $item['thold_fail_trigger'] == '' ? $alert_trigger : $item['thold_fail_trigger'];
$warning_trigger = $item['thold_warning_fail_trigger'] == '' ? $alert_trigger : $item['thold_warning_fail_trigger'];
$alertstat = $item['thold_alert'];
/* make sure the alert text has been set */
if (!isset($thold_alert_text) || $thold_alert_text == '') {
$thold_alert_text = "<html><body>An alert has been issued that requires your attention.<br><br><strong>Host</strong>: <DESCRIPTION> (<HOSTNAME>)<br><strong>URL</strong>: <URL><br><strong>Message</strong>: <SUBJECT><br><br><GRAPH></body></html>";
}
/* make sure the warning text has been set */
if (!isset($thold_warning_text) || $thold_warning_text == '') {
$thold_warning_text = "<html><body>A warning has been issued that requires your attention.<br><br><strong>Host</strong>: <DESCRIPTION> (<HOSTNAME>)<br><strong>URL</strong>: <URL><br><strong>Message</strong>: <SUBJECT><br><br><GRAPH></body></html>";
}
$hostname = db_fetch_row('SELECT description, hostname from host WHERE id = ' . $item['host_id']);
$rows = db_fetch_assoc('SELECT plugin_thold_contacts.data
FROM plugin_thold_contacts, plugin_thold_threshold_contact
WHERE plugin_thold_contacts.id=plugin_thold_threshold_contact.contact_id
AND plugin_thold_threshold_contact.thold_id = ' . $item['id']);
$alert_emails = '';
if (read_config_option('thold_disable_legacy') != 'on') {
$alert_emails = array();
if (count($rows)) {
foreach ($rows as $row) {
$alert_emails[] = $row['data'];
}
}
$alert_emails = implode(',', $alert_emails);
if ($alert_emails != '') {
$alert_emails .= ',' . $item['notify_extra'];
} else {
$alert_emails = $item['notify_extra'];
}
}
$alert_emails .= (strlen($alert_emails) ? "," : "") . get_thold_notification_emails($item['notify_alert']);
$alert_phones = '';
if (read_config_option('thold_disable_legacy') != 'on') {
// $alert_phones = array();
// if (count($rows)) {
// foreach ($rows as $row) {
// $alert_phones[] = $row['data'];
// }
// }
// $alert_phones = implode(',', $alert_phones);
if ($alert_phones != '') {
$alert_phones .= ',' . $thold['alert_phones_extra'];
} else {
$alert_phones = $item['alert_phones_extra'];
}
}
$alert_phones .= (strlen($alert_phones) ? "," : "") . get_thold_notification_phones($item['notify_alert']);
$warning_emails = '';
if (read_config_option('thold_disable_legacy') != 'on') {
$warning_emails = $item['notify_warning_extra'];
}
$warning_emails .= (strlen($warning_emails) ? "," : "") . get_thold_notification_emails($item['notify_warning']);
$warning_phones = '';
if (read_config_option('thold_disable_legacy') != 'on') {
$warning_phones = $item['warning_phones_extra'];
}
$alert_command = '';
$alert_command = $item['alert_command'];
thold_debug('Alert Command: ' . $alert_command);
$warning_command = $item['warning_command'];
$types = array('High/Low', 'Baseline Deviation', 'Time Based');
// Do some replacement of variables
$thold_alert_text = str_replace('<DESCRIPTION>', $hostname['description'], $thold_alert_text);
$thold_alert_text = str_replace('<HOSTNAME>', $hostname['hostname'], $thold_alert_text);
$thold_alert_text = str_replace('<TIME>', time(), $thold_alert_text);
$thold_alert_text = str_replace('<GRAPHID>', $graph_id, $thold_alert_text);
$thold_alert_text = str_replace('<URL>', "<a href='{$httpurl}/graph.php?local_graph_id={$graph_id}&rra_id=1'>{$httpurl}/graph.php?local_graph_id={$graph_id}&rra_id=1</a>", $thold_alert_text);
$thold_alert_text = str_replace('<CURRENTVALUE>', $currentval, $thold_alert_text);
$thold_alert_text = str_replace('<THRESHOLDNAME>', $item['name'], $thold_alert_text);
$thold_alert_text = str_replace('<DSNAME>', $name, $thold_alert_text);
$thold_alert_text = str_replace('<THOLDTYPE>', $types[$item['thold_type']], $thold_alert_text);
$thold_alert_text = str_replace('<HI>', $item['thold_type'] == 0 ? $item['thold_hi'] : ($item['thold_type'] == 2 ? $item['time_hi'] : ''), $thold_alert_text);
$thold_alert_text = str_replace('<LOW>', $item['thold_type'] == 0 ? $item['thold_low'] : ($item['thold_type'] == 2 ? $item['time_low'] : ''), $thold_alert_text);
$thold_alert_text = str_replace('<TRIGGER>', $item['thold_type'] == 0 ? $item['thold_fail_trigger'] : ($item['thold_type'] == 2 ? $item['time_fail_trigger'] : ''), $thold_alert_text);
$thold_alert_text = str_replace('<DURATION>', $item['thold_type'] == 2 ? plugin_thold_duration_convert($item['rra_id'], $item['time_fail_length'], 'time') : '', $thold_alert_text);
$thold_alert_text = str_replace('<DATE_RFC822>', date(DATE_RFC822), $thold_alert_text);
$thold_alert_text = str_replace('<DEVICENOTE>', $h['notes'], $thold_alert_text);
// Do some replacement of variables
$thold_warning_text = str_replace('<DESCRIPTION>', $hostname['description'], $thold_warning_text);
$thold_warning_text = str_replace('<HOSTNAME>', $hostname['hostname'], $thold_warning_text);
$thold_warning_text = str_replace('<TIME>', time(), $thold_warning_text);
$thold_warning_text = str_replace('<GRAPHID>', $graph_id, $thold_warning_text);
$thold_warning_text = str_replace('<URL>', "<a href='{$httpurl}/graph.php?local_graph_id={$graph_id}&rra_id=1'>{$httpurl}/graph.php?local_graph_id={$graph_id}&rra_id=1</a>", $thold_warning_text);
$thold_warning_text = str_replace('<CURRENTVALUE>', $currentval, $thold_warning_text);
$thold_warning_text = str_replace('<THRESHOLDNAME>', $item['name'], $thold_warning_text);
$thold_warning_text = str_replace('<DSNAME>', $name, $thold_warning_text);
$thold_warning_text = str_replace('<THOLDTYPE>', $types[$item['thold_type']], $thold_warning_text);
$thold_warning_text = str_replace('<HI>', $item['thold_type'] == 0 ? $item['thold_hi'] : ($item['thold_type'] == 2 ? $item['time_warning_hi'] : ''), $thold_warning_text);
$thold_warning_text = str_replace('<LOW>', $item['thold_type'] == 0 ? $item['thold_low'] : ($item['thold_type'] == 2 ? $item['time_warning_low'] : ''), $thold_warning_text);
$thold_warning_text = str_replace('<TRIGGER>', $item['thold_type'] == 0 ? $item['thold_warning_fail_trigger'] : ($item['thold_type'] == 2 ? $item['time_warning_fail_trigger'] : ''), $thold_warning_text);
$thold_warning_text = str_replace('<DURATION>', $item['thold_type'] == 2 ? plugin_thold_duration_convert($item['rra_id'], $item['time_warning_fail_length'], 'time') : '', $thold_warning_text);
$thold_warning_text = str_replace('<DATE_RFC822>', date(DATE_RFC822), $thold_warning_text);
$thold_warning_text = str_replace('<DEVICENOTE>', $h['notes'], $thold_warning_text);
$msg = $thold_alert_text;
$warn_msg = $thold_warning_text;
if ($thold_send_text_only == 'on') {
$file_array = '';
} else {
$file_array = array(0 => array('local_graph_id' => $graph_id, 'rra_id' => 0, 'file' => "{$httpurl}/graph_image.php?local_graph_id={$graph_id}&rra_id=0&view_type=tree", 'mimetype' => 'image/png', 'filename' => $graph_id));
}
$url = $httpurl . "/graph.php?local_graph_id=" . $graph_id . "&rra_id=all";
switch ($item['thold_type']) {
case 0:
/* hi/low */
if ($currentval != '') {
$breach_up = $item['thold_hi'] != '' && $currentval > $item['thold_hi'];
$breach_down = $item['thold_low'] != '' && $currentval < $item['thold_low'];
$warning_breach_up = $item['thold_warning_hi'] != '' && $currentval > $item['thold_warning_hi'];
$warning_breach_down = $item['thold_warning_low'] != '' && $currentval < $item['thold_warning_low'];
} else {
$breach_up = $breach_down = $warning_breach_up = $warning_breach_down = false;
}
/* is in alert status */
if ($breach_up || $breach_down) {
$notify = false;
thold_debug('Threshold HI / Low check breached HI:' . $item['thold_hi'] . ' LOW:' . $item['thold_low'] . ' VALUE:' . $currentval);
$item['thold_fail_count']++;
$item['thold_alert'] = $breach_up ? STAT_HI : STAT_LO;
/* Re-Alert? */
$ra = $item['thold_fail_count'] > $trigger && $item['repeat_alert'] != 0 && $item['thold_fail_count'] % $item['repeat_alert'] == 0;
if ($item['thold_fail_count'] == $trigger || $ra) {
$notify = true;
}
$subject = "ALERT: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . ' ' . ($ra ? 'is still ' : 'went') . ' ' . ($breach_up ? 'above' : 'below') . ' threshold of ' . ($breach_up ? $item['thold_hi'] : $item['thold_low']) . " with {$currentval}";
if ($notify) {
thold_debug('Alerting is necessary');
if ($logset == 1) {
logger($item['name'], $ra ? 'realert' : 'alert', $breach_up ? $item['thold_hi'] : $item['thold_low'], $currentval, $trigger, $item['thold_fail_count'], $url);
}
if ($alert_command != '') {
exec_script($alert_command);
}
if (trim($alert_phones) != '') {
thold_sms($alert_phones, $subject);
}
if (trim($alert_emails) != '') {
thold_mail($alert_emails, '', $subject, $msg, $file_array);
}
thold_log(array('type' => 0, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $breach_up ? $item['thold_hi'] : $item['thold_low'], 'current' => $currentval, 'status' => $ra ? ST_NOTIFYRA : ST_NOTIFYAL, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones, 'command' => $alert_command));
}
db_execute("UPDATE thold_data\r\n\t\t\t\tSET thold_alert=" . $item['thold_alert'] . ",\r\n\t\t\t\tthold_fail_count=" . $item['thold_fail_count'] . ",\r\n\t\t\t\tthold_warning_fail_count=0\r\n\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
} elseif ($warning_breach_up || $warning_breach_down) {
$notify = false;
thold_debug('Threshold HI / Low Warning check breached HI:' . $item['thold_warning_hi'] . ' LOW:' . $item['thold_warning_low'] . ' VALUE:' . $currentval);
$item['thold_warning_fail_count']++;
$item['thold_alert'] = $warning_breach_up ? STAT_HI : STAT_LO;
/* re-alert? */
$ra = $item['thold_warning_fail_count'] > $warning_trigger && $item['repeat_alert'] != 0 && $item['thold_warning_fail_count'] % $item['repeat_alert'] == 0;
if ($item['thold_warning_fail_count'] == $warning_trigger || $ra) {
$notify = true;
}
$subject = ($notify ? "WARNING: " : "TRIGGER: ") . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . ' ' . ($ra ? 'is still' : 'went') . ' ' . ($warning_breach_up ? 'above' : 'below') . ' threshold of ' . ($warning_breach_up ? $item['thold_warning_hi'] : $item['thold_warning_low']) . " with {$currentval}";
if ($notify) {
thold_debug('Alerting is necessary');
if ($logset == 1) {
logger($item['name'], $ra ? 'rewarning' : 'warning', $warning_breach_up ? $item['thold_warning_hi'] : $item['thold_warning_low'], $currentval, $warning_trigger, $item['thold_warning_fail_count'], $url);
}
if ($warning_command != '') {
exec_script($warning_command);
}
if (trim($warning_phones) != '') {
thold_sms($warning_phones, $subject);
}
if (trim($warning_emails) != '') {
thold_mail($warning_emails, '', $subject, $warn_msg, $file_array);
}
thold_log(array('type' => 0, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $warning_breach_up ? $item['thold_warning_hi'] : $item['thold_warning_low'], 'current' => $currentval, 'status' => $ra ? ST_NOTIFYRA : ST_NOTIFYWA, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $warning_phones, 'command' => $warning_command));
} elseif ($item['thold_warning_fail_count'] >= $warning_trigger && $item['thold_fail_count'] >= $trigger) {
$subject = "ALERT -> WARNING: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . " Changed to Warning Threshold with Value {$currentval}";
if (trim($alert_emails) != '') {
thold_mail($alert_emails, '', $subject, $warn_msg, $file_array);
}
if (trim($alert_phones) != '') {
thold_sms($alert_phones, $subject);
}
thold_log(array('type' => 0, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $warning_breach_up ? $item['thold_warning_hi'] : $item['thold_warning_low'], 'current' => $currentval, 'status' => ST_NOTIFYAW, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones));
}
db_execute("UPDATE thold_data\r\n\t\t\t\tSET thold_alert=" . $item['thold_alert'] . ",\r\n\t\t\t\tthold_warning_fail_count=" . $item['thold_warning_fail_count'] . ",\r\n\t\t\t\tthold_fail_count=0\r\n\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
} else {
thold_debug('Threshold HI / Low check is normal HI:' . $item['thold_hi'] . ' LOW:' . $item['thold_low'] . ' VALUE:' . $currentval);
/* if we were at an alert status before */
if ($alertstat != 0) {
$subject = "NORMAL: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . " Restored to Normal Threshold with Value {$currentval}";
db_execute("UPDATE thold_data\r\n\t\t\t\t\tSET thold_alert=0, thold_fail_count=0, thold_warning_fail_count=0\r\n\t\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
if ($item['thold_warning_fail_count'] >= $warning_trigger && $item['restored_alert'] != 'on') {
if ($logset == 1) {
logger($item['name'], 'ok', 0, $currentval, $warning_trigger, $item['thold_warning_fail_count'], $url);
}
if (trim($warning_emails) != '' && $item['restored_alert'] != 'on') {
thold_mail($warning_emails, '', $subject, $warn_msg, $file_array);
}
if (trim($warning_phones) != '' && $item['restored_alert'] != 'on') {
thold_sms($warning_phones, $subject);
}
thold_log(array('type' => 0, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => '', 'current' => $currentval, 'status' => ST_NOTIFYRS, 'description' => $subject, 'emails' => $warning_emails, 'phones' => $warning_phones));
} elseif ($item['thold_fail_count'] >= $trigger && $item['restored_alert'] != 'on') {
if ($logset == 1) {
logger($item['name'], 'ok', 0, $currentval, $trigger, $item['thold_fail_count'], $url);
}
if (trim($alert_emails) != '' && $item['restored_alert'] != 'on') {
thold_mail($alert_emails, '', $subject, $msg, $file_array);
}
if (trim($alert_phones) != '' && $item['restored_alert'] != 'on') {
thold_sms($alert_phones, $subject);
}
thold_log(array('type' => 0, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => '', 'current' => $currentval, 'status' => ST_NOTIFYRS, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones));
}
}
}
break;
case 1:
/* baseline */
$bl_alert_prev = $item['bl_alert'];
$bl_count_prev = $item['bl_fail_count'];
$bl_fail_trigger = $item['bl_fail_trigger'] == '' ? $alert_bl_trigger : $item['bl_fail_trigger'];
$item['bl_alert'] = thold_check_baseline($rra_id, $name, $currentval, $item);
switch ($item['bl_alert']) {
case -2:
/* exception is active, Future Release 'todo' */
break;
case -1:
/* reference value not available, Future Release 'todo' */
break;
case 0:
/* all clear */
/* if we were at an alert status before */
if ($alertstat != 0) {
thold_debug('Threshold Baseline check is normal');
if ($item['bl_fail_count'] >= $bl_fail_trigger && $item['restored_alert'] != 'on') {
thold_debug('Threshold Baseline check returned to normal');
if ($logset == 1) {
logger($item['name'], 'ok', 0, $currentval, $item['bl_fail_trigger'], $item['bl_fail_count'], $url);
}
$subject = "NORMAL: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . " restored to normal threshold with value {$currentval}";
if (trim($alert_emails) != '') {
thold_mail($alert_emails, '', $subject, $msg, $file_array);
}
if (trim($alert_phones) != '') {
thold_sms($alert_phones, $subject);
}
thold_log(array('type' => 1, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => '', 'current' => $currentval, 'status' => ST_NOTIFYRA, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones));
}
}
$item['bl_fail_count'] = 0;
break;
case 1:
/* value is below calculated threshold */
/* value is below calculated threshold */
case 2:
/* value is above calculated threshold */
$item['bl_fail_count']++;
$breach_up = $item['bl_alert'] == STAT_HI;
$breach_down = $item['bl_alert'] == STAT_LO;
thold_debug('Threshold Baseline check breached');
/* re-alert? */
$ra = $item['bl_fail_count'] > $bl_fail_trigger && $item['bl_fail_count'] % ($item['repeat_alert'] == '' ? $realert : $item['repeat_alert']) == 0;
if ($item['bl_fail_count'] == $bl_fail_trigger || $ra) {
thold_debug('Alerting is necessary');
$subject = "ALERT: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . ' ' . ($ra ? 'is still' : 'went') . ' ' . ($breach_up ? 'above' : 'below') . " calculated baseline threshold " . ($breach_up ? $item['thold_hi'] : $item['thold_low']) . " with {$currentval}";
if ($logset == 1) {
logger($item['name'], $ra ? 'realert' : 'alert', $breach_up ? $item['thold_hi'] : $item['thold_low'], $currentval, $item['bl_fail_trigger'], $item['bl_fail_count'], $url);
}
if ($alert_command != '') {
exec_script($alert_command);
}
if (trim($alert_phones) != '') {
thold_sms($alert_phones, $subject);
}
if (trim($alert_emails) != '') {
thold_mail($alert_emails, '', $subject, $msg, $file_array);
}
thold_log(array('type' => 1, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $breach_up ? $item['thold_hi'] : $item['thold_low'], 'current' => $currentval, 'status' => $ra ? ST_NOTIFYRA : ST_NOTIFYAL, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones, 'command' => $alert_command));
} else {
thold_log(array('type' => 1, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $breach_up ? $item['thold_hi'] : $item['thold_low'], 'current' => $currentval, 'status' => ST_TRIGGERA, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones));
}
break;
}
db_execute("UPDATE thold_data SET thold_alert=0, thold_fail_count=0,\r\n\t\t\tbl_alert='" . $item['bl_alert'] . "',\r\n\t\t\tbl_fail_count='" . $item['bl_fail_count'] . "',\r\n\t\t\tthold_low='" . $item['thold_low'] . "',\r\n\t\t\tthold_hi='" . $item['thold_hi'] . "',\r\n\t\t\tbl_thold_valid='" . $item['bl_thold_valid'] . "'\r\n\t\t\tWHERE rra_id='{$rra_id}' AND data_id=" . $item['data_id']);
break;
case 2:
/* time based */
if ($currentval != '') {
$breach_up = $item['time_hi'] != '' && $currentval > $item['time_hi'];
$breach_down = $item['time_low'] != '' && $currentval < $item['time_low'];
$warning_breach_up = $item['time_warning_hi'] != '' && $currentval > $item['time_warning_hi'];
$warning_breach_down = $item['time_warning_low'] != '' && $currentval < $item['time_warning_low'];
} else {
$breach_up = $breach_down = $warning_breach_up = $warning_breach_down = false;
}
$step = db_fetch_cell('SELECT rrd_step FROM data_template_data WHERE local_data_id = ' . $rra_id, FALSE);
/* alerts */
$trigger = $item['time_fail_trigger'];
$time = time() - $item['time_fail_length'] * $step;
$failures = db_fetch_cell("SELECT count(id) FROM plugin_thold_log WHERE threshold_id=" . $item['id'] . " AND status IN (" . ST_TRIGGERA . "," . ST_NOTIFYRA . "," . ST_NOTIFYAL . ") AND time>" . $time);
/* warnings */
$warning_trigger = $item['time_warning_fail_trigger'];
$warning_time = time() - $item['time_warning_fail_length'] * $step;
$warning_failures = db_fetch_cell("SELECT count(id) FROM plugin_thold_log WHERE threshold_id=" . $item['id'] . " AND status IN (" . ST_NOTIFYWA . "," . ST_TRIGGERW . ") AND time>" . $warning_time) + $failures;
if ($breach_up || $breach_down) {
$notify = false;
thold_debug('Threshold Time Based check breached HI:' . $item['time_hi'] . ' LOW:' . $item['time_low'] . ' VALUE:' . $currentval);
$item['thold_alert'] = $breach_up ? STAT_HI : STAT_LO;
$item['thold_fail_count'] = $failures;
/* we should only re-alert X minutes after last email, not every 5 pollings, etc...
re-alert? */
$realerttime = ($item['repeat_alert'] - 1) * $step;
$lastemailtime = db_fetch_cell("SELECT time\r\n\t\t\t\tFROM plugin_thold_log\r\n\t\t\t\tWHERE threshold_id=" . $item['id'] . "\r\n\t\t\t\tAND status IN (" . ST_NOTIFYRA . "," . ST_NOTIFYAL . ")\r\n\t\t\t\tORDER BY time DESC\r\n\t\t\t\tLIMIT 1", FALSE);
$ra = $failures > $trigger && $item['repeat_alert'] && !empty($lastemailtime) && $lastemailtime + $realerttime <= time();
$failures++;
thold_debug("Alert Time:'{$time}', Alert Trigger:'{$trigger}', Alert Failures:'{$failures}', RealertTime:'{$realerttime}', LastTime:'{$lastemailtime}', RA:'{$ra}', Diff:'" . ($realerttime + $lastemailtime) . "'<'" . time() . "'");
if ($failures == $trigger || $ra) {
$notify = true;
}
$subject = ($notify ? "ALERT: " : "TRIGGER: ") . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . ' ' . ($failures > $trigger ? 'is still' : 'went') . ' ' . ($breach_up ? 'above' : 'below') . ' threshold of ' . ($breach_up ? $item['time_hi'] : $item['time_low']) . " with {$currentval}";
if ($notify) {
thold_debug('Alerting is necessary');
if ($logset == 1) {
logger($item['name'], $failures > $trigger ? 'realert' : 'alert', $breach_up ? $item['time_hi'] : $item['time_low'], $currentval, $trigger, $failures, $url);
}
if ($alert_command != '') {
exec_script($alert_command);
}
if (trim($alert_phones) != '') {
thold_sms($alert_phones, $subject);
}
if (trim($alert_emails) != '') {
thold_mail($alert_emails, '', $subject, $msg, $file_array);
}
thold_log(array('type' => 2, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $breach_up ? $item['time_hi'] : $item['time_low'], 'current' => $currentval, 'status' => $failures > $trigger ? ST_NOTIFYAL : ST_NOTIFYRA, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones, 'command' => $alert_command));
} else {
thold_log(array('type' => 2, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $breach_up ? $item['time_hi'] : $item['time_low'], 'current' => $currentval, 'status' => ST_TRIGGERA, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones));
}
db_execute("UPDATE thold_data\r\n\t\t\t\tSET thold_alert=" . $item['thold_alert'] . ",\r\n\t\t\t\tthold_fail_count={$failures}\r\n\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
} elseif ($warning_breach_up || $warning_breach_down) {
$notify = false;
$item['thold_alert'] = $warning_breach_up ? STAT_HI : STAT_LO;
$item['thold_warning_fail_count'] = $warning_failures;
/* we should only re-alert X minutes after last email, not every 5 pollings, etc...
re-alert? */
$realerttime = ($item['time_warning_fail_length'] - 1) * $step;
$lastemailtime = db_fetch_cell("SELECT time\r\n\t\t\t\tFROM plugin_thold_log\r\n\t\t\t\tWHERE threshold_id=" . $item['id'] . "\r\n\t\t\t\tAND status IN (" . ST_NOTIFYRA . "," . ST_NOTIFYWA . ")\r\n\t\t\t\tORDER BY time DESC\r\n\t\t\t\tLIMIT 1", FALSE);
$ra = $warning_failures > $warning_trigger && $item['time_warning_fail_length'] && !empty($lastemailtime) && $lastemailtime + $realerttime <= time();
$warning_failures++;
thold_debug("Warn Time:'{$warning_time}', Warn Trigger:'{$warning_trigger}', Warn Failures:'{$warning_failures}', RealertTime:'{$realerttime}', LastTime:'{$lastemailtime}', RA:'{$ra}', Diff:'" . ($realerttime + $lastemailtime) . "'<'" . time() . "'");
if ($warning_failures == $warning_trigger || $ra) {
$notify = true;
}
$subject = ($notify ? "WARNING: " : "TRIGGER: ") . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . ' ' . ($warning_failures > $warning_trigger ? 'is still' : 'went') . ' ' . ($warning_breach_up ? 'above' : 'below') . ' threshold of ' . ($warning_breach_up ? $item['time_warning_hi'] : $item['time_warning_low']) . " with {$currentval}";
if ($notify) {
if ($logset == 1) {
logger($item['name'], $warning_failures > $warning_trigger ? 'rewarning' : 'warning', $warning_breach_up ? $item['time_warning_hi'] : $item['time_warning_low'], $currentval, $warning_trigger, $warning_failures, $url);
}
if ($warning_command != '') {
exec_script($warning_command);
}
if (trim($warning_phones) != '') {
thold_sms($warning_phones, $subject);
}
if (trim($alert_emails) != '') {
thold_mail($warning_emails, '', $subject, $warn_msg, $file_array);
}
thold_log(array('type' => 2, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $breach_up ? $item['time_hi'] : $item['time_low'], 'current' => $currentval, 'status' => $warning_failures > $warning_trigger ? ST_NOTIFYRA : ST_NOTIFYWA, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $warning_phones, 'command' => $warning_command));
} elseif ($alertstat != 0 && $warning_failures < $warning_trigger && $failures < $trigger) {
$subject = "ALERT -> WARNING: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . " restored to warning threshold with value {$currentval}";
thold_log(array('type' => 2, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $warning_breach_up ? $item['time_hi'] : $item['time_low'], 'current' => $currentval, 'status' => ST_NOTIFYAW, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $warning_phones));
} else {
thold_log(array('type' => 2, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => $warning_breach_up ? $item['time_hi'] : $item['time_low'], 'current' => $currentval, 'status' => ST_TRIGGERW, 'description' => $subject, 'emails' => $warning_emails, 'phones' => $warning_phones));
}
db_execute("UPDATE thold_data\r\n\t\t\t\tSET thold_alert=" . $item['thold_alert'] . ",\r\n\t\t\t\tthold_warning_fail_count={$warning_failures},\r\n\t\t\t\tthold_fail_count={$failures}\r\n\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
} else {
thold_debug('Threshold Time Based check is normal HI:' . $item['time_hi'] . ' LOW:' . $item['time_low'] . ' VALUE:' . $currentval);
if ($alertstat != 0 && $warning_failures < $warning_trigger && $item['restored_alert'] != 'on') {
if ($logset == 1) {
logger($item['name'], 'ok', 0, $currentval, $warning_trigger, $item['thold_warning_fail_count'], $url);
}
$subject = "NORMAL: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . " restored to normal threshold with value {$currentval}";
if (trim($warning_emails) != '' && $item['restored_alert'] != 'on') {
thold_mail($warning_emails, '', $subject, $msg, $file_array);
}
if (trim($warning_phones) != '' && $item['restored_alert'] != 'on') {
thold_sms($warning_phones, $subject);
}
thold_log(array('type' => 2, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => '', 'current' => $currentval, 'status' => ST_NOTIFYRS, 'description' => $subject, 'emails' => $warning_emails, 'phones' => $warning_phones));
db_execute("UPDATE thold_data\r\n\t\t\t\t\tSET thold_alert=0, thold_warning_fail_count={$warning_failures}, thold_fail_count={$failures}\r\n\t\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
} elseif ($alertstat != 0 && $failures < $trigger && $item['restored_alert'] != 'on') {
if ($logset == 1) {
logger($item['name'], 'ok', 0, $currentval, $trigger, $item['thold_fail_count'], $url);
}
$subject = "NORMAL: " . $item['name'] . ($thold_show_datasource ? " [{$name}]" : '') . " restored to warning threshold with value {$currentval}";
if (trim($alert_emails) != '' && $item['restored_alert'] != 'on') {
thold_mail($alert_emails, '', $subject, $msg, $file_array);
}
if (trim($alert_phones) != '' && $item['restored_alert'] != 'on') {
thold_sms($alert_phones, $subject);
}
thold_log(array('type' => 2, 'time' => time(), 'host_id' => $item['host_id'], 'graph_id' => $graph_id, 'threshold_id' => $item['id'], 'threshold_value' => '', 'current' => $currentval, 'status' => ST_NOTIFYRS, 'description' => $subject, 'emails' => $alert_emails, 'phones' => $alert_phones));
db_execute("UPDATE thold_data\r\n\t\t\t\t\tSET thold_alert=0, thold_warning_fail_count={$warning_failures}, thold_fail_count={$failures}\r\n\t\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
} else {
db_execute("UPDATE thold_data\r\n\t\t\t\t\tSET thold_fail_count={$failures},\r\n\t\t\t\t\tthold_warning_fail_count={$warning_failures}\r\n\t\t\t\t\tWHERE rra_id={$rra_id} AND data_id=" . $item['data_id']);
}
}
break;
}
}
function templates()
{
global $config, $thold_actions, $item_rows;
include $config['base_path'] . '/plugins/thold/includes/arrays.php';
template_request_validation();
/* if the number of rows is -1, set it to the default */
if (get_request_var('rows') == -1) {
$rows = read_config_option('num_rows_table');
} else {
$rows = get_request_var('rows');
}
html_start_box(__('Threshold Templates'), '100%', '', '3', 'center', 'thold_templates.php?action=add');
?>
<tr class='even'>
<td>
<form id='listthold' action='thold_templates.php'>
<table class='filterTable'>
<tr>
<td>
<?php
print __('Search');
?>
</td>
<td>
<input type='text' id='filter' size='25' value='<?php
print get_request_var('filter');
?>
'>
</td>
<td>
<?php
print __('Templates');
?>
</td>
<td>
<select id='rows' onChange='applyFilter()'>
<option value='-1'<?php
if (get_request_var('rows') == '-1') {
?>
selected<?php
}
?>
><?php
print __('Default');
?>
</option>
<?php
if (sizeof($item_rows)) {
foreach ($item_rows as $key => $value) {
print "<option value='" . $key . "'";
if (get_request_var('rows') == $key) {
print ' selected';
}
print '>' . $value . "</option>\n";
}
}
?>
</select>
</td>
<td>
<input id='refresh' type='button' value='<?php
print __('Go');
?>
' onClick='applyFilter()'>
</td>
<td>
<input id='clear' type='button' value='<?php
print __('Clear');
?>
' onClick='clearFilter()'>
</td>
<td>
<input id='import' type='button' value='<?php
print __('Import');
?>
' onClick='importTemplate()'>
</td>
</tr>
</table>
</form>
<script type='text/javascript'>
function applyFilter() {
strURL = 'thold_templates.php?header=false&rows=' + $('#rows').val();
strURL += '&filter=' + $('#filter').val();
loadPageNoHeader(strURL);
}
function clearFilter() {
strURL = 'thold_templates.php?header=false&clear=1';
loadPageNoHeader(strURL);
}
function importTemplate() {
strURL = 'thold_templates.php?header=false&action=import';
loadPageNoHeader(strURL);
}
$(function() {
$('#listthold').submit(function(event) {
event.preventDefault();
applyFilter();
});
});
</script>
</td>
</tr>
<?php
html_end_box();
$sql_where = '';
$limit = ' LIMIT ' . $rows * (get_request_var('page') - 1) . ',' . $rows;
$order = 'ORDER BY ' . get_request_var('sort_column') . ' ' . get_request_var('sort_direction');
if (strlen(get_request_var('filter'))) {
$sql_where .= (strlen($sql_where) ? ' AND' : 'WHERE') . " thold_template.name LIKE '%" . get_request_var('filter') . "%'";
}
$total_rows = db_fetch_cell('SELECT count(*) FROM thold_template');
$template_list = db_fetch_assoc("SELECT * FROM thold_template {$sql_where} {$order} {$limit}");
$nav = html_nav_bar('thold_templates.php?filter=' . get_request_var('filter'), MAX_DISPLAY_PAGES, get_request_var('page'), $rows, $total_rows, 10, __('Templates'), 'page', 'main');
form_start('thold_templates.php', 'chk');
print $nav;
html_start_box('', '100%', '', '3', 'center', '');
$display_text = array('name' => array(__('Name'), 'ASC'), 'data_template_name' => array(__('Data Template'), 'ASC'), 'data_source_name' => array(__('DS Name'), 'ASC'), 'thold_type' => array(__('Type'), 'ASC'), 'nosort1' => array(__('High/Up'), ''), 'nosort2' => array(__('Low/Down'), ''), 'nosort3' => array(__('Trigger'), ''), 'nosort4' => array(__('Duration'), ''), 'nosort5' => array(__('Repeat'), ''));
html_header_sort_checkbox($display_text, get_request_var('sort_column'), get_request_var('sort_direction'), false);
$i = 0;
if (sizeof($template_list)) {
foreach ($template_list as $template) {
switch ($template['thold_type']) {
case 0:
# hi/lo
$value_hi = thold_format_number($template['thold_hi']);
$value_lo = thold_format_number($template['thold_low']);
$value_trig = $template['thold_fail_trigger'];
$value_duration = '';
$value_warning_hi = thold_format_number($template['thold_warning_hi']);
$value_warning_lo = thold_format_number($template['thold_warning_low']);
$value_warning_trig = $template['thold_warning_fail_trigger'];
$value_warning_duration = '';
break;
case 1:
# baseline
$value_hi = $template['bl_pct_up'] . (strlen($template['bl_pct_up']) ? '%' : '-');
$value_lo = $template['bl_pct_down'] . (strlen($template['bl_pct_down']) ? '%' : '-');
$value_trig = $template['bl_fail_trigger'];
$step = db_fetch_cell_prepared('SELECT rrd_step
FROM data_template_data
WHERE data_template_id = ?
LIMIT 1', array($template['data_template_id']));
$value_duration = $template['bl_ref_time_range'] / $step;
break;
case 2:
#time
$value_hi = thold_format_number($template['time_hi']);
$value_lo = thold_format_number($template['time_low']);
$value_trig = $template['time_fail_trigger'];
$value_duration = $template['time_fail_length'];
break;
}
$name = $template['name'] == '' ? $template['data_template_name'] . ' [' . $template['data_source_name'] . ']' : $template['name'];
$name = filter_value($name, get_request_var('filter'));
form_alternate_row('line' . $template['id']);
form_selectable_cell('<a class="linkEditMain" href="' . htmlspecialchars('thold_templates.php?action=edit&id=' . $template['id']) . '">' . $name . '</a>', $template['id']);
form_selectable_cell(filter_value($template['data_template_name'], get_request_var('filter')), $template['id']);
form_selectable_cell($template['data_source_name'], $template['id']);
form_selectable_cell($thold_types[$template['thold_type']], $template['id']);
form_selectable_cell($value_hi, $template['id']);
form_selectable_cell($value_lo, $template['id']);
$trigger = plugin_thold_duration_convert($template['data_template_id'], $value_trig, 'alert', 'data_template_id');
form_selectable_cell(strlen($trigger) ? '<i>' . $trigger . '</i>' : '-', $template['id']);
$duration = plugin_thold_duration_convert($template['data_template_id'], $value_duration, 'time', 'data_template_id');
form_selectable_cell(strlen($duration) ? $duration : '-', $template['id']);
form_selectable_cell(plugin_thold_duration_convert($template['data_template_id'], $template['repeat_alert'], 'repeat', 'data_template_id'), $template['id']);
form_checkbox_cell($template['data_template_name'], $template['id']);
form_end_row();
}
} else {
print "<tr><td><em>" . __('No Threshold Templates') . "</em></td></tr>\n";
}
html_end_box(false);
if (sizeof($template_list)) {
print $nav;
}
/* draw the dropdown containing a list of available actions for this form */
draw_actions_dropdown($thold_actions);
form_end();
}
function list_tholds()
{
global $colors, $thold_bgcolors, $config, $hostid;
$thold_actions = array(1 => 'Delete', 2 => 'Disable', 3 => 'Enable', 4 => 'Reapply Suggested Names');
thold_request_validation();
$statefilter = '';
if (isset($_REQUEST['state'])) {
if ($_REQUEST['state'] == '-1') {
$statefilter = '';
} else {
if ($_REQUEST['state'] == '0') {
$statefilter = "thold_data.thold_enabled='off'";
}
if ($_REQUEST['state'] == '2') {
$statefilter = "thold_data.thold_enabled='on'";
}
if ($_REQUEST['state'] == '1') {
$statefilter = '(thold_data.thold_alert!=0 OR thold_data.bl_alert>0)';
}
if ($_REQUEST['state'] == '3') {
$statefilter = '((thold_data.thold_alert!=0 AND thold_data.thold_fail_count >= thold_data.thold_fail_trigger) OR (thold_data.bl_alert>0 AND thold_data.bl_fail_count >= thold_data.bl_fail_trigger))';
}
}
}
$alert_num_rows = read_config_option('alert_num_rows');
if ($alert_num_rows < 1 || $alert_num_rows > 999) {
db_execute("REPLACE INTO settings VALUES ('alert_num_rows', 30)");
/* pull it again so it updates the cache */
$alert_num_rows = read_config_option('alert_num_rows', true);
}
include $config['include_path'] . '/top_header.php';
$sql_where = '';
$sort = $_REQUEST['sort_column'];
$limit = ' LIMIT ' . $alert_num_rows * ($_REQUEST['page'] - 1) . ",{$alert_num_rows}";
if (!empty($_REQUEST['hostid']) && $_REQUEST['hostid'] != 'ALL') {
$sql_where .= (!strlen($sql_where) ? 'WHERE ' : ' AND ') . "thold_data.host_id = " . $_REQUEST['hostid'];
}
if (!empty($_REQUEST['template']) && $_REQUEST['template'] != 'ALL') {
$sql_where .= (!strlen($sql_where) ? 'WHERE ' : ' AND ') . "thold_data.data_template = " . $_REQUEST['template'];
}
if ($statefilter != '') {
$sql_where .= (!strlen($sql_where) ? 'WHERE ' : ' AND ') . "{$statefilter}";
}
/* modify for multi user start */
if ($_SESSION["permission"] < ACCESS_ADMINISTRATOR) {
$sql = "\r\n SELECT thold_data.* FROM thold_data\r\n INNER JOIN user_auth_perms ON thold_data.host_id = user_auth_perms.item_id AND user_auth_perms.user_id = '" . $_SESSION["sess_user_id"] . "' AND user_auth_perms.type = '3'\r\n {$sql_where}\r\n ORDER BY {$sort} " . $_REQUEST['sort_direction'] . $limit;
} else {
$current_user = db_fetch_row('SELECT * FROM user_auth WHERE id=' . $_SESSION['sess_user_id']);
$sql_where .= (!strlen($sql_where) ? 'WHERE ' : ' AND ') . get_graph_permissions_sql($current_user['policy_graphs'], $current_user['policy_hosts'], $current_user['policy_graph_templates']);
$sql = "SELECT * FROM thold_data\r\n\t\tLEFT JOIN user_auth_perms on ((thold_data.graph_id=user_auth_perms.item_id and user_auth_perms.type=1 and user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ") OR (thold_data.host_id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ") OR (thold_data.graph_template=user_auth_perms.item_id and user_auth_perms.type=4 and user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . "))\r\n\t\t{$sql_where}\r\n\t\tORDER BY {$sort} " . $_REQUEST['sort_direction'] . $limit;
}
/* modify for multi user end */
$result = db_fetch_assoc($sql);
/* modify for multi user start */
if ($_SESSION["permission"] < ACCESS_ADMINISTRATOR) {
$hostresult = db_fetch_assoc("\r\n SELECT host.id, host.description, host.hostname FROM host \r\n INNER JOIN thold_data ON host.id = thold_data.host_id \r\n INNER JOIN user_auth_perms ON host.id = user_auth_perms.item_id AND user_auth_perms.user_id = '" . $_SESSION["sess_user_id"] . "' AND user_auth_perms.type = '3'");
$data_templates = db_fetch_assoc("\r\n SELECT DISTINCT data_template.id, data_template.name FROM data_template\r\n INNER JOIN thold_data ON thold_data.data_template = data_template.id\r\n INNER JOIN host ON thold_data.host_id = host.id\r\n INNER JOIN user_auth_perms ON host.id = user_auth_perms.item_id AND user_auth_perms.user_id = '" . $_SESSION["sess_user_id"] . "' AND user_auth_perms.type = '3'\r\n ORDER BY data_template.name");
} else {
$sql_where_hid = 'WHERE ' . get_graph_permissions_sql($current_user['policy_graphs'], $current_user['policy_hosts'], $current_user['policy_graph_templates']);
$hostresult = db_fetch_assoc("SELECT DISTINCT host.id, host.description, host.hostname\r\n\t\tFROM host\r\n\t\tINNER JOIN thold_data ON (host.id = thold_data.host_id)\r\n\t\tLEFT JOIN user_auth_perms on (thold_data.host_id=user_auth_perms.item_id and user_auth_perms.type=3 and user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ")\r\n\t\t{$sql_where_hid}\r\n\t\tORDER BY description");
$data_templates = db_fetch_assoc("SELECT DISTINCT data_template.id, data_template.name\r\n\t\tFROM data_template\r\n\t\tINNER JOIN thold_data ON (thold_data.data_template = data_template.id)\r\n\t\tORDER BY data_template.name");
}
/* modify for multi user end */
?>
<script type="text/javascript">
<!--
function applyTHoldFilterChange(objForm) {
strURL = '?hostid=' + objForm.hostid.value;
strURL = strURL + '&state=' + objForm.state.value;
strURL = strURL + '&template=' + objForm.template.value;
document.location = strURL;
}
-->
</script>
<?php
/* modify for multi user start */
if (check_resource_count(RESOURCE_THOLD) == TRUE) {
html_start_box('<strong>Threshold Management</strong>', '100%', $colors['header'], '3', 'center', 'thold_add.php');
} else {
html_start_box('<strong>Threshold Management</strong>', '100%', $colors['header'], '3', 'center', '');
}
/* modify for multi user end */
?>
<tr bgcolor='#<?php
print $colors["panel"];
?>
' class='noprint'>
<td class='noprint'>
<form name='listthold' action='listthold.php' method='post'>
<table cellpadding='0' cellspacing='0'>
<tr class='noprint'>
<td width='1'>
Host:
</td>
<td width='1'>
<select name='hostid' onChange='applyTHoldFilterChange(document.listthold)'>
<option value='ALL'>Any</option>
<?php
foreach ($hostresult as $row) {
echo "<option value='" . $row['id'] . "'" . (isset($_REQUEST['hostid']) && $row['id'] == $_REQUEST['hostid'] ? ' selected' : '') . '>' . $row['description'] . ' - (' . $row['hostname'] . ')' . '</option>';
}
?>
</select>
</td>
<td width='1'>
Template:
</td>
<td width='1'>
<select name='template' onChange='applyTHoldFilterChange(document.listthold)'>
<option value='ALL'>Any</option>
<?php
foreach ($data_templates as $row) {
echo "<option value='" . $row['id'] . "'" . (isset($_REQUEST['template']) && $row['id'] == $_REQUEST['template'] ? ' selected' : '') . '>' . $row['name'] . '</option>';
}
?>
</select>
</td>
<td width='1'>
State:
</td>
<td width='1'>
<select name='state' onChange='applyTHoldFilterChange(document.listthold)'>
<option value='-1'<?php
if ($_REQUEST["state"] == "-1") {
?>
selected<?php
}
?>
>All</option>
<option value='1'<?php
if ($_REQUEST["state"] == "1") {
?>
selected<?php
}
?>
>Breached</option>
<option value='3'<?php
if ($_REQUEST["state"] == "3") {
?>
selected<?php
}
?>
>Triggered</option>
<option value='2'<?php
if ($_REQUEST["state"] == "2") {
?>
selected<?php
}
?>
>Enabled</option>
<option value='0'<?php
if ($_REQUEST["state"] == "0") {
?>
selected<?php
}
?>
>Disabled</option>
</select>
</td>
<td nowrap style='white-space: nowrap;'>
<input type='submit' name='clear' value='Clear' title='Return to Defaults'>
</td>
</tr>
</table>
<input type='hidden' name='search' value='search'>
</form>
</td>
</tr>
<?php
html_end_box();
define('MAX_DISPLAY_PAGES', 21);
/* modify for multi user start */
if ($_SESSION["permission"] < ACCESS_ADMINISTRATOR) {
$total_rows = db_fetch_cell("\r\n SELECT COUNT(thold_data.id) FROM thold_data\r\n INNER JOIN user_auth_perms ON thold_data.host_id = user_auth_perms.item_id AND user_auth_perms.user_id = '" . $_SESSION["sess_user_id"] . "' AND user_auth_perms.type = '3'\r\n {$sql_where}");
} else {
$total_rows = count(db_fetch_assoc("SELECT thold_data.id\r\n\t\tFROM thold_data\r\n\t\tLEFT JOIN user_auth_perms\r\n\t\tON ((thold_data.graph_id=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=1\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ")\r\n\t\tOR (thold_data.host_id=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=3\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . ")\r\n\t\tOR (thold_data.graph_template=user_auth_perms.item_id\r\n\t\tAND user_auth_perms.type=4\r\n\t\tAND user_auth_perms.user_id=" . $_SESSION['sess_user_id'] . "))\r\n\t\t{$sql_where}"));
}
/* modify for multi user end */
$url_page_select = get_page_list($_REQUEST['page'], MAX_DISPLAY_PAGES, $alert_num_rows, $total_rows, 'listthold.php?');
/* print checkbox form for validation */
print "<form name='chk' method='post' action='listthold.php'>\n";
html_start_box('', '100%', $colors['header'], '4', 'center', '');
if ($total_rows) {
$nav = "<tr bgcolor='#" . $colors['header'] . "'>\r\n\t\t\t\t<td colspan='12'>\r\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td align='left' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\t<strong><< ";
if ($_REQUEST["page"] > 1) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("listthold.php?page=" . ($_REQUEST["page"] - 1)) . "'>";
}
$nav .= "Previous";
if ($_REQUEST["page"] > 1) {
$nav .= "</a>";
}
$nav .= "</strong>\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\tShowing Rows " . ($alert_num_rows * ($_REQUEST["page"] - 1) + 1) . " to " . ($total_rows < $alert_num_rows || $total_rows < $alert_num_rows * $_REQUEST["page"] ? $total_rows : $alert_num_rows * $_REQUEST["page"]) . " of {$total_rows} [{$url_page_select}]\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t\t<td align='right' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\t<strong>";
if ($_REQUEST["page"] * $alert_num_rows < $total_rows) {
$nav .= "<a class='linkOverDark' href='" . htmlspecialchars("listthold.php?page=" . ($_REQUEST["page"] + 1)) . "'>";
}
$nav .= "Next";
if ($_REQUEST["page"] * $alert_num_rows < $total_rows) {
$nav .= "</a>";
}
$nav .= " >></strong>\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\n";
} else {
$nav = "<tr bgcolor='#" . $colors['header'] . "'>\r\n\t\t\t\t<td colspan='12'>\r\n\t\t\t\t\t<table width='100%' cellspacing='0' cellpadding='0' border='0'>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td align='center' class='textHeaderDark'>\r\n\t\t\t\t\t\t\t\tNo Rows Found\r\n\t\t\t\t\t\t\t</td>\n\r\n\t\t\t\t\t\t</tr>\r\n\t\t\t\t\t</table>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\n";
}
print $nav;
$display_text = array('name' => array('Name', 'ASC'), 'thold_type' => array('Type', 'ASC'), 'thold_hi' => array('High', 'ASC'), 'thold_low' => array('Low', 'ASC'), 'nosort3' => array('Trigger', ''), 'nosort4' => array('Duration', ''), 'repeat_alert' => array('Repeat', 'ASC'), 'lastread' => array('Current', 'ASC'), 'thold_alert' => array('Triggered', 'ASC'), 'thold_enabled' => array('Enabled', 'ASC'));
html_header_sort_checkbox($display_text, $_REQUEST['sort_column'], $_REQUEST['sort_direction'], false);
$timearray = array(1 => '5 Minutes', 2 => '10 Minutes', 3 => '15 Minutes', 4 => '20 Minutes', 6 => '30 Minutes', 8 => '45 Minutes', 12 => 'Hour', 24 => '2 Hours', 36 => '3 Hours', 48 => '4 Hours', 72 => '6 Hours', 96 => '8 Hours', 144 => '12 Hours', 288 => '1 Day', 576 => '2 Days', 2016 => '1 Week', 4032 => '2 Weeks', 8640 => '1 Month');
$c = 0;
$i = 0;
$types = array('High/Low', 'Baseline Deviation', 'Time Based');
if (count($result)) {
foreach ($result as $row) {
$c++;
$grapharr = db_fetch_row('SELECT DISTINCT graph_templates_item.local_graph_id
FROM graph_templates_item, data_template_rrd
WHERE (data_template_rrd.local_data_id=' . $row['rra_id'] . ' AND data_template_rrd.id=graph_templates_item.task_item_id)');
$graph_id = $grapharr['local_graph_id'];
$alertstat = 'no';
$bgcolor = 'green';
if ($row['thold_type'] == 0) {
if ($row['thold_alert'] != 0) {
$alertstat = 'yes';
if ($row['thold_fail_count'] >= $row['thold_fail_trigger']) {
$bgcolor = 'red';
} elseif ($row['thold_warning_fail_count'] >= $row['thold_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} elseif ($row['thold_type'] == 2) {
if ($row['thold_alert'] != 0) {
$alertstat = 'yes';
if ($row['thold_fail_count'] >= $row['time_fail_trigger']) {
$bgcolor = 'red';
} elseif ($row['thold_warning_fail_count'] >= $row['time_warning_fail_trigger']) {
$bgcolor = 'warning';
} else {
$bgcolor = 'yellow';
}
}
} else {
if ($row['bl_alert'] == 1) {
$alertstat = 'baseline-LOW';
$bgcolor = $row['bl_fail_count'] >= $row['bl_fail_trigger'] ? 'orange' : 'yellow';
} elseif ($row['bl_alert'] == 2) {
$alertstat = 'baseline-HIGH';
$bgcolor = $row['bl_fail_count'] >= $row['bl_fail_trigger'] ? 'orange' : 'yellow';
}
}
if ($row['thold_enabled'] == 'off') {
form_alternate_row_color($thold_bgcolors['grey'], $thold_bgcolors['grey'], $i, 'line' . $row["id"]);
$i++;
} else {
form_alternate_row_color($thold_bgcolors[$bgcolor], $thold_bgcolors[$bgcolor], $i, 'line' . $row["id"]);
$i++;
}
form_selectable_cell("<a class='linkEditMain' href='" . htmlspecialchars("thold.php?rra=" . $row['rra_id'] . "&view_rrd=" . $row['data_id']) . "'>" . ($row['name'] != '' ? $row['name'] : $row['name_cache'] . " [" . $row['data_source_name'] . ']') . '</a>', $row['id']);
form_selectable_cell($types[$row['thold_type']], $row["id"]);
switch ($row['thold_type']) {
case 0:
form_selectable_cell(thold_format_number($row['thold_hi']), $row["id"]);
form_selectable_cell(thold_format_number($row['thold_low']), $row["id"]);
form_selectable_cell("<i>" . plugin_thold_duration_convert($row['rra_id'], $row['thold_fail_trigger'], 'alert') . "</i>", $row["id"]);
form_selectable_cell("", $row["id"]);
break;
case 1:
form_selectable_cell(thold_format_number($row['thold_hi']), $row["id"]);
form_selectable_cell(thold_format_number($row['thold_low']), $row["id"]);
form_selectable_cell("<i>" . plugin_thold_duration_convert($row['rra_id'], $row['bl_fail_trigger'], 'alert') . "</i>", $row["id"]);
form_selectable_cell($timearray[$row['bl_ref_time_range'] / 300], $row["id"]);
break;
case 2:
form_selectable_cell(thold_format_number($row['time_hi']), $row["id"]);
form_selectable_cell(thold_format_number($row['time_low']), $row["id"]);
form_selectable_cell("<i>" . $row['time_fail_trigger'] . " Triggers</i>", $row["id"]);
form_selectable_cell(plugin_thold_duration_convert($row['rra_id'], $row['time_fail_length'], 'time'), $row["id"]);
break;
default:
form_selectable_cell("", $row["id"]);
form_selectable_cell("", $row["id"]);
form_selectable_cell("", $row["id"]);
form_selectable_cell("", $row["id"]);
}
form_selectable_cell($row['repeat_alert'] == '' ? '' : plugin_thold_duration_convert($row['rra_id'], $row['repeat_alert'], 'repeat'), $row["id"]);
form_selectable_cell(thold_format_number($row['lastread']), $row["id"]);
form_selectable_cell($alertstat, $row["id"]);
form_selectable_cell($row['thold_enabled'] == 'off' ? "Disabled" : "Enabled", $row["id"]);
form_checkbox_cell($row['name'], $row['id']);
form_end_row();
}
} else {
form_alternate_row_color($colors['alternate'], $colors['light'], 0);
print '<td colspan=12><center>No Thresholds</center></td></tr>';
}
print $nav;
html_end_box(false);
thold_legend();
draw_actions_dropdown($thold_actions);
if (isset($hostid) && $hostid != '') {
print "<input type=hidden name=hostid value={$hostid}>";
}
print "</form>\n";
include_once $config['include_path'] . '/bottom_footer.php';
}
function get_thold_warning_text($name, $thold, $h, $currentval, $local_graph_id)
{
global $thold_types;
$warning_text = read_config_option('thold_warning_text');
$httpurl = read_config_option('base_url');
/* make sure the warning text has been set */
if (!isset($warning_text) || $warning_text == '') {
$warning_text = __('<html><body>A warning has been issued that requires your attention.<br><br><b>Device</b>: <DESCRIPTION> (<HOSTNAME>)<br><b>URL</b>: <URL><br><b>Message</b>: <SUBJECT><br><br><GRAPH></body></html>');
}
// Do some replacement of variables
$warning_text = str_replace('<DESCRIPTION>', $h['description'], $warning_text);
$warning_text = str_replace('<HOSTNAME>', $h['hostname'], $warning_text);
$warning_text = str_replace('<TIME>', time(), $warning_text);
$warning_text = str_replace('<GRAPHID>', $local_graph_id, $warning_text);
$warning_text = str_replace('<CURRENTVALUE>', $currentval, $warning_text);
$warning_text = str_replace('<THRESHOLDNAME>', $thold['name'], $warning_text);
$warning_text = str_replace('<DSNAME>', $name, $warning_text);
$warning_text = str_replace('<THOLDTYPE>', $thold_types[$thold['thold_type']], $warning_text);
if ($thold['thold_type'] == 0) {
$warning_text = str_replace('<HI>', $thold['thold_hi'], $warning_text);
$warning_text = str_replace('<LOW>', $thold['thold_low'], $warning_text);
$warning_text = str_replace('<TRIGGER>', $thold['thold_warning_fail_trigger'], $warning_text);
$warning_text = str_replace('<DURATION>', '', $warning_text);
} elseif ($thold['thold_type'] == 2) {
$warning_text = str_replace('<HI>', $thold['time_warning_hi'], $warning_text);
$warning_text = str_replace('<LOW>', $thold['time_warning_low'], $warning_text);
$warning_text = str_replace('<TRIGGER>', $thold['time_warning_fail_trigger'], $warning_text);
$warning_text = str_replace('<DURATION>', plugin_thold_duration_convert($thold['local_data_id'], $thold['time_warning_fail_length'], 'time'), $warning_text);
} else {
$warning_text = str_replace('<HI>', '', $warning_text);
$warning_text = str_replace('<LOW>', '', $warning_text);
$warning_text = str_replace('<TRIGGER>', '', $warning_text);
$warning_text = str_replace('<DURATION>', '', $warning_text);
}
$warning_text = str_replace('<DATE_RFC822>', date(DATE_RFC822), $warning_text);
$warning_text = str_replace('<DEVICENOTE>', $h['notes'], $warning_text);
$warning_text = str_replace('<URL>', "<a href='" . htmlspecialchars("{$httpurl}/graph.php?local_graph_id={$local_graph_id}&rra_id=1") . "'>{$httpurl}/graph.php?local_graph_id={$local_graph_id}&rra_id=1</a>", $warning_text);
return $warning_text;
}
