awk -F, '{ if($NF == "dmz"){ if($7~/^[a-z][A-Z][^@]+$/){ print $7,$NF }else if($7~/[@]/){ print $7,$NF }else if($7~/^[0-9]+$/){print $7,$NF} } }' file
awk -F, '{ if($NF == "dmz"){ if($7~/^[a-z][A-Z][^@]+$/){ print $7,$NF }else if($7~/[@]/){ print $7,$NF }else if($7~/^[0-9]+$/){print $7,$NF} } }' file