cancel
Showing results for 
Search instead for 
Did you mean: 

Need to create report in Crystal Reports

Gerald_Kuiper
Level 3

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 ACCEPTED SOLUTION

Accepted Solutions

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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 3

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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!

pkh
Moderator
Moderator
   VIP    Certified

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

Gerald_Kuiper
Level 3

Thank you, just posted them a question.