Shell Programming and Scripting

awk 'NR==FNR{a[++x]=$0;next}FNR==1{print $0,","a[1];next}{print $0","a[2]}' tmp2_file.csv tmp1_file.csv

hdr="Licensed Capacity"
data="10.00 TB"
x=1
while read line
do 
  if [ $x -eq 1 ]; then   
    echo "$line,$hdr"
    ((x+=1))
  else   
    echo "$line,$data"
  fi
done < tmp1_file.csv

# Field separator is two or more spaces
BEGIN { FS="   *";      OFS=",";        ORS="\r\n"      }
# Ignore first two lines, then store in array
NR>2 { sub(/ *$/, ""); A[$1]=$2; }

END {
        print A["System Name"],A["Total capacity"],A["Server utilization"],A["Capacity used"];}

echo " Server Name, Total Capacity , Grid Utilization , Used capacity, License Capacity" >> capacity_report.csv
...
command1 | awk -f totalcap.awk data="10.00 TB" >> capacity_report.csv

...
print A["System Name"],A["Total capacity"],A["Server utilization"],A["Capacity used"],data}
...