Forum Discussion

Marvin Oco's avatar
Marvin Oco
Steel Contributor
Jul 15, 2020
Solved

Exporting inbox rule from mailbox csv list and export result to CSV file

trying to Export inbox rule from 50 mailbox csv list and export result to CSV file but the resulting CSV file only shows 1 user. please check script:

 

Import-Csv "C:\PS\INBOXRULE\LIST.CSV" | foreach { Get-InboxRule -mailbox $_.UserPrincipalName | Export-Csv -Path c:\PS\INBOXRULE\result.CSV }

  • You're overwriting the CSV file on each iteration. Add the -Append switch after Export-CSV.

  • You're overwriting the CSV file on each iteration. Add the -Append switch after Export-CSV.

    • Marvin Oco's avatar
      Marvin Oco
      Steel Contributor

      thanks VasilMichev

       

      Import-Csv "C:\PS\INBOXRULE\LIST.CSV" | foreach { Get-InboxRule -mailbox $_.UserPrincipalName | Export-Csv -Path c:\PS\INBOXRULE\result.CSV -append}

Resources