How to find the total data backed up by node in TSM

SQL command to determine total data backed up by node

SELECT entity as "Node name", CAST(sum(bytes/1024/1024/1024) AS decimal(8,2)) AS "Total GB" FROM summary WHERE activity='BACKUP' AND start_time>=current_timestamp - 24 hours GROUP BY entity
Previous
Next Post »