#!/bin/ksh
#
# script que retorna a media de tempo consumido pelas politicas do netbackup
# ex:   relatorio_elapses.sh 240
# ira retornar a media de tempo que as politicas ficaram em estado active durante as ultimas 240 horas


BPPATH=/usr/openv/netbackup/bin/admincmd
DBPATH=/usr/openv/netbackup/db

HOURSAGO=$1
sumtot=0

echo "Politica                                    Media (seg)"
# Listando politicas
 
ls -1 $DBPATH/class |
 while read politica
 do

    # Calculando soma em segundos
     sumEL=0
     media=0
     /opt/openv/netbackup/bin/admincmd/bpimagelist -A -L -policy $politica -hoursago $1 2>/dev/null | grep "^Elapsed" | cut -d: -f2| cut -ds -f1|
        while read txt EL
        do
        let media=${media}+1  
	let sumEL=${sumEL}+${txt}
        done # Soma em segundos


resp=0
if [ $sumEL -gt 0 ]; then
let resp=${sumEL}/${media}
fi

printf "%-45s %6s \n" $politica $resp
done # lendo politicas