VMAX script template

#!/usr/bin/sh
###AUTHOR: SAMIR AHMED
###THE FOLLOWING SCRIPT HAS BEEN CREATED TO MONITOR AND HELP IN THE CAPACITY MANAGEMENT PROCESS
###THIS SCRIPT IS FOR FOUR TIERS
###THE FILE '/tmp/VMAX_STATS/vmax_utl.dat' WOULD BE HAVING THE OUTPUT OF THE SCRIPTS YOU CAN IMPORT IT TO EXCELL OR LOAD IT INTO DATABASE
###THE SCRIPT TAKES ABOUT 30 to 45 MINUTES TO FINISH
###NOTE: TAILOR IT TO YOUR ENVIRONMENT

##set environment PATH
PATH=$PATH:/opt/emc/SYMCLI/bin
export PATH
##############################
DIRECTORY="/tmp/VMAX_STATS"
if [ ! -d "$DIRECTORY" ]; then
  # Control will enter here if $DIRECTORY doesn't exist.
        mkdir $DIRECTORY
fi
touch /tmp/VMAX_STATS/vmax_utl.dat
> /tmp/VMAX_STATS/vmax_utl.dat
> /tmp/stor_grps
##ADJUST THE TIERS AS PER YOUR NAMING CONVENTION AND NUMBER OF TIERS, ALSO THE VMAX ID
VMAX_SID=915
TIER1=xxxx1
TIER2=xxxx2
TIER3=xxxx3
TIER4=xxxx4

##THE BELOW LINE IS EXCLUDING THE STORAGE GROUPS  HAVING 'FAST' WORD AS I DON'T WANT TO INCLUDE THE FAST STORAGE GROUPS AS WELL AS THE HEADERS..YOU CAN REMOVE IT IF YOU WANT TO INCLUDE ALL YOUR STORAGE GROUPS
symaccess -sid ${VMAX_SID} -type stor list | tail +7 | grep -v FAST > /tmp/STRR

cat /tmp/STRR | while read SGs
do
        symcfg -sid ${VMAX_SID} -tdev -sg $SGs -detail -gb list > /dev/null 2>&1
        if [ $? -eq 0 ]
        then
                        echo $SGs >> /tmp/stor_grps
        fi
done

for sg in `cat /tmp/stor_grps`
do
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER1 | awk -F' ' '{print $4}' | grep -v '-' > /tmp/${sg}_assigned_${TIER1}
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER2 | awk -F' ' '{print $4}' | grep -v '-' > /tmp/${sg}_assigned_${TIER2}
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER3 | awk -F' ' '{print $4}' | grep -v '-' > /tmp/${sg}_assigned_${TIER3}
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER4  | awk -F' ' '{print $4}' | grep -v '-' > /tmp/${sg}_assigned_${TIER4}
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER1 | awk -F' ' '{print $8}' | grep -v '-' > /tmp/${sg}_written_${TIER1}
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER2 | awk -F' ' '{print $8}' | grep -v '-' > /tmp/${sg}_written_${TIER2}
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER3 | awk -F' ' '{print $8}' | grep -v '-' > /tmp/${sg}_written_${TIER3}
                symcfg -sid ${VMAX_SID} -tdev -sg $sg -detail -gb list | grep $TIER4  | awk -F' ' '{print $8}' | grep -v '-' > /tmp/${sg}_written_${TIER4}
        sum1=0
        for i in `cat /tmp/${sg}_assigned_${TIER1}`
        do
                sum1=`echo "$sum1+$i" | bc -l`
        done
        sum2=0
        for i in `cat /tmp/${sg}_assigned_${TIER2}`
        do
                sum2=`echo "$sum2+$i" | bc -l`
        done
        sum3=0
        for i in `cat /tmp/${sg}_assigned_${TIER3}`
        do
                sum3=`echo "$sum3+$i" | bc -l`
        done
        sum4=0
        for i in `cat /tmp/${sg}_assigned_${TIER4}`
        do
                sum4=`echo "$sum4+$i" | bc -l`
        done
        sum5=0
        for i in `cat /tmp/${sg}_written_${TIER1}`
        do
                sum5=`echo "$sum5+$i" | bc -l`
        done
        sum6=0
        for i in `cat /tmp/${sg}_written_${TIER2}`
        do
                sum6=`echo "$sum6+$i" | bc -l`
        done
        sum7=0
        for i in `cat /tmp/${sg}_written_${TIER3}`
        do
                sum7=`echo "$sum7+$i" | bc -l`
        done
        sum8=0
        for i in `cat /tmp/${sg}_written_${TIER4}`
        do
                sum8=`echo "$sum8+$i" | bc -l`
        done
        echo ",$sg,$sum1,$sum5,$sum2,$sum6,$sum3,$sum7,$sum4,$sum8" >> /tmp/VMAX_STATS/vmax_utl.dat
done
#scp /tmp/VMAX_STATS/vmax_utl.dat samir@VMAXstatsDB_server:~samir/
#ssh samir@VMAXstatsDB_server ./load.sh