Code:
awk '
NR == 1 {split ($0, HD)
next
}
NR == FNR {while (NF < 6) {getline X
$0 = $0 FS X
}
for (i=1; i<=NF; i++) $i = HD[i] ":\"" $i "\""
TMP = $NF
sub (OFS $NF,_)
REF[TMP] = $0
next
}
{gsub (/=/, ":")
sub (/MOUNTPOINT/, "Mounted")
}
$NF in REF {sub ("^" $1 FS, _)
$1 = $1
print REF[$NF], $0
}
' OFS=, file2 file1
Filesystem:"/dev/xvda1",Size:"477M",Used:"126M",Avail:"326M",Use%:"28%",TYPE:"part",SIZE:"500M",OWNER:"root",GROUP:"disk",MODE:"brw-rw----",Mounted:"/boot"
Filesystem:"/dev/mapper/VolGroup-lv_root",Size:"37G",Used:"1.4G",Avail:"34G",Use%:"4%",TYPE:"lvm",SIZE:"37.6G",OWNER:"root",GROUP:"disk",MODE:"brw-rw----",Mounted:"/"
Filesystem:"/dev/xvdq",Size:"2.0G",Used:"24M",Avail:"1.8G",Use%:"2%",TYPE:"disk",SIZE:"2G",OWNER:"root",GROUP:"disk",MODE:"brw-rw----",Mounted:"/var/log/audit"
Filesystem:"/dev/xvdp",Size:"6.8G",Used:"27M",Avail:"6.4G",Use%:"1%",TYPE:"disk",SIZE:"7G",OWNER:"root",GROUP:"disk",MODE:"brw-rw----",Mounted:"/var/log"
Filesystem:"/dev/xvdo",Size:"6.8G",Used:"458M",Avail:"6.0G",Use%:"7%",TYPE:"disk",SIZE:"7G",OWNER:"root",GROUP:"disk",MODE:"brw-rw----",Mounted:"/var"
Filesystem:"/dev/xvdn",Size:"2.0G",Used:"3.1M",Avail:"1.9G",Use%:"1%",TYPE:"disk",SIZE:"2G",OWNER:"root",GROUP:"disk",MODE:"brw-rw----",Mounted:"/home"