To find out transports released from a specified system in the last specified number of days using in the specified transport directory.
Command line parameters are:
Number of days: $1
Source system : $2
Transport dir : $3 (if different from /usr/sap/trans)
#!/bin/sh
if [ $# != 4 ]
then
echo "Incorrect usage. Usage: $0 <Number of days> <Source system> <DIR_TRANS> <Output format [E]xcel/[W]ord>"
exit 0
fi
NUMBER_OF_DAYS=$1
SOURCE_SYSTEM=$2
DIR_TRANS=$3
OUTPUT_FORMAT=$4
echo "Listing the transports released from ${SOURCE_SYSTEM} in the last ${NUMBER_OF_DAYS} days"
DATADIR=${DIR_TRANS}/data
LOGDIR=${DIR_TRANS}/log
COFILEDIR=${DIR_TRANS}/cofiles
TEMPFILE1=/tmp/tempfile1
TEMPFILE2=/tmp/tempfile2
find ${DATADIR} -name "*.${SOURCE_SYSTEM}" -mtime -${NUMBER_OF_DAYS} -print | awk -F'R' '{print $2}' | awk -F'.' '{print $1}' > ${TEMPFILE1}
if [ ${OUTPUT_FORMAT} = 'E' ]
then
echo "Transport Source system Exported on Import date Import time"
echo "--------- ------------- ----------- ------------- -----------"
fi
cd ${LOGDIR}
for TP in `cat ${TEMPFILE1}`
do
echo ""
var1=`ls -l ${DATADIR}/*${TP}* | awk '{print $6" " $7" " $8}'`
if [ ${OUTPUT_FORMAT} = 'W' ]
then
echo "${SOURCE_SYSTEM}K${TP} Exported out of ${SOURCE_SYSTEM} on ${var1}"
echo "-------------------------------------------------------------------"
fi
ls -1 ${SOURCE_SYSTEM}I${TP}* > ${TEMPFILE2}
for LOGS in `cat ${TEMPFILE2}`
do
var2=`ls -l ${LOGS}* | awk '{print $6" " $7" " $8}'`
if [ ${OUTPUT_FORMAT} = 'W' ]
then
echo "Imported to `echo $LOGS | awk -F'.' '{print $2}'` on ${var2}"
else
#echo "Transport ${SOURCE_SYSTEM}K${TP} Exported from ${SOURCE_SYSTEM} at ${var1} & Imported to `echo $LOGS | awk -F'.' '{print $2}'` on ${var2}"
echo "${SOURCE_SYSTEM}K${TP} ${SOURCE_SYSTEM} ${var1} `echo $LOGS | awk -F'.' '{print $2}'` ${var2}"
fi
done
done
