Video Screencast Help

SQL query to find when user mailbox is enabled in EV?

Created: 20 Jan 2011 • Updated: 21 Jan 2011 | 12 comments
This issue has been solved. See solution.

SQL query to find when user mailbox is enabled in EV?

Comments 12 CommentsJump to latest comment

JesusWept3's picture

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
SOLUTION
JesusWept3's picture

oh and a side note a simple please and thankyou never hurts :)

Rajesh.Velagapudi@aps.com's picture

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'.

JesusWept3's picture

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

Rajesh.Velagapudi@aps.com's picture

Is it possible to find Archive name, created date & suspended state?

JesusWept3's picture

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

JesusWept3's picture

suspended date or suspended state, neither are held in the database