Base code for select func in shell
ran_db_host="*";
ran_db_port=63751;
ran_db_user="*";
ran_db_pass="*";
ran_db_data="*";
cmd="use *;select rs.model from RMP_Server rs left join RMP_Ip rsIP on rs.id=rsIP.serverId WHERE ipAddress=\"$1\""
cnt=$(mysql -uranreader -h$ran_db_host -P$ran_db_port -p$ran_db_pass -s -e "${cmd}" 2>/dev/null)
if `echo $cnt | grep -oP "KVM|OpenStack|FOXCONN|CNC_|6100|EC2C109|PACUARE|SC1425|SKYKOMISH|SLIMFAST09|SLIMLINE09|XENCOMPA09|XS23|dell$|Dell$|DELL$" > /dev/null`;then
echo "False"
else
echo "True"
fi