Forum Discussion

flyok's avatar
flyok
Level 3
8 years ago

How to export archive to csv

Hi, is it possible to export some items (date, from, subject, ...) from EV archive to CSV file?

  • Hello,

    This is not possible from within EV or SQL. Specific item information like you indicate is stored in the indexes, not in the archive information itself. The only option I can think of is if you have Discovery Accelerator.

    You can then run a search against 1 archive. When done, export the resultset. this will create 3 additional files (after the export completes) (html, txt, xml) where at least the txt file contains such info. This will show (amongst other information) Author, Subject, Content, Mail Date,  NumAttachments and the Original Location (in the mailbox)

    • flyok's avatar
      flyok
      Level 3

      Yes, I know. But it's not handy a lot :-) (eg. very big archive etc.)

      • arnoldmathias's avatar
        arnoldmathias
        Level 4

        Well if only you had mentioned that it is a very big archive instead of asking a generic question :)

        As GertjanA mentioned there is no easy way to do this as the information is not stored in SQL but in the Indexes. You can try and export from the browser (copy paste the results from EV Search) but pagination in Archive Explorer (and infinite scrolling in the new EV Search) makes it much more inconvenient.

        I would second GertjanA and use DA to retrieve this information.

        If the requirement is to do this in bulk and using automation, you may incorporate the EV cmdlet Export-EVArchive to export to PST, followed by a PST import to Exchange and then an export to CSV using Powershell / EWS. Let us know if that is what you are looking for :)