Media images Expiring in One week

[wizard_s32]

Hi,

What is the command to see media images expiring for next 1 week so that i can expire them in advance with bpexpdate command so that i can make some scratch available 

Tia 

[Marianne · Accepted solution]

Try this report from the GUI or from cmd:

bpmedialist -summary

PLEASE use the media shortage as motivation to purchase more media - there's normally a valid business requirement to keep backups for a defined period. Users may request restores up to expiration date.

[Andy_Welburn]

we were in a position where we needed a few tapes to see us through for whatever reason.

Uses the bpmedialist command as per Mariannes suggestion, but printed out those that were to expire next in order of the 'most recent' and the volume pool so they knew where to look for each tape:

bpmedialist -mlist -l | awk '{print $1, $7}' | sort +1 -2 | head -21 > /tmp/expire_next.tmp
echo "MEDIA   EXPIRY DATE\t\t\t    VOLUME POOL"
echo "******\t************************\t********************"
cat /tmp/expire_next.tmp|
while read LINE
do
EXPIRE_DATE=`bpdbm -ctime ${EXPIRY}|cut -c 14-`
VOLUME_POOL=`vmquery -m ${MEDIA} | grep "volume pool:" | awk '{print $3}' `
echo "${MEDIA}\t${EXPIRE_DATE}\t${VOLUME_POOL}"
done