Jul 15 2020 12:44 AM
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 }
Jul 15 2020 08:46 AM
SolutionYou're overwriting the CSV file on each iteration. Add the -Append switch after Export-CSV.
Jul 15 2020 08:32 PM
thanks @Vasil Michev
Import-Csv "C:\PS\INBOXRULE\LIST.CSV" | foreach { Get-InboxRule -mailbox $_.UserPrincipalName | Export-Csv -Path c:\PS\INBOXRULE\result.CSV -append}
Jul 15 2020 08:46 AM
SolutionYou're overwriting the CSV file on each iteration. Add the -Append switch after Export-CSV.