11-29-2016 03:18 PM
Hello,
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 |
Suspended | Backup | serverA | Policy_1 | Monthly_Full | 18:00 | 12:00hrs |
Suspended | Restore | serverB | 13:00 | 4:00hrs |
12-04-2016 11:28 PM
May not get every thing you mention but you may try this ,
select
masterserverid,clientname,id,type,subtype,state,backuptype,
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",
policyname,ScheduleName
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.
DeepS