I was after a OPS Centre Analytics report (either custom or SQL) which can show me all of the currently suspended NetBackup jobs (all Types - backup, restores, snapshots...).
Does anyone have any ideas?
|State||Type||Client||Policy||Job Schedule||Start Time||Elapsed Time|
May not get every thing you mention but you may try this ,
adjust_timestamp(domain_Job.startTime,14400000 ) as "Start Time",
adjust_timestamp(domain_Job.endTime,14400000 ) as "End Time",
adjust_timestamp(domain_Job.lastupdatedtime,14400000 ) as "LastUpdate",
from domain_job where state=4
State (1=active,3=done ,4= Suspended )
Type ( 0 = backup , 2 = Restore , 4 = Duplication)
Subtype ( 1 = Filesystem , 12 = Catalog)
Hope this will help.