#!/bin/bash
echo -e "\033[34m \033[0m"
cat << EOF
++++++++++++++++++++++++++++++++++++++++++++++++++
++++++++ Welcome to use system collect +++++++++++
++++++++++++++++++++++++++++++++++++++++++++++++++
EOF
ip_info=`ifconfig | grep "Bcast" | tail -1 | awk '{print $2}' | cut -d: -f 2`
if [ -z ${ip_info} ];then
ip_info=`ip addr | grep brd | grep inet | awk '{print $2}'`
fi
cpu_info=`cat /proc/cpuinfo | grep 'model name' | tail -1 | awk -F : '{print $2}' | sed 's/^//g' | awk '{print $1,$3,$4,$NF}'`
cpu_info2=`cat /proc/cpuinfo | grep 'physical id' | sort | uniq -c | wc -l`
serv_info=`hostname | tail -1`
disk_info=`fdisk -l | grep -e 'Disk' -e "磁盘" |  grep -v 'identifier' | awk '{print $2,$3,$4}'| sed 's/,//g'`
mem_info=`free -m | grep "Mem"|awk '{print "Total",$1,$2"M"}'`
load_info=`uptime | awk '{print "Current Load: "$(NF-2)}'| sed 's/\,//g'`
mark_info='JiangSu_Test'
echo -e "\033[32m ---------------------------------------\033[1m" 

echo IPADDR: ${ip_info}
echo HOSTNAME:${serv_info}
echo CPU_INFO:${cpu_info}X${cpu_info2}
echo DISK_INFO:${disk_info}
echo MEM_INFO:${mem_info}
echo LOAD_INFO: ${load_info}
echo MARK_INFO: ${mark_info}

echo -e "\033[32m ---------------------------------------\033[0m" 
echo -e -n "\033[31mYou want to write the data to the databases? \033[1m";read ensure
if [ "$ensure" == "yes" -o "$ensure" == "YES" -o "$ensure" == "y" -o "$ensure" == "Y"  ];then
echo  "-------------------------------------------------------------"
echo -e '\033[31mmysql -uinfo -psystem_info -h 192.168.254.5 -D info -e '''"insert into audit_system values('','${ip_info}','${serv_info}','${cpu_info}X${cpu_info2}','${disk_info}','${mem_info}','${load_info}','${mark_info}')"'''\033[0m'
mysql -uinfo -psystem_info -h 192.168.254.5 -D info -e "insert into audit_system values('','${ip_info}','${serv_info}','${cpu_info}X${cpu_info2}','${disk_info}','${mem_info}','${load_info}','${mark_info}')"
else
echo "Please wait.exit ..."
fi