Forum Discussion

GTK's avatar
GTK
Level 6
9 years ago

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? 

    • Rob_Wilcox1's avatar
      Rob_Wilcox1
      Level 6

      or you can review IIS logs. There are some articles on this site that might help with that.