OPS Centre Analytics Report for Suspended Jobs

[Woo]

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

[Deeps]

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