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