Forum Discussion

sushilyadav088's avatar
8 years ago
Solved

Opscenter report || Long running backup report

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.

  • 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.

  • 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.

    • sushilyadav088's avatar
      sushilyadav088
      Level 4

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

      • GeForce123's avatar
        GeForce123
        Level 5

        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.

  • 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"
    • sattar's avatar
      sattar
      Level 1

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

      • M_henriksen's avatar
        M_henriksen
        Level 4

        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"