Filespaces that where not backed up for $day days:
select f.node_name, n.contact, f.filespace_name, f.backup_start, f.backup_end from filespaces f, nodes n where (backup_end < current_timestamp - $days days) AND (n.node_name = f.node_name)
Maximale und Minimale übertragungsrage eines TSM-Nodes — abfrage an mysqldb die daten puffert.
select node_name, MAX(bytes/(1024*1024*1024)/(CAST((end_time-start_time) as unsigned))*3600), MIN(bytes/(1024*1024*1024)/(CAST((end_time-start_time) as unsigned))*3600) FROM `backups` WHERE node_name like 'DMS%' start_time > '2012-08-01 00:00:00' group by node_name