#!/bin/sh
# replace with your POOLS and with your DATALISTS
DATALISTS="DATA1 \
DATA2 \
DATA3 \
DATA4 \
DATA5 \
DATA6 \
DATA7 \
DATA8 \
DATA9 \
DATA10 \
DATA11 \
DATA12 \
DATA13 \
DATA14 \
DATA15 \
DATA16 \
DATA17 \
DATA18 \
DATA19 \
DATA20 \
DATA21"
POOL_DB="DB_1 DB_2"
POOL_DB_SVIL="DB-SVIL"
POOL_IDB="IDB"
POOL_ARCH_FILE="ARCH_FILE"
POOL_POOL1_LTO2="DATA10 \
DATA11 \
DATA12 \
DATA13 \
DATA14 \
DATA15 \
DATA16 \
DATA17 \
DATA18 \
DATA19 \
DATA20 \
DATA21"
POOL_CVS="CVS"
POOL_POOL2_LTO2="DATA1 \
DATA2 \
DATA3 \
DATA4 \
DATA5 \
DATA6 \
DATA7 \
DATA8 \
DATA9"
LUNEDI=`date +%a`
# se oggi e' lunedi bisogna includere OS-PRODUX , IAS_APP1 e WEBLOG
if [ "$LUNEDI" = "Mon" ]
then
POOL_POOL1_LTO2="DATA10 \
DATA11 \
DATA12 \
DATA13 \
DATA14 \
DATA15 \
DATA16 \
DATA17 \
DATA18 \
DATA19 \
DATA20 \
DATA21"
POOL_POOL2_LTO2="DATA1 \
DATA2 \
DATA3 \
DATA4 \
DATA5 \
DATA6 \
DATA7 \
DATA8 \
DATA9"
else
POOL_POOL1_LTO2="DATA10 \
DATA11 \
DATA12 \
DATA13 \
DATA14 \
DATA15 \
DATA16 \
DATA17 \
DATA18 \
DATA19 \
DATA20 \
DATA21 \
DATA20-SETT \
DATA21-SETT"
POOL_POOL2_LTO2="DATA1 \
DATA2 \
DATA3 \
DATA4 \
DATA5 \
DATA6 \
DATA7 \
DATA8 \
DATA9 \
DATA1-SETT \
DATA2-SETT"
fi
cat /dev/null > /tmp/media.tmp
cat /dev/null > /usr/local/log/media.log
cat /dev/null > /tmp/uniq.tmp
case $1 in
DB)
THIS=${POOL_DB}
;;
DB_SVIL)
THIS=${POOL_DB_SVIL}
;;
IDB)
THIS=${POOL_IDB}
;;
ARCH_FILE)
THIS=${POOL_ARCH_FILE}
;;
POOL1_LTO2)
THIS=${POOL_POOL1_LTO2}
;;
CVS)
THIS=${POOL_CVS}
;;
POOL2_LTO2)
THIS=${POOL_POOL2_LTO2}
;;
*)
echo "Il POOL $1 non esiste!"
esac
LOGFILE=/usr/local/log/media.log
exec 2>&1 > $LOGFILE
echo `date`": Media utilizzati da $1\n"
for i in $THIS
do
/opt/omni/bin/omnidb -session -datalist $i -latest |tail -1 | awk '{print $1}' >> /tmp/media.tmp
##|tee -a /tmp/media.tmp
done
for z in `cat /tmp/media.tmp`
do
/opt/omni/bin/omnidb -session $z -media|grep -v "==" |grep -v "Label" >> /tmp/uniq.tmp
done
cat /tmp/uniq.tmp |sort|uniq
/usr/bin/mailx -s "Media $1" > $LOGFILE datamoving@mydomain
cat $LOGFILE >> /usr/local/log/media.set
# nel file /usr/local/log/media.set ci sono i nastri utilizzati della settimana