TSM v5
SELECT NODE_NAME, FILESPACE_NAME from FILESPACE WHERE BACKUP_END IS NULL OR BACKUP_END < BACKUP_START
TSMv6
SELECT NODE_NAME, FILESPACE_NAME from FILESPACEVIEW WHERE BACKUP_END IS NULL OR BACKUP_END < BACKUP_START
Posted in: Helpful TSM SQL Commands