cancel
Showing results for 
Search instead for 
Did you mean: 

Opscenter report || Long running backup report

sushilyadav088
Level 4

I need a backup running more than 12/24 hour report from opscenter. Please let me know if there ia template or i can create a manual one in opscenter.

1 ACCEPTED SOLUTION

Accepted Solutions

Tape_Archived
Moderator
Moderator
   VIP   

Yes, you should be able to create that report but I would recommend using OpsCenter Alert, where you will get an email if the backup is running for longer time.

Login to OpsCenter => Manage => Alert Policies => Add New or Use Hung Job => Alert Condition: Hung Job => Specify Time => email_id => Save.

"=>" is move next Step. Hope this option is better than getting reports once a day, this will be real time and you can take action immediately when you receive the alert.

View solution in original post

6 REPLIES 6

Tape_Archived
Moderator
Moderator
   VIP   

Yes, you should be able to create that report but I would recommend using OpsCenter Alert, where you will get an email if the backup is running for longer time.

Login to OpsCenter => Manage => Alert Policies => Add New or Use Hung Job => Alert Condition: Hung Job => Specify Time => email_id => Save.

"=>" is move next Step. Hope this option is better than getting reports once a day, this will be real time and you can take action immediately when you receive the alert.

Thanks for reply, also can you share how we can configure that report in ops center via template. 

You would want this setup as an alert not a report. If you have it configured as a report, you will only find out if a job is hung when the email is configured to be sent. Set it up as an alert and the second a job hits the 24hr mark, or whatever you have it configured to, you are notified with an email.

M_henriksen
Level 4
Partner

Hi,

We are using this SQL query and send it daily at a specific time.

SELECT
B.friendlyname as 'Master Server',
A.id as 'Job ID',
A.clientName as 'Client',
A.policyName as 'Policy',
UTCBigIntToNomTime(A.startTime) as 'Start Time',
lookup_JobState.name as 'Job State'
FROM  "domain_Job" A , "domain_masterserver" B , lookup_JobState

WHERE
B.id = A.masterServerId AND
A.state IN (0,1,2,4,5) AND
lookup_JobState.id = A.state AND A.policyName NOT LIKE 'SLP_%' AND
DATEDIFF(hour,UTCBigIntToNomTime(A.startTime), GETDATE()) >= 24

order by B.networkName, A.clientName, "Start Time"

if I want specific master server than how to modify this SQL query we have lot master server

You can do this

SELECT
B.friendlyname as 'Master Server',
A.id as 'Job ID',
A.clientName as 'Client',
A.policyName as 'Policy',
UTCBigIntToNomTime(A.startTime) as 'Start Time',
lookup_JobState.name as 'Job State'
FROM  "domain_Job" A , "domain_masterserver" B , lookup_JobState

WHERE
B.id = A.masterServerId AND
A.state IN (0,1,2,4,5) AND
lookup_JobState.id = A.state AND A.policyName NOT LIKE 'SLP_%' AND
DATEDIFF(hour,UTCBigIntToNomTime(A.startTime), GETDATE()) >= 24
AND B.friendlyname = MASTERSERVERNAME order by B.networkName, A.clientName, "Start Time"