Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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?