1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
|
<?php
/*
** ZABBIX
** Copyright (C) 2000-2005 SIA Zabbix
**
** This program is free software; you can redistribute it and/or modify
** it under the terms of the GNU General Public License as published by
** the Free Software Foundation; either version 2 of the License, or
** (at your option) any later version.
**
** This program is distributed in the hope that it will be useful,
** but WITHOUT ANY WARRANTY; without even the implied warranty of
** MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
** GNU General Public License for more details.
**
** You should have received a copy of the GNU General Public License
** along with this program; if not, write to the Free Software
** Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.
**/
?>
<?php
include "include/config.inc.php";
$page["title"] = "S_TRIGGERS_TOP_100";
$page["file"] = "report5.php";
show_header($page["title"],0,0);
?>
<?php
// if(!check_right("Host","R",0))
// {
// show_table_header("<font color=\"AA0000\">No permissions !</font>");
// show_page_footer();
// exit;
// }
?>
<?php
if(!isset($_REQUEST["period"]))
{
$_REQUEST["period"]="day";
}
$h1=S_TRIGGERS_TOP_100_BIG;
$year=date("Y");
$h2=SPACE.S_LAST.SPACE;
$h2=$h2."<select class=\"biginput\" name=\"period\" onChange=\"submit()\">";
$h2=$h2.form_select("period","day",S_DAY);
$h2=$h2.form_select("period","week",S_WEEK);
$h2=$h2.form_select("period","month",S_MONTH);
$h2=$h2.form_select("period","year",S_YEAR);
$h2=$h2."</select>";
show_header2($h1, $h2, "<form name=\"selection\" method=\"get\" action=\"report5.php\">", "</form>");
?>
<?php
$table = new CTableInfo();
$table->setHeader(array(S_HOST,S_TRIGGER,S_SEVERITY,S_NUMBER_OF_STATUS_CHANGES));
$time_now=time();
if($_REQUEST["period"]=="day")
{
$time_dif=24*3600;
}
elseif($_REQUEST["period"]=="week")
{
$time_dif=7*24*3600;
}
elseif($_REQUEST["period"]=="month")
{
$time_dif=30*24*3600;
}
elseif($_REQUEST["period"]=="year")
{
$time_dif=365*24*3600;
}
$result=DBselect("select h.host, t.triggerid, t.description, t.priority, count(a.alarmid)
from hosts h, triggers t, functions f, items i, alarms a where
h.hostid = i.hostid and
i.itemid = f.itemid and
t.triggerid=f.triggerid and
t.triggerid=a.triggerid and
a.clock>$time_now-$time_dif
group by h.host,t.triggerid,t.description,t.priority
order by 5 desc,1,3", 100);
while($row=DBfetch($result))
{
$priority_style=NULL;
if($row["priority"]==0) $priority=S_NOT_CLASSIFIED;
elseif($row["priority"]==1) $priority=S_INFORMATION;
elseif($row["priority"]==2) $priority=S_WARNING;
elseif($row["priority"]==3)
{
$priority=S_AVERAGE;
$priority_style="average";
}
elseif($row["priority"]==4)
{
$priority=S_HIGH;
$priority_style="high";
}
elseif($row["priority"]==5)
{
$priority=S_DISASTER;
$priority_style="disaster";
}
else $priority=$row["priority"];
$severity=new CSpan($priority,$priority_style);
$table->addRow(array(
$row["host"],
expand_trigger_description($row["triggerid"]),
new CCol($priority,$priority_style),
$row["count(a.alarmid)"],
));
}
$table->show();
show_page_footer();
?>
|
