cancel
Showing results for 
Search instead for 
Did you mean: 

Creating a report in Ops center if backup success after time window need help urgently

anandsmarty
Level 2

scenario-:

In my environment there is time window is 22:00:00 to 21:00:00.

So, i want to create the ops center report for those backup which is completed after the time window as "Late Success".

 

need help.......urgently basis.

 

3 REPLIES 3

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello

 

Simply add this to your query and change the 24 to the value you require. It reflects the time difference from NOW to the jobs end time.

In otherwords, if you run the report at 23:00 and you use 2 as your value, it will show you all the jobs that completed in the last 2 hours.

AND DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <= 24

anandsmarty
Level 2

hello, Raan

 

thanks for giving suggestion. its really help full.

 

i want some more help from u. i am beginner. so tell me how to learn ops center.  i have little bin knowledge of SQL.

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Download the schema doc and start playing http://www.veritas.com/community/sites/default/files/OC_Schema_Document_08May_7.6.pdf