#!/bin/bash
echo "these are the customer boxes with unmounted backups.  Please remedy this before backups kick off tonight so we can maintain happy backups for all customers"
echo "basic steps to get these boxes working can be found here: https://wiki.bluehost.com/index.php/Iscsi_backup-mounts_troubleshooting"
mysql backups -e 'select hostname,`mountpoint-problems` from backupstate where `mountpoint-problems` != 0 and hostname not like "%alpha%" and hostname not like "%beta%"  and hostname not like "box648%" and hostname not like "box702%" and `cpanel-accounts-total` > 0 order by `hostname` desc'

