none
Export Transport Rules in to CSV format in exchange 2013 ?? RRS feed

  • Question

  • Hi

    i want to export the All Transport rules into CSV format. can any body help me out. As per below link it is stating that it can be exported to only XML.

    Link : http://technet.microsoft.com/en-us/library/bb124410%28v=exchg.150%29.aspx

    Tuesday, April 29, 2014 12:32 PM

Answers

  • Hi,

    Yes, you can export transport rules into a .csv file. I have a test in my environment using Exchange 2013. You just need to change the .xml to .csv.

    $file = Export-TransportRuleCollection
    set-Content -Path "C:\output1.csv" -Value $file.FileData -Encoding Byte

    Besides, I think .xml file is more clear than .csv file to see the transport rules.

    Hope it helps.

    Best regards,


    Amy Wang
    TechNet Community Support


    • Edited by Amy.Wang Wednesday, April 30, 2014 9:37 AM
    • Marked as answer by cara chen Friday, May 9, 2014 1:42 AM
    Wednesday, April 30, 2014 9:26 AM

All replies

  • You should be able to do that, but I don't know if the resulting data will be of any use.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    Tuesday, April 29, 2014 3:54 PM
    Moderator
  • Hi,

    Yes, you can export transport rules into a .csv file. I have a test in my environment using Exchange 2013. You just need to change the .xml to .csv.

    $file = Export-TransportRuleCollection
    set-Content -Path "C:\output1.csv" -Value $file.FileData -Encoding Byte

    Besides, I think .xml file is more clear than .csv file to see the transport rules.

    Hope it helps.

    Best regards,


    Amy Wang
    TechNet Community Support


    • Edited by Amy.Wang Wednesday, April 30, 2014 9:37 AM
    • Marked as answer by cara chen Friday, May 9, 2014 1:42 AM
    Wednesday, April 30, 2014 9:26 AM