Forum Discussion

sandeepk's avatar
sandeepk
Level 5
13 years ago
Solved

Enterprise vault SQL database Diagram

HI,

I am using enterprise vault 9.0 for exchange archive. i want to know about SQL Database Diagram which is use in enterprise vault.

Documentation
Enterprise Vault
Information Governance
Roadmap
Troubleshooting
Windows Server (2003-2008)
  • JesusWept3's avatar
    JesusWept3
    13 years ago

    Btw, you know you can generate your own diagrams yeah?
    click new diagrams, add the tables and you'll be good
    the diagrams will link automatically because of the Foreign Key Relationships

    I added a couple myself and it was just fine, cluttered and ugly but  its not going to be anything else

    SQL Diagram.jpg

     

    There are some relationships that are missing obviously
    Like how Root.VaultEntryId maps to ExchangeMailboxEntry.DefaultVaultId

    Just be sure not to add your own relationships as it would definitely take you out of a supported environment and would most likely cause issues

15 Replies

Show More
  • GabeV's avatar
    GabeV
    Level 6
    13 years ago

    Hi Sandeep,

    Any updates on this? Do you need more assistance regarding this topic?

  • JesusWept3's avatar
    JesusWept3
    Level 6
    13 years ago

    Btw, you know you can generate your own diagrams yeah?
    click new diagrams, add the tables and you'll be good
    the diagrams will link automatically because of the Foreign Key Relationships

    I added a couple myself and it was just fine, cluttered and ugly but  its not going to be anything else

    SQL Diagram.jpg

     

    There are some relationships that are missing obviously
    Like how Root.VaultEntryId maps to ExchangeMailboxEntry.DefaultVaultId

    Just be sure not to add your own relationships as it would definitely take you out of a supported environment and would most likely cause issues

  • Dnaik79's avatar
    Dnaik79
    Level 4
    13 years ago

    Hi Sandeep,

    As it is better to create a scope with customer and deside what kind of report they required daily/monthly/yearly basis and just sync up with your SQL admin and do the required custmization from SQl database.Also you grab the more info if you enbaled EV audit from Ev application server.smiley

     

     

  • sandeepk's avatar
    sandeepk
    Level 5
    12 years ago

     

    This information is very helpful for all engineers

    Thank you guys….smileysmiley.