I would like to pass by PowerShell a long list of IP as a whitelist in the EOP Connection Filtering. What is the best way to do it? Thanks

Well, via PowerShell :) For example, if you have them in a CSV file, you can do something like this: Import-CSV blabla.csv | % { Set-HostedConnectionFilterPolicy "Default" -IPAllowList @{Add=$_.IP}; Start-sleep -Milliseconds 500 } You can also concatenate them in a single string, but they all need to be of the same type.

How to pass a list of IP to EOP Connection Filtering automatically

Accepted answer

Vasil Michev 100.2K Reputation points MVP

2021-07-14T11:49:48.493+00:00
Well, via PowerShell :) For example, if you have them in a CSV file, you can do something like this:

Import-CSV blabla.csv | % { Set-HostedConnectionFilterPolicy "Default" -IPAllowList @{Add=$_.IP}; Start-sleep -Milliseconds 500 }

You can also concatenate them in a single string, but they all need to be of the same type.
Please sign in to rate this answer.

1 person found this answer helpful.
Marc 631 Reputation points

2021-07-14T13:52:49.247+00:00

Hi Michev,

thank you for your help.
To test your code I have created a demo tenant.

I have used this code below to connect to the EOP by PowerShell

$UserCredential = Get-Credential $Connect-IPPSSession -Credential $UserCredential -ConnectionUri https://ps.protection.outlook.com/powershell-liveid/

I have just added the path at your code :

Import-CSV -Path .\test.csv | % { Set-HostedConnectionFilterPolicy "Default" -IPAllowList @{Add=$_.IP}; Start-sleep -Milliseconds 500 }

To get a csv file I have created an excel file and saved it as test.csv.

Unfortunately the IP address were not added on the IP Allow list.

Vasil Michev 100.2K Reputation points MVP

2021-07-14T14:49:53.91+00:00

That's not where you need to connect, follow the steps here: https://learn.microsoft.com/en-us/powershell/exchange/connect-to-exchange-online-powershell?view=exchange-ps
Also, forgot to mention that the CSV file needs to have a column named "IP" for the above to work. If you've named it otherwise, replace the corresponding value instead of $_.IP

Marc 631 Reputation points

2021-07-14T17:51:59.033+00:00

Thank you Michev.
It worked.

Andy David - MVP 145.6K Reputation points MVP

2021-07-14T19:11:22.387+00:00

hey @Marc , if you dont mind, please mark @Vasil Michev answer as accepted so this can be closed. Thanks!
Sign in to comment

Share via

How to pass a list of IP to EOP Connection Filtering automatically

0 additional answers