#!/bin/sh
#Function:scan server
#Writer:liutiansi
#Mail:liutiansi@gmail.com
#Date:2007-11-09 23:57

mysql_bin="/home/liuts/mysql"   #mysql安装位置
mysql_host="localhost"                                              #数据库主机
mysql_user="systemuser_scan"                                            #数据库帐号
mysql_passwd="123456"                 #数据库密码
scan_num=0
scan_port=""
#安全扫描端口
scan_port_list=`$mysql_bin -h $mysql_host -u$mysql_user -p$mysql_passwd -e "select * from sysadmin.ty_server_port " | awk 'NR>1 {print NR,$0}'|awk '{print $2}'`
for vlist in $scan_port_list
do
        scan_num=`expr $scan_num + 1`
        scan_port=$scan_port$vlist","
done;
scan_num=`expr $scan_num + 5`
#scan_port=`echo "$scan_port"|sed 's/ /,/g'`
getdatetime=`date '+%Y-%m-%d %H:%M:%S'`
server=`$mysql_bin -h $mysql_host -u$mysql_user -p$mysql_passwd -e "select * from sysadmin.ty_server_scanport " | awk 'NR>1 {print NR,$0}'|awk '{print $2}'`
for vlist in $server
do
        result=`/usr/local/bin/nmap -p $scan_port $vlist|awk 'NR==6,NR=='"$scan_num"'{print $1","$2}' 2>&1`
        result_up=`$mysql_bin -h $mysql_host -u$mysql_user -p$mysql_passwd -e "update sysadmin.ty_server_scanport set PORT='$result',UPDATETIME='$getdatetime' where SERVER='$vlist';" 2>&1`
done;
