03-11-2013 11:40 AM
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.
Solved! Go to Solution.
03-11-2013 01:10 PM
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.
03-11-2013 01:10 PM
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.
03-12-2013 02:21 AM
Thanks for sharing this Chris...
03-20-2013 10:07 AM
Did that query help you find what you needed?