SQL query - Archive last accessed
Hello
We are running EV 9.4. I have the SQL query below.
SELECT
EVDA.Archivename, round(cast(AP.ArchivedItemsSize as float)/1024,2) as 'size of archive in MB',
Ap.ArchivedItems as 'no of archived items',
AP.modifieddate,
eme.MbxAlias,
eme.mbxarchivingstate
FROM archivepoint AP
Inner Join enterprisevaultdirectory.dbo.root EVDR on EVDR.VaultEntryID = AP.ARchivePointID
Inner Join enterprisevaultdirectory.dbo.archive EVDA on EVDA.RootIdentity = EVDR.RootIdentity
JOIN EnterpriseVaultDirectory.dbo.ExchangeMailboxEntry EME on EME.DefaultVaultId = AP.ArchivePointId
WHERE modifieddate < '2015-07-31'
and mbxarchivingstate = '1'
or mbxarchivingstate = '2'
and mbxexchangestate = '1'
order by 'modifieddate'
is it possible to also get "last accessed" info for each archive?