#!/bin/bash
# awk 'END{print}' get the last row
iplist=$(cat ~/fanr/shell/Weekly/ip.list)

for _IP in $iplist
do
        echo $_IP
        usage=$(ssh root@$_IP df --total|awk 'END{if(NR=FNR) print 100-int($5)}')
        cpu=$(ssh root@$_IP vmstat | awk 'END{print 100-int($15)}')
        mem=$(ssh root@$_IP free -om |awk '{if($1 == "Mem:") print int($3)}')
        disk=$(ssh root@$_IP iostat -dx| awk '{if(NR==4) print 100-int($12)}')
        echo "insert into PerformanceWeekly(alias,cpu,memory,diskfree,cpu2,ideldisk) values('$_IP',$cpu,$mem,$usage,$cpu, $disk)" > out.sql
        isql  mydsn sa Tiansign2012 -w < out.sql
done