Script to check number of user hits on a Oracle EBS server on Monthly Basis:-
monthly_hits.sh
TIME=`date +%y%m%d%H`
export TIME
file_name=VIS_$TIME.txt
export file_name
touch $file_name
touch $ip_files.txt
SCR_DIR=/u01/oracle/VIS/inst/apps/VIS_hostname/logs/ora/10.1.3/Apache
curmth=`date +%m`
curyr=`date +%Y`
prevyr=$((curyr - 1))
echo $curmth
echo $curyr
echo $prevyr
mth=('Dec' 'Jan' 'Feb' 'Mar' 'Apr' 'May' 'Jun' 'Jul' 'Aug' 'Sep' 'Oct' 'Nov')
export MONTH='Jan'
ls -lrt $SCR_DIR|grep "access_log*"|grep "$MONTH"|awk '{print $9}'|sed -e "s/^/\/u01\/oracle\/VIS\/inst\/apps\/VIS_hostname\/logs\/ora\/10.1.3\/Apache\//g" >ip_files_$MONTH.txt
#ls -lrt $SCR_DIR|grep "access_log*"|grep "Apr"|awk '{print $9}'|sed -e "s/^/\/h
if [ $curmth == 01 ]
then
for i in `cat ip_files_$MONTH.txt`
do
cat "$i"|grep "AppsLocalLogin"|grep "$MONTH"|grep $prevyr|awk '{print $1 $4}'|sed -e 's/:/ /g'|sed -e 's/\[/ /g'|sed -e 's/\//-/g'|awk '{print $2"," $1 ",VIS,EBS,US,EBS Sandbox"}'>>$file_name
done
else
for i in `cat ip_files_$MONTH.txt`
do
cat "$i"|grep "AppsLocalLogin"|grep "$MONTH"|grep $curyr|awk '{print $1 $4}'|sed -e 's/:/ /g'|sed -e 's/\[/ /g'|sed -e 's/\//-/g'|awk '{print $2 "," $1 ",VIS,EBS,US,EBS Sandbox"}'>>$file_name
done
fi
