select -
VARCHAR(b.server_name,10) as SERVER_NAME, -
VARCHAR(c.domain_name,16) as DOMAIN_NAME, -
VARCHAR(a.SCHEDULE_NAME,20) as SCHEDULE_NAME, -
VARCHAR(a.ENTITY,45) as STGPOOL, -
TRANSLATE('abcde fg:hi:jk', a.start_time, '_____abcde_fg_hi_jk_____',' ') AS start_time, -
TRANSLATE('abcde fg:hi:jk', a.end_time, '_____abcde_fg_hi_jk_____',' ') AS end_time, -
TRANSLATE('ab cd:ef:gh', DIGITS(a.end_time-a.start_time), '______abcdefghi_____',' ') AS duration, -
CASE -
WHEN a.bytes>1099511627776 THEN CAST(DEC(bytes)/1024/1024/1024/1024 AS DEC(5,1))||'TB' -
WHEN a.bytes>1073741824 THEN CAST(DEC(bytes)/1024/1024/1024 AS DEC(5,1))||' GB' -
WHEN a.bytes>1048576 THEN CAST(DEC(bytes)/1024/1024 AS DEC(5,1))||' MB' -
WHEN a.bytes>1024 THEN CAST(DEC(bytes)/1024 AS DEC(5,1))||' KB' -
ELSE -
CAST(a.bytes AS DEC(5,0))||' B' -
END AS bytes, -
CAST(CAST((a.bytes/1024/1024)/TIMESTAMPDIFF(2,CHAR(a.end_time-a.start_time)) -
AS DEC(6,2))AS VARCHAR(6))||' MB/s' AS THROUGHPUT, -
a.AFFECTED as FILES_BACKED_UP, -
a.SUCCESSFUL -
FROM summary a, status b, nodes c -
where a.entity in (select node_name from associations) -
and -
a.entity=c.node_name -
and -
a.activity='BACKUP' -
and -
a.start_time>=(current_timestamp - 3 days) -
order by a.start_time asc