maniu@securebrain.com:~/dataprotector# vi media.sh



#!/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




:q!