cancel
Showing results for 
Search instead for 
Did you mean: 

Daily Backup Status Report Base on Policy Name

I use to have a Daily Backup Status report email from Veritas Backup Reporter that contain Status, Policy Name, Job Start Time, Job End Time, Job Size (GB) and on the bottom total GB backup for one day.  I am trying to recreate this report on OpsCenter but cannot get to combine all the jobs to show only policy name onces and total for that policy.  Please see attachment.

5 Replies

Hello,   I am unsure if this

Hello,

 

I am unsure if this can be done however I will check and let you know.

 

This report was the one we

This report was the one we use to get from Veritas Backup Reporter, I do hope we can get it on this updated version as it suppose to be the upgrade to VBR.  If anyone has any input please let me know.

Can someone help me with

Can someone help me with this?  If not can someone tell me how to format the date so I can work with my DBA to create a custom sql query to pull the data we need for the above report?

 

Also how can I get the list of tables from the Report DB?

For the list of tables from

For the list of tables from Opscenter use the command below

sp_tables

try min and max on the dates

Try setting the start time to min and end time to max.  The dates seem to be creating the extra lines as they are not distinct.