Video Screencast Help

2 Archives - Same Properties

Created: 11 Mar 2013 • Updated: 13 Apr 2013 | 3 comments
This issue has been solved. See solution.

EV 8.0 SP5, from the Vault Console it appears we have two identical archives for the same user.  Is there a way to find out which mailbox is assoiciated to each archive to confirm.

Operating Systems:

Comments 3 CommentsJump to latest comment

Chris Warren's picture

Heya.

I recently put up a SQL query that would give you that information, and then some.  See the following:

https://www-secure.symantec.com/connect/downloads/useful-sql-query

At the end of the query, you have the WHERE:

WHERE
AV.archivename LIKE '%John%'

You can also use =, for example

AV.archivename = 'Smith, John'

It will then return all archives with that name.

I hope this helps.

SOLUTION
Advisor's picture

Thanks for sharing this Chris...

Chris Warren's picture

Did that query help you find what you needed?