获取系统信息并登记在数据库脚本

创建数据库

CREATE TABLES 'audit_system' (
id int(11) NOT NULL AUTO_INCREMENT,
ip_info varchar(50) NOT NULL,
serv_info varchar(50) NOT NULL,
cpu_info varchar(50) NOT NULL,
disk_info varchar(50) NOT NULL,
mem_info varchar(50) NOT NULL,
load_info varchar(50) NOT NULL,
mark_info varchar(50) NOT NULL,
PRIMARY KEY （'id'）
UNIQUE KEY  'ip_info' ('ip_info'),
UNIQUE KEY  'ip_info_2' ('ip_info'),
);

脚本：

#!/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

脚本下载 ：
下载