aboutsummaryrefslogtreecommitdiffstats
path: root/clients/snmpfetchng.pl
diff options
context:
space:
mode:
authorKristian Lyngstol <kly@kly.no>2016-03-17 21:42:19 +0000
committerKristian Lyngstol <kly@kly.no>2016-03-17 21:42:19 +0000
commit2a5cbfe5fa9930b3ac72a618e956a14878e20043 (patch)
tree5f37bc98ed2f3db7204a6da02a9ed28c176e3d79 /clients/snmpfetchng.pl
parent8eb1b43ce136e808fbd90aeb11eecd03eaa821d8 (diff)
NMS: Strip netmask from management ips where relevant
Diffstat (limited to 'clients/snmpfetchng.pl')
-rwxr-xr-xclients/snmpfetchng.pl2
1 files changed, 1 insertions, 1 deletions
diff --git a/clients/snmpfetchng.pl b/clients/snmpfetchng.pl
index 68baddd..0a52af0 100755
--- a/clients/snmpfetchng.pl
+++ b/clients/snmpfetchng.pl
@@ -29,7 +29,7 @@ EOF
# Borrowed from snmpfetch.pl
our $qswitch = $dbh->prepare(<<"EOF")
SELECT
- *,
+ sysname,switch,host(ip) as ip,community,
DATE_TRUNC('second', now() - last_updated - poll_frequency) AS overdue
FROM
switches