
#!/bin/bash 

rm /etc/scripts/lastusersmon/report-* -f
mkdir -p /etc/scripts/lastusersmon/.tmp


repquota / | awk '{print $3/1024/1024,$1}'  | sort -h  > /etc/scripts/lastusersmon/.tmp/stage
#cat /var/cpanel/accounting.log |grep  "`date +%b`.*2016:CREATE:root" > /etc/scripts/lastusersmon/.tmp/stage2
cat /var/cpanel/accounting.log |grep  "`date +%b`.*2016:CREATE:root"  | awk '{print $2,$3,$5}' | awk -F ":" '{print $7}' | sort | uniq  > /etc/scripts/lastusersmon/.tmp/stage2
cat /etc/scripts/lastusersmon/.tmp/stage2 | xargs -i grep {} /etc/scripts/lastusersmon/.tmp/stage | sort -h > /etc/scripts/lastusersmon/.tmp/stage3


cat /etc/scripts/lastusersmon/.tmp/stage2 | xargs -i grep {} /etc/scripts/lastusersmon/.tmp/stage | sort -h | awk '{print $1}' > /etc/scripts/lastusersmon/.tmp/stage5
paste /etc/scripts/lastusersmon/.tmp/stage5 /etc/scripts/lastusersmon/.tmp/stage2  > /etc/scripts/lastusersmon/.tmp/report.txt
cat /etc/scripts/lastusersmon/.tmp/report.txt | sed -e 's/\t/;/g' -e  's/Nov /Nov_/g' -e  's/ /;/g' > /etc/scripts/lastusersmon/report-HDD


mkdir -p /etc/scripts/lastusersmon/.tmp/files
for user in ` cat /etc/scripts/lastusersmon/report-HDD | awk -F ";" '{print $2}'` ; do lveinfo  --period=30d   --user=$user > /etc/scripts/lastusersmon/.tmp/files/$user.lve ; done

WORKDIR=/etc/scripts/lastusersmon
FILEDIRS=/etc/scripts/lastusersmon/.tmp/files

#echo "username,AVR CPU,username,MAX CPU,username, AVG RAM,username,MAX RAM,username,AVR IO,username,MAX IO,username,AVR Nproc,username,AVR Nproc"
echo "username,AVR CPU,,username,MAX CPU,,username,AVG RAM,,username,MAX RAM,,username,AVR IO,,username,MAX IO,,username,AVR Nproc,,username,AVR Nproc" > /etc/scripts/lastusersmon/report-RES

for i in `cat /etc/scripts/lastusersmon/report-HDD | awk -F ";" '{print $2}' `

do


VARaCPU=$(awk -F"|" '{print $4}' $FILEDIRS/$i.lve | sed -e  's/[a-z]//g' -e   's/[A-Z]//g' | awk  '{sum+=$1} END {print sum/NR}')
VARmCPU=$(awk -F"|" '{print $5}' $FILEDIRS/$i.lve | sed -e  's/[a-z]//g' -e   's/[A-Z]//g' | awk  '{sum+=$1} END {print sum/NR}')
VARaIO=$(awk -F"|" '{print $7}' $FILEDIRS/$i.lve | sed -e  's/[a-z]//g' -e   's/[A-Z]//g' | awk  '{sum+=$1} END {print sum/NR}')
VARmIO=$(awk -F"|" '{print $8}' $FILEDIRS/$i.lve | sed -e  's/[a-z]//g' -e   's/[A-Z]//g' | awk  '{sum+=$1} END {print sum/NR}')

VARaPMem=$(awk -F"|" '{print $16}'  $FILEDIRS/$i.lve)
VARmPMem=$(awk -F"|" '{print $17}'  $FILEDIRS/$i.lve)

VARaNproc=$(awk -F"|" '{print $19}' $FILEDIRS/$i.lve | sed -e  's/[a-z]//g' -e   's/[A-Z]//g' | awk  '{sum+=$1} END {print sum/NR}')
VARmNproc=$(awk -F"|" '{print $20}' $FILEDIRS/$i.lve | sed -e  's/[a-z]//g' -e   's/[A-Z]//g' | awk  '{sum+=$1} END {print sum/NR}')


for ramec in $(echo $VARaPMem)
do
if [[ `echo $ramec | grep -i M -c` -gt "0" ]]
then
VARaPMemSec=`echo $ramec |sed "s/[A-Z]//g"  | awk '{print $1}'`
sed "s/$ramec/$VARaPMemSec/g" $FILEDIRS/$i.lve -i
fi

if [[ `echo $ramec | grep -i K -c` -gt "0" ]]
then
VARaPMemSec2=`echo $ramec |sed "s/[A-Z]//g"  | awk '{print $1/1024}'`
sed "s/$ramec/$VARaPMemSec2/g" $FILEDIRS/$i.lve -i

fi

done


for ramec in $(echo $VARmPMem)
do
if [[ `echo $ramec | grep -i M -c` -gt "0" ]]
then
VARmPMemSec=`echo $ramec |sed "s/[A-Z]//g"  | awk '{print $1}'`
sed "s/$ramec/$VARmPMemSec/g" $FILEDIRS/$i.lve -i
fi

if [[ `echo $ramec | grep -i K -c` -gt "0" ]]
then
VARmPMemSec2=`echo $ramec |sed "s/[A-Z]//g"  | awk '{print $1/1024}'`
sed "s/$ramec/$VARmPMemSec2/g" $FILEDIRS/$i.lve -i

fi

done

RAMA=$(awk -F"|" '{print $16}'  $FILEDIRS/$i.lve | awk  '{sum+=$1} END {print sum/NR}')
RAMM=$(awk -F"|" '{print $17}'  $FILEDIRS/$i.lve | awk  '{sum+=$1} END {print sum/NR}')
#echo "$i,$VARaCPU,$i,$VARmCPU,$i,$RAMA,$i,$RAMM,$i,$VARaIO,$i,$VARmIO,$i,$VARaNproc,$i,$VARmNproc"
echo "$i,$VARaCPU,,$i,$VARmCPU,,$i,$RAMA,,$i,$RAMM,,$i,$VARaIO,,$i,$VARmIO,,$i,$VARaNproc,,$i,$VARmNproc" >> /etc/scripts/lastusersmon/report-RES
done


for bwuser in `cat /etc/scripts/lastusersmon/report-HDD | awk -F ";" '{print $2}' ` ;
do 
 whmapi0 showbw search=$bwuser searchtype=user | egrep "(totalbytes:)" | sed -e 's/ //g'  -e "s/'//g"   | xargs -L 222 >>  /etc/scripts/lastusersmon/report-BW
done