Highlighted

Need to create report in Crystal Reports

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
 

1 Solution

Accepted Solutions
Accepted Solution!

Hi Gerald, You would need to

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!

View solution in original post

3 Replies
Accepted Solution!

Hi Gerald, You would need to

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!

View solution in original post

Upgrade to BE 15 which is the

Upgrade to BE 15 which is the latest version of BE and you can easily get the first four items using BEMCLI.

Thank you, just posted them a

Thank you, just posted them a question.