Make maps use new SQL schema

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;