Forum Discussion

Gerald_Kuiper's avatar
Gerald_Kuiper
Level 3
9 years ago

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
 

2010
Backing Up
Backup and Recovery
Backup Exec
Documentation
Reporting
Roadmap
Windows Server (2003-2008)
  • CraigV's avatar
    CraigV
    9 years ago

    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!

3 Replies

Sort By
  • CraigV's avatar
    CraigV
    Moderator
    9 years ago

    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's avatar
    pkh
    Moderator
    9 years ago

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