#!/bin/bash

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 "osd%" and hostname not like "box648%" order by `mountpoint-problems` desc'

for i in rpm-version backup-status backup-stage; do mysql backups -e "select \`$i\`,count(*) from backupstate where hostname not like '%alpha%' and hostname not like '%beta%' group by \`$i\`"; done

for c in bluehost.com hostmonster.com fastdomain.com justhost.com .com
do
  echo "##### $c #####"
  for i in cpanel-accounts-with-backups cpanel-accounts-two-days-behind cpanel-accounts-one-week-behind cpanel-accounts-not-backuped-up
  do 
    echo -e -n "$i: \t"
    mysql -B -N backups -e "select sum(\`cpanel-accounts-total\`) as 'total' , sum(\`$i\`) as '$i',  (sum(\`$i\`) / sum(\`cpanel-accounts-total\`)) as 'percent'  from backupstate where hostname like '%$c' and hostname not like '%alpha%' and hostname not like '%beta%'"
  done
done
