Transports released from a specified system

You are here: Home

SAP Technical

Basis

Login Form

ERPGenie Websites

ERP Software Corner

Transports released from a specified system

Details: Category: Basis; Published on Monday, 02 July 2007 22:50; Written by Anon.; Hits: 11720

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

Login Form

Main Menu

ERPGenie Websites

ERP Software Corner

Transports released from a specified system

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: $1Source system : $2Transport dir : $3 (if different from /usr/sap/trans)

Command line parameters are:
Number of days: $1
Source system : $2
Transport dir : $3 (if different from /usr/sap/trans)