Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- user="zabbix"
- password="LcnzJDaSR"
- query="select host,ip from hosts where host like 'Client%' and ip like '192.168.230.%' ORDER BY ip"
- sql=`mysql --host="localhost" --database="zabbix" --user="zabbix" --password="LcnzJqqXBVvPDaSR" -e "$query"`
- echo "${sql}" | sed 's/\t/;/g' | sed '1,1d' > /tmp/sql
- IFS=";"
- while read login ip; do
- echo "lastlogin: $login"
- echo "lastip: $ip"
- done < /tmp/sql
- #l=`cat ip_cl02.txt | awk '{print($3)}'`
- while read line; do
- echo $line | awk '{print($3)}'
- done < ip_cl02.txt
Add Comment
Please, Sign In to add comment