01-20-2011 10:05 AM
01-20-2011 10:35 AM
This will show when the Archive was created, when you first enable a mailbox, if the archive doesn't exist, it will create one, so this date usually coincides of when a mailbox was archived
However if you disable/re-enable a user it will not show the date of when they were re-enabled, also you may have a user that has been enabled for archiving, and then move them to a different server via a PST Export and then import, and that won't keep the original created date of that archive, so you would see a newer date of when the new archive was created
SELECT A.ArchiveName, AP.CreatedDate FROM EnterpriseVaultDirectory.dbo.Archive A, EnterpriseVaultDirectory.dbo.Root R, yourVaultStore.dbo.ArchivePoint AP WHERE A.RootIdentity = R.RootIdentity AND R.VaultEntryId = AP.ArchivePointId ORDER BY A.ArchiveName
01-20-2011 10:35 AM
This will show when the Archive was created, when you first enable a mailbox, if the archive doesn't exist, it will create one, so this date usually coincides of when a mailbox was archived
However if you disable/re-enable a user it will not show the date of when they were re-enabled, also you may have a user that has been enabled for archiving, and then move them to a different server via a PST Export and then import, and that won't keep the original created date of that archive, so you would see a newer date of when the new archive was created
SELECT A.ArchiveName, AP.CreatedDate FROM EnterpriseVaultDirectory.dbo.Archive A, EnterpriseVaultDirectory.dbo.Root R, yourVaultStore.dbo.ArchivePoint AP WHERE A.RootIdentity = R.RootIdentity AND R.VaultEntryId = AP.ArchivePointId ORDER BY A.ArchiveName
01-20-2011 10:36 AM
oh and a side note a simple please and thankyou never hurts :)
01-20-2011 11:17 AM
THanks!!!
01-20-2011 11:19 AM
:)
01-20-2011 11:21 AM
Error:
/*------------------------
SELECT A.ArchiveName, AP.CreatedDate
FROM EnterpriseVaultDirectory.dbo.Archive A,
EnterpriseVaultDirectory.dbo.Root R,
yourVaultStore.dbo.ArchivePoint AP
WHERE A.RootIdentity = R.RootIdentity
AND R.VaultEntryId = AP.ArchivePointId
ORDER BY A.ArchiveName
------------------------*/
Msg 208, Level 16, State 1, Line 1
Invalid object name 'yourVaultStore.dbo.ArchivePoint'.
01-20-2011 11:23 AM
You will have to rename "YourVaultStore" to the database name of your vault store
Oh and thats another thing, you will have to run it against each of your Vault Store databases
01-20-2011 11:27 AM
Thanks!
01-20-2011 11:32 AM
Is it possible to find Archive name, created date & suspended state?
01-20-2011 11:53 AM
suspended date is actually held in the hidden message not in the database
i know it was requested at one point to be held in the database but i don't know what came of that
01-20-2011 11:58 AM
Not suspended date, whether archive is in suspended state or not.
01-20-2011 12:03 PM
suspended date or suspended state, neither are held in the database
01-20-2011 12:19 PM
Thanks! I really appreciate your help.