收集服务器信息脚本并写入数据库

!/bin/bash # ********************************************************** # * Author : quanzhiqiang # * Email : 13145710069@163.com # * Create time : 2019-10-27 21:34 # * Filename : server_info.sh # * Description : # ********************************************************* echo -e "\033[34m \033[1m" cat <<EOF ---------------------------------------------------------- -----------------server system information collect----------- ------------------------------------------------------------- EOF ######################################统计服务器的基本信息########################################### #function sum_info(){ all_ip_info=`ifconfig |grep "Bcast"|awk ‘{print $2}‘ |cut -d: -f 2 |tr ‘\n‘ ‘\t‘` cpu_info_brand=`cat /proc/cpuinfo |grep "model name" |awk -F: ‘{print $2}‘|sed ‘s/^ //g‘|cut -d " " -f 1,3,4,6` cpu_heshu=`cat /proc/cpuinfo |grep "^physical" |sort|uniq -c |tr -s ‘ ‘|tail -1 |cut -d ‘ ‘ -f 2` cpu_geshu=`cat /proc/cpuinfo |grep "^physical" |sort|uniq -c |wc -l` disk_info=`fdisk -l |grep "Disk" |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/,//‘` # } ######################################输出服务器的基本信息############################################# function print_info(){ echo -e "\033[32m >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>\033[1m" echo "ALL_IPADDR: ${all_ip_info}" echo "CUP_BRAND: ${cpu_info_brand}" echo "CPU_AUDITING: ${cpu_heshu}" echo "CPU_NUMBER: ${cpu_geshu}" echo "DISK_INFO: ${disk_info}" echo "MEM_INFO: ${mem_info}" echo "LOAD_INFO: ${load_info}" echo -e "\033[0m" } #####################################三个点的函数############################################# function wait(){ for ((i=0;i<3;i++)) do echo -n "." sleep 1 done } #######################################数据库的写入##################################### function write_db(){ echo -e "\033[35m <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< \033[0m" echo -e "\033[35m Write this data to the databases? \033[0m" echo -e "\033[35m Please input Y/N \033[0m" read input if [ "$input" == "Y" ] ;then echo -e "\033[31m" echo -n "Begin to write" wait echo -e "\033[0m" ######write databases #mysql -u root -p 2004 -D test -e "insert into server_data values(‘‘,‘${all_ip_info}‘,‘*******************‘)" echo "" else echo -e "\033[31m" echo -n "Begin to exit" wait echo -e "\033[0m" exit fi } #####################################调用################################### print_info write_db

 

收集服务器信息脚本并写入数据库

标签：The   sed   收集   sql   file   com   exit   disk   数据