Forum Discussion

Mohit_Pal's avatar
Mohit_Pal
Level 3
11 years ago
Solved

Informatiion about the archives items whose stub is deleted

Hi,

We have a requirement where we have to find out the details of the emails which exist in the vault and their corresponding sizes whose stubs has been deleted by the users. Any way we can find this information? May be by using a SQl Query?

Thanks

Enterprise Vault
Evaluating
Information Governance
Reporting
Windows Server (2003-2008)
  • Rob_Wilcox1's avatar
    Rob_Wilcox1
    11 years ago

    It isn't stored in SQL.

    What you would have to do is write some code which enumerated all of the archived items in an archive, and kept them in a list, then you'd have to enumerate every item in a mailbox.. and record the savesetID for each of them.  Compare the lists.  Bingo.

4 Replies

  • Mohit_Pal's avatar
    Mohit_Pal
    Level 3
    11 years ago

    I am new to EV. Can you tell me if their is a way to check that? If they do exist in SQL, how do we retrieve the information?

  • Rob_Wilcox1's avatar
    Rob_Wilcox1
    Level 6
    11 years ago

    It isn't stored in SQL.

    What you would have to do is write some code which enumerated all of the archived items in an archive, and kept them in a list, then you'd have to enumerate every item in a mailbox.. and record the savesetID for each of them.  Compare the lists.  Bingo.