09-17-2015 11:06 AM
Hello,
Please forgive me if this question has been ask in the past, I have search for it and came up with nothing.
I am looking to create a report in Crystal Reports to get the following information:
1. Job Name
2. Completed Status (Successful or not)
3. Job Started
4. Job ended
5. Device and Media used (Media Label(s), Drive Name, Slot
I would like to know which tables are being used for this information.
Software: Backup Exec 2010R3
SQL: 2005
Thank you in advance
Gerald
Solved! Go to Solution.
09-17-2015 12:46 PM
Hi Gerald,
You would need to contact Symantec directly to see if they can assist. THey don't publish the table structure of the BEDB. Your other option is to try get a copy of the BEDB and get an SQL DBA to take a look at it.
I managed to get some information before but it takes a while and I eventually gave up as I didn't understand the structure.
Thanks!
09-17-2015 12:46 PM
Hi Gerald,
You would need to contact Symantec directly to see if they can assist. THey don't publish the table structure of the BEDB. Your other option is to try get a copy of the BEDB and get an SQL DBA to take a look at it.
I managed to get some information before but it takes a while and I eventually gave up as I didn't understand the structure.
Thanks!
09-17-2015 09:06 PM
Upgrade to BE 15 which is the latest version of BE and you can easily get the first four items using BEMCLI.
09-18-2015 08:41 AM
Thank you, just posted them a question.