cancel
Showing results for 
Search instead for 
Did you mean: 

(Entprs Vault 7.5) - How do I : Sort by 'youngest archive date' ?

FlartyBartFast
Not applicable

We are decommisioning our EV product and need to PST off any current users archives.

Over serveral years many (about half) of our EV users -exchange mailboxes have been deleted (as they have left.)
(Thier archives are still sitting there, but havnt updated for years of course.)

Naturally, We will only pst off existing users.

Current proceedure for finding last archived date (one by one approach)
[Vault Console] > Archives > Exchange Mailbox > "A-C users" Right click a user > Properties

This is great if I want to go down the lists of 1600 users one at a time, keeping a record (cant find an ev report that does this) of each one on paper.

This surely must be a common requirement but I cant find anything on this site or the net describing how to do.

Any help appreciated.

jdog
1 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified
Try this query i wrote for you, just change the GetDate() to be how many days old it must be

USE EnterpriseVaultDirectory
SELECT  A.ArchiveName AS "Archive Name",
    EME.LastModified AS "Last Synchronized",
    IV.YoungestArchivedDateUTC AS "Last Item Archived On",
    IV.OldestArchivedDateUTC AS "First Item Archived On",
    IV.OldestItemDateUTC AS "Oldest Items Sent Date",
    IV.YoungestItemDateUTC AS "Youngest Items Sent Date"
FROM Archive A, Root R, ExchangeMailboxEntry EME, IndexVolume IV
WHERE IV.RootIdentity = R.RootIdentity
  AND R.RootIdentity = A.RootIdentity
  AND R.VaultEntryID = EME.DefaultVaultID
  AND IV.YoungestArchivedDateUTC < GetDate()-30
ORDER BY IV.YoungestArchivedDateUTC DESC
https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

3 REPLIES 3

RahulG
Level 6
Employee
How to use the Vault Store Usage Reporter for Enterprise Vault (EV) - http://seer.entsupport.symantec.com/docs/273270.htm
The vault store summary report as a colum for the last modified
Also you can use the following SQL Query
(MAKING SURE ALL INDEXES FOR MAILBOXES ETC ARE UP TO DATE FIRST BEFORE USE)
Whilst selecting the EnterpriseVaultDirectory database run this query
select ArchiveName, YoungestItemDateUTC from IndexView
This will produce a list from SQL of all archives and the last date an item was archived from the mailbox


AndrewB
Moderator
Moderator
Partner    VIP    Accredited

if you sort your list of archives by "bill usage to" you should be able to identify all the orphaned archives because it'll say "account unknown"

JesusWept3
Level 6
Partner Accredited Certified
Try this query i wrote for you, just change the GetDate() to be how many days old it must be

USE EnterpriseVaultDirectory
SELECT  A.ArchiveName AS "Archive Name",
    EME.LastModified AS "Last Synchronized",
    IV.YoungestArchivedDateUTC AS "Last Item Archived On",
    IV.OldestArchivedDateUTC AS "First Item Archived On",
    IV.OldestItemDateUTC AS "Oldest Items Sent Date",
    IV.YoungestItemDateUTC AS "Youngest Items Sent Date"
FROM Archive A, Root R, ExchangeMailboxEntry EME, IndexVolume IV
WHERE IV.RootIdentity = R.RootIdentity
  AND R.RootIdentity = A.RootIdentity
  AND R.VaultEntryID = EME.DefaultVaultID
  AND IV.YoungestArchivedDateUTC < GetDate()-30
ORDER BY IV.YoungestArchivedDateUTC DESC
https://www.linkedin.com/in/alex-allen-turl-07370146