Reprocesses an Avamar replication report to remove recently backed up clients and show unreplicated historical data over x days.

ava_repl_clean_report.awk

#!/usr/bin/awk -f
# remove unreplicated avamar clients from the replreport
#   that are less than a day or so old. 
# useful in cases where you have a day to get data offsite 
#  and only want to see older unreplicated clients.
# 
BEGIN {printf "%-63s %s     %s\n","Client","Difference","Dest Total"}

        /^[A=]/ {next};
        /^SOURCE/ {sgrid=$2};
        /^DESTINATION/ {dgrid=$2};
        int($4)<-7 {++unsynced; printf "%-70s %s     %s\n", $1, $4, $3};
        /^Clients\ checked/ {clients=$3}
END {print "\n "unsynced" clients are unsynced out of "clients" for a total of "unsynced/clients*100" percent unsynced between "sgrid" and "dgrid"\n"