cancel
Showing results for 
Search instead for 
Did you mean: 

OPS Centre Analytics Report for Suspended Jobs

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?

StateTypeClientPolicyJob ScheduleStart TimeElapsed Time
SuspendedBackupserverAPolicy_1Monthly_Full18:0012:00hrs
SuspendedRestoreserverB  13:004:00hrs
1 Reply

Re: OPS Centre Analytics Report for Suspended Jobs

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