11-17-2010 10:00 AM
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.
11-18-2010 05:53 AM
Hello,
I am unsure if this can be done however I will check and let you know.
11-22-2010 12:13 PM
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.
12-09-2010 10:18 AM
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?
03-21-2011 09:28 PM
For the list of tables from Opscenter use the command below
sp_tables
03-24-2011 09:49 PM
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.