CISCO 857 GET SNMP DSL STATS
Cisco 857 mib info needed :
attenuationoid=1.3.6.1.2.1.10.94.1.1.3.1.5.12
downsnroid=1.3.6.1.2.1.10.94.1.1.3.1.4.12
downloadrateoid=1.3.6.1.2.1.10.94.1.1.4.1.2.12
uploadrateoid=1.3.6.1.2.1.10.94.1.1.5.1.2.12
!
!
GET SNMP DSL STATS
getstats.sh
#!/bin/bash
#Ash Salman
#OIDS (From Cisco ADSL-MIB)
attenuationoid=1.3.6.1.2.1.10.94.1.1.3.1.5.12
downsnroid=1.3.6.1.2.1.10.94.1.1.3.1.4.12
downloadrateoid=1.3.6.1.2.1.10.94.1.1.4.1.2.12
uploadrateoid=1.3.6.1.2.1.10.94.1.1.5.1.2.12
#Community String
community=rocaww
#Prepare CSV
if [ -a results.csv ]
then
echo “File exists… Removing and preparing CSV headers”
rm results.csv
else echo “Preparing CSV headers”
fi
echo Name,Attenuation,Downstream_SNR,Downstream_Sync,Upload_Sync > results.csv
#Get Statistics
echo “Reading sites from name-ip-map.txt”
while read name ip; do
echo “Processing $name…”
attenuation=`snmpget -v2c -Oqv -c $community $ip $attenuationoid`
downsnr=`snmpget -v2c -Oqv -c $community $ip $downsnroid`
downrate=`snmpget -v2c -Oqv -c $community $ip $downloadrateoid`
uploadrate=`snmpget -v2c -Oqv -c $community $ip $uploadrateoid`
echo $name,$attenuation,$downsnr,$downrate,$uploadrate >> results.csv
done < name-ip-map.txt
!
!
Name and Public ip addresses of remote sites to run script based on :
name-ip-map.txt
RATHBONE01 85.234.87.193
RATHBONE02 85.234.87.194
RATHBONE03 85.234.87.195
RATHBONE04 85.234.87.196
RATHBONE05 85.234.87.197
RATHBONE06 85.234.87.198
RATHBONE07 85.234.87.199
RATHBONE08 85.234.87.200
RATHBONE09 85.234.87.201
RATHBONE10 85.234.87.202
!
!
results.csv
Name,Attenuation,Downstream_SNR,Downstream_Sync,Upload_Sync
RATHBONE01,60,135,8128000,864000
RATHBONE02,200,145,8128000,832000
RATHBONE03,135,40,4512000,448000
RATHBONE04,185,140,6848000,800000
RATHBONE05,290,155,7040000,800000
RATHBONE06,320,180,6656000,832000
RATHBONE07,135,150,8128000,864000
RATHBONE08,140,150,8128000,832000
RATHBONE09,325,85,8064000,864000
RATHBONE10,390,80,6432000,800000
!
!
copy & paste the results from the results.csv file into an excel spreadsheet.