User Tools

Site Tools


sql_queries

This is an old revision of the document!


SQL Queries

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)
sql_queries.1329121590.txt.gz · Last modified: 2021/04/24 07:38 (external edit)