cancel
Showing results for 
Search instead for 
Did you mean: 

2 Archives - Same Properties

Energy99
Level 3

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Chris_Warren
Level 5
Employee Accredited Certified

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.

View solution in original post

3 REPLIES 3

Chris_Warren
Level 5
Employee Accredited Certified

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.

Arjun_Shelke
Level 6
Employee Accredited

Thanks for sharing this Chris...

Chris_Warren
Level 5
Employee Accredited Certified

Did that query help you find what you needed?