TSM命令来获取备份计数，单位是GB？

Question

有没有人可以给我提供TSM命令，以获取过去30天的备份计数(GB)？

下面是一个SQL命令示例，我们可以在TSM上执行该命令来获取过去24小时的数据大小：

SELECT substr(entity,1,20) AS "Node", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB Bkp"
FROM summary
WHERE activity = 'BACKUP' AND start_time>=current_timestamp - 24 hours
GROUP BY entity
order by 2 desc

Answer 1

我多年没有从事TSM工作了，但是您不能简单地将WHERE子句中的小时数更改为24小时* 30天吗？

SELECT substr(entity,1,20) AS "Node", CAST(sum(bytes/1024/1024) AS decimal(8,2)) AS "MB Bkp"
FROM summary
WHERE activity = 'BACKUP' AND start_time>=current_timestamp - 720 hours
GROUP BY entity
order by 2 desc

要获得GB，请在SELECT子句中将字节再次除以1024。

Answer 2

您可以尝试使用此SQL查询；只需将7天改为30天。希望这能起作用。下面是许多SQL查询的有用链接。https://github.com/thobiast/tsm_sql

12.3。最近7天内每个节点的归档、备份、恢复和检索操作的统计信息(GB)

TSM版本6

SELECT entity, activity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) -
FROM summary 
WHERE DAYS(current_timestamp)-DAYS(end_time)<=7 and ( activity='ARCHIVE' OR -
  activity='BACKUP' OR activity='RESTORE' OR activity='RETRIEVE' ) 
GROUP BY entity, activity

TSM版本5

SELECT entity, activity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) -
FROM summary 
WHERE end_time>current_timestamp-(7)DAY and ( activity='ARCHIVE' OR -
  activity='BACKUP' OR activity='RESTORE' OR activity='RETRIEVE' ) 
GROUP BY entity, activity