diff options
| author | Kristian Lyngstol <kristian@bohemians.org> | 2015-04-17 07:20:28 +0200 |
|---|---|---|
| committer | Kristian Lyngstol <kristian@bohemians.org> | 2015-04-17 07:20:28 +0200 |
| commit | ecd8bc78d9014e61251965883244757f5cf208ba (patch) | |
| tree | 06cb686f117a6480506bbeced7394ae1dd79f6c2 /web/nms.gathering.org/port-state.pl | |
| parent | 4d1a5246e38058a469d9fea49cebd95c36422e8b (diff) | |
NMS: Split things into multiple files and tweaks
Diffstat (limited to 'web/nms.gathering.org/port-state.pl')
| -rwxr-xr-x | web/nms.gathering.org/port-state.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/web/nms.gathering.org/port-state.pl b/web/nms.gathering.org/port-state.pl index 014486b..ee0fb2c 100755 --- a/web/nms.gathering.org/port-state.pl +++ b/web/nms.gathering.org/port-state.pl @@ -21,7 +21,7 @@ my $when =" time > " . $now . " - '5m'::interval and time < " . $now . " "; my %json = (); if (defined($cin)) { - $when = " time < " . $now . " - '$cin'::interval and time > ". $now . " - ('$cin'::interval + '15m'::interval) "; + $when = " time < " . $now . " - '$cin'::interval and time > ". $now . " - ('$cin'::interval + '5m'::interval) "; } my $query = 'select sysname,extract(epoch from date_trunc(\'second\',time)) as time, ifname,ifhighspeed,ifhcinoctets,ifhcoutoctets from polls natural join switches where time in (select max(time) from polls where ' . $when . ' group by switch,ifname);'; |