Reporting on NDMP Backups

[bphealy]

Hi, just wondering if anyone has created a SQL report which will show the success/failure of NDMP jobs which will include the filespace in question ?, thanks

 

[LoreneT]

I would really appreciate this as well.

 

[cilesiz]

Hi,

you can use the following sql query from the summary table:



select substr(S.entity,1,20) "NAS Node",RPAD(S.number,10) "ProcNr", DECODE(A.MSGNO,1064,'Diff: ' || substr(left(A.message,instr(A.message,'started',4,1)-3),65,90),1063,'Full: ' || substr(left(A.message,instr(A.message,'started',4,1)-3),57,90)) "Backup-Type and FilesSpace" ,cast(date(S.start_time) as char(10)) || ' ' || char(time(S.start_time),JIS) "Start Time",cast(date(S.end_time) as char(10)) || ' ' || char(time(S.end_time),JIS) "End Time", TRANSLATE('a bc:de:fg', DIGITS(S.end_time-S.start_time), '_______abcdefgh_____',' ') "Duration (D HHMMSS)", timestampdiff(2, substr(S.MEDIAW/60,1,4)) "MEDIAW [min]", timestampdiff(2, substr(S.IDLE/60,1,4)) "IDLE [min]",lpad(S.processes,2) "Proc", lpad(S.examined,15) "Exa",lpad(S.affected,15) "Aff", lpad(cast(S.BYTES/1024/1024/1024 as decimal(9,0)),5) GB,lpad(CAST(S.BYTES/1024/1024/(timestampdiff(2,char(S.end_time-S.start_time))+0.01) as DECIMAL(9,0)),5) "MB/s", lpad(S.successful,4) "Succ" from summary S, actlog A where (S.end_time>=current_timestamp - 21 days) and S.entity like upper('%nas%') and S.activity not in ('EXPIRATION') and S.number=A.process and A.MSGNO in (1063,1064) order by 2, 3, 4

regards

Ugur

 

[LoreneT]

This is amazing, thank you so much, but all the righthand columns are zero:
MEDIAW [min] IDLE [min] Proc Exa Aff GB MB/s Succ

Any idea why?