Forum Discussion
Marvin Oco
Jul 15, 2020Steel Contributor
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 OcoSteel Contributor
thanks VasilMichev
Import-Csv "C:\PS\INBOXRULE\LIST.CSV" | foreach { Get-InboxRule -mailbox $_.UserPrincipalName | Export-Csv -Path c:\PS\INBOXRULE\result.CSV -append}