Cacti流量数据提取与统计脚本

crontab 定时运行rrd_tool 提取流量
59 23 * * * /root/cacti_traffic_bak/fetch.sh /var/www/html/cacti/rra/103_235_229_129_traffic_in_303.rrd /root/cacti_traffic_bak/bak1
59 23 * * * /root/cacti_traffic_bak/fetch.sh /var/www/html/cacti/rra/103_235_229_129_traffic_in_306.rrd /root/cacti_traffic_bak/bak2

rrd_tools  提取流量M:
#!/bin/bash
#author zhoushuangxue
#fetch the day trraffic from rra to a txt file
#date 2019/7/24

#the fetch result write to the file
output_filename=`date +%Y-%m-%d`.txt
#the result file folder
file_folder="/root/default/"

if [[ $# < 2 ]]; then
        echo  """usage: fetch rra_filename the_flode_the_fetch_result_to_store
    example: fetch /var/www/html/cacti/rra/103_235_229_129_traffic_in_296.rrd /root/result
        """
else
        file_folder=$2
        if [[ ! -d $file_folder ]]; then
                mkdir $file_folder
        fi
        absolute_output_filename=${file_folder}/${output_filename}
        if [[ ! -e ${absolute_output_filename} ]]; then
                rrdtool fetch $1 AVERAGE -s `date -d '1 days ago' +%s` -e $((`date +%s`-301))\
| awk -F':' '{if(NR>2){print $1,$2}}'\
| awk 'BEGIN{count=0;printf "%-10s %-9s %-10s %-10s \n","date","time","INBOUND(M)","OUTBOUND(M)"};\
{s[count]=$1;inbound[count]=$2;out[count]=$3;count++};\