02-28-2013 02:50 PM
Hi,
I am looking for a way to get trending data over time from Symantec Backup Exec 2010 R2. I was thinking of creating a DB connected Excel pivot table but am not sure what tables to use to get the information that I am looking for. I would like to be able to build line charts and such on the pivot table to be able to display it on a SharePoint site.
The information that I am looking for:
I would like to be able to build a line graph with historical information from the BEDB
Thanks in advance
03-01-2013 01:08 AM
Hello Waynski,
In BE 2010 there is feature called Reports where you can also pull up and display the reports in Graphical format (Graphs, Pie chart, Bar graph).
Please refer to the Admin guide to know more about it. Here is the link to the Admin guide:
http://www.symantec.com/docs/DOC2211 : Backup Exec 2010 R2/R3 Administrator's Guide (English)
Following is some of the information taken from the Admin guide which I think will help you.
03-01-2013 02:33 AM
...you might want to look into Ops Center Analytics which can do graphing and trending for you. BE's reporting functionality is poor. We ended up going with a third party application which worked well, and will send you a PM if need-be.
Thanks!
03-05-2013 04:17 PM
Thank you for the responses.
The reporting feature in backup exec does not seem to provide for what I am looking to do. I am looking to be able to place either an excel pivot table with graph or a SQL reporting server view to our SharePoint site so that it can be readily viewed. On the view I would like to have a line graph that shows the job names, total data (In MB) for the job and the time and date. This way, when the data is refreshed, the line on the graph will reflect whether the backup is now larger or smaller.
What are the tables that are used to store the above information? Is there a view already set up that would contain this information?
Thanks!
03-05-2013 06:27 PM
Symantec does not publish the schema of the BEDB which can change without notice and does not recommend that users access the BEDB directly.