Bashscripts.org

#!/bin/bash

snmpget -v 1 xx.xx.xx.xx -c public ifInOctets.1 |cut -b34-70 >/var/www/html/stats/1.in
snmpget -v 1 xx.xx.xx.xx -c public ifOutOctets.1 |cut -b37-70 >/var/www/html/stats/1.out
snmpget -v 1 xx.xx.xx.xx -c public ifMtu.1 |cut -b28-70 >/var/www/html/stats/1.mtu
snmpget -v 1 xx.xx.xx.xx -c public ifOperStatus.1 |cut -b35-70 >/var/www/html/stats/1.status
snmpget -v 1 xx.xx.xx.xx -c public ifLastChange.1 |cut -b36-70 >/var/www/html/stats/1.change
chmod 755 /var/www/html/stats/1.out
chmod 755 /var/www/html/stats/1.in
chmod 755 /var/www/html/stats/1.mtu
chmod 755 /var/www/html/stats/1.status
chmod 755 /var/www/html/stats/1.change

this block repeats 24 time till .24

## the snmp stuff
If=( InOctets OutOctets Mtu OperStatus LastChange )
Of=( in out mtu status change )

for (( i=1; i<=24; i++ ))
do
   for item in ${If[@]}
    do
      snmpget -v 1 xx.xx.xx.xx -c public if${If[item]}.$i | cut -b34-70 > \
/var/www/html/stats/${i}.${Of[ind++]}
   done
unset ind
done

chmod 755 /var/www/html/stats/{1..24}.{in,out,mtu,status,change}

## the sql stuff
for file in /var/www/html/stats/{1..24}.{in,out,mtu,status,change}
do
   while read line
    do
    # something like that:
      mysql -u User -h Host -D Database -p Pass \
-e 'INSERT INTO TABLE your_Table (column) VALUES('"$i"')'
   done < $file
done