Query to list both old and new archiveid after a "move archive" ?

[FreKac2]

Hi,

Do anyone have a query that will list both the old and new archiveid for a user?

The old or new is easy to find using the exchangemailboxentry table but getting both seem to be  trickier ;)

Br,

Fredrik

[RahulG]

You may instead try the following query which would give you the date when the user as enabled for archiving , through which you can determine if the user is old or new

http://www.symantec.com/business/support/index?page=content&id=TECH55159

[Chris_Alleman]

Hi Fredrik,

I believe this SQL query will get you what you are looking for:

select archive.archivename, root.vaultentryid from archive, root
where archivename like '%<archive name>%' and archive.rootidentity = root.rootidentity

Hope this helps!

-Chris

[Percy_Vere]

use enterprisevaultdirectory

select * from archive where archivename like'%surname%' 

The query will list all archives for that user (just edit the surname) and you can then view each of the VaultID's.

[FreKac2]

Thanks guys, that solves it to 99%.

The only problem left is if the display name is the same but it's actually two different users.

So it would be great to be able to match against e.g. MbxNTUser or other more "unique" attribute.

The only other column that I can see that can be used in the archive table is the rootidentity.

Is there any way to get the different root identities matching something more unique than display name?

Thanks

[JesusWept3 · Accepted solution]

Personally i'd use this query

 

USE EnterpriseVaultDirectory
SELECT AH.VaultName "Source Archive Name",
       AH.VaultEntryID "Source Archive ID",
       AH.SiteName "Source Site Name",
       AH.VaultStoreName "Source Vault Store",
       AMH.DestinationVaultName "Destination Vault Name",
       AMH.DestinationVaultEntryId "Destination Archive ID",
       AMH.DestinationSiteName "Destination Site Name",
       AMH.DestinationVaultStoreName "Destination Vault Store"
FROM   ArchiveHistory AH, ArchiveMoveHistory AMH
WHERE  AH.ArchiveHistoryIdentity = AMH.ArchiveHistoryIdentity
  AND  AH.VaultName = 'my User'

[FreKac2]

You're the man JW2 ;)