cancel
Showing results for 
Search instead for 
Did you mean: 

Daily Backup Status Report Base on Policy Name

NYCOADMIN
Level 2

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 5

nbutech
Level 6
Accredited Certified

Hello,

 

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

 

NYCOADMIN
Level 2

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.

NYCOADMIN
Level 2

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?

nbutech
Level 6
Accredited Certified

For the list of tables from Opscenter use the command below

sp_tables

Phantom76
Level 2
Certified

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.