Forum Discussion

FlartyBartFast's avatar
FlartyBartFast
14 years ago

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


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
Basics
Enterprise Vault
How to
Information Governance
Reporting
Restore
Tip-How to
  • JesusWept3's avatar
    JesusWept3
    14 years ago
    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

3 Replies

Sort By
  • RahulG's avatar
    RahulG
    Level 6
    14 years ago
    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's avatar
    AndrewB
    Moderator
    14 years ago

    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's avatar
    JesusWept3
    Level 6
    14 years ago
    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