diff options
Diffstat (limited to 'web/nms.gathering.org/aggregated_traffic.pl')
| -rwxr-xr-x | web/nms.gathering.org/aggregated_traffic.pl | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/web/nms.gathering.org/aggregated_traffic.pl b/web/nms.gathering.org/aggregated_traffic.pl index 5c78e73..e2f3d97 100755 --- a/web/nms.gathering.org/aggregated_traffic.pl +++ b/web/nms.gathering.org/aggregated_traffic.pl @@ -12,7 +12,7 @@ my $cgi = CGI->new; print $cgi->header(-type=>'text/json', -expires=>'now'); -my $q = $dbh->prepare('select sum(n1.sum_in) as sum_in, sum(n1.sum_out) as sum_out from (select sum(ifInoctets) as sum_in, sum(ifOutoctets) as sum_out from polls2 where time >= now() - \'15 minutes\'::interval group by switch) as n1'); +my $q = $dbh->prepare('select sum(n1.sum_in) as sum_in, sum(n1.sum_out) as sum_out from (select sum(ifhcinoctets) as sum_in, sum(ifhcoutoctets) as sum_out from polls where time >= now() - \'15 minutes\'::interval group by switch) as n1'); $q->execute(); while (my $ref = $q->fetchrow_hashref()) { my $bitsface = $ref->{'sum_in'}/900/8; |