Guest User

Untitled

a guest
Feb 26th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. for domain in `echo "$QUERY1" | mysql -N -s -u $USER -p$PASS $DBNAME -h$HOST | awk '{print $1}'; do
  2. lookup=$(dig $domain ns +short)
  3. if [[ "$lookup" =~ 'XXX' ]]; then
  4. our=1
  5. break
  6. else
  7. our=0
  8. break
  9. fi
  10. done
  11.  
  12. mysql --silent --skip-column-names
  13. --user="$USER" --password="$PASSWORD"
  14. --host="$HOST" --database="$DBNAME"
  15. --execute="$QUERY1" |
  16. awk '{ printf("%s ns +shortn", $1) }' |
  17. if dig -f - | grep -q "XXX"; then
  18. our=1
  19. else
  20. our=0
  21. fi
  22.  
  23. SELECT CONCAT(column, " ns +short") FROM ...
Add Comment
Please, Sign In to add comment