asmcmd with awk

export ORACLE_SID=+ASM
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
export PATH=${PATH}:${ORACLE_HOME}/bin
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib
export LC_ALL=en_GB

echo
echo
echo "  ASM Disk     % Full     Used (MB)       Free (MB)        Total (MB) "
echo "======================================================================"

asmcmd lsdg | \
 awk -v sq="'" 'BEGIN { getline } {
        printf"  %s     \t %d%% \t %9"sq"d \t %9"sq"d \t %12"sq"d \n",$13,100-100*($9/$8),$8-$9,$9,$8
   }'

#awk -F|sq="'" 'BEGIN { getline } {
#        printf"  %s     \t %d%% \t %9"sq"d \t %9"sq"d \t %12"sq"d \n",$13,100-100*($9/$8),$8-$9,$9,$8
#   }'

echo
echo





[oracle@oel5u4-+ASM dbhome_1] sh Asm.sh


  ASM Disk     % Full     Used (MB)       Free (MB)        Total (MB)
======================================================================
  DATA/          84%         4,761             896              5,657
  FRA/           100%        8,998               0              8,998







==================

export ORACLE_SID=+ASM
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid
export PATH=${PATH}:${ORACLE_HOME}/bin
export LD_LIBRARY_PATH=${ORACLE_HOME}/lib
export LC_ALL=en_GB

echo
echo
echo "  ASM Disk     % Full     Used (MB)       Free (MB)        Total (MB) " >asm.txt
echo "======================================================================" >>asm.txt

asmcmd lsdg | \
 awk -v sq="'" 'BEGIN { getline } {
        printf"  %s     \t %d%% \t %9"sq"d \t %9"sq"d \t %12"sq"d \n",$13,100-100*($9/$8),$8-$9,$9,$8
   }' >>asm.txt

#awk -F|sq="'" 'BEGIN { getline } {
#        printf"  %s     \t %d%% \t %9"sq"d \t %9"sq"d \t %12"sq"d \n",$13,100-100*($9/$8),$8-$9,$9,$8
#   }'

echo >>asm.txt
echo >>asm.txt






[oracle@oel5u4-+ASM dbhome_1] cat asm.txt


  ASM Disk     % Full     Used (MB)       Free (MB)        Total (MB)
======================================================================
  DATA/          84%         4,761             896              5,657
  FRA/           100%        8,998               0              8,998