Exchange 2010 – Export details about e-mails in the DB RRS feed

  • General discussion

  • Hi

    We have an Exchange 2010 server (v14.03.0195.001) and now we have a need for doing an extended report of all the e-mails received between 1 March (DateStart) and 1 Sep 2014 (DateEnd).

    I am looking for a script (or program) exporting info about all the messages. The script should work like:

    1: For each mailbox dump the content to a file equal %User%.csv (Comma or TAB separated)

    2: For each message received between %DateStart% and %DateEnd% write one line to the file – the line should contain:

    A: Time received (preferable in the format YYYY.MM.DD HH.MM.SS)
    B: The IP-address the e-mail was sent from – retrieved from the message header (we subscribe to a cloud spam / antivirus service and all incoming e-mails are received from this company's IP address - this IP-address don't make sense)
    If easier all the IP-addresses the e-mail have "gone through" can be listed separated with ";")
    C: E-mail address the message was sent to
    D: Subject
    E: Name of all attachments separated with ";"

    Nice if the script will report to the screen during the run:

    Username / user number and how many messages has been listed to the %User%.csv file (update for each 1000? message)

    I am ready to pay some money for a working script or buy a "report generator" which can be used for this purpose. Nice if you have some advice.

    Best regards Harald

    • Edited by Haral Saturday, September 6, 2014 7:23 AM
    Friday, September 5, 2014 7:22 PM