Hello, I am looking for PowerShell command where I can add bulk number of IP's into the receive connector of exchange server. I am having problem with below command where the alignment is great concern. All the IP's have to separated by comma. $recCon = get-receiveconnector "EX1\relay" $recCon.remoteIPRanges += "1.1.1.1", "1.1.1.2" set-receiveconnector $recCon -remoteIPranges $recCon.remoteIPRanges Is there any other way where I can use if I have 50 ips in a csv file / txt file?

Hi @Surya kumar , Prepare the CSV file for the IPs you want to add like below: Then you can use the following scripts to import the IPs without overwriting the existing ones. Be sure to replace the first two lines with the file path and connector identity in your environment: $Csv = "C:\temp\IPs.csv" $RC = "EX19\TEST" $IPs = Import-Csv $Csv $RCon = Get-ReceiveConnector $RC $RemoteIPRanges = $RCon.RemoteIPRanges foreach ($IP in $IPs) { $IPEx = $IP.Expression if ($RemoteIPRanges -contains $IPEx) { Write-Host "IP address $($IPEx) already exist in receive connector $($RC)" -ForegroundColor Red } else { $RemoteIPRanges += $IPEx Set-ReceiveConnector $RC -RemoteIPRanges $RemoteIPRanges Write-Host "IP address $($IPEx) added to receive connector $($RC)" -ForegroundColor Green } } I tried testing in my lab environment and can verify that it can work properly: Here's a blog with more detailed instructions and script samples for your reference: Import remote IP addresses to Exchange receive connector . (Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.) If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Put them in a column in a text file and call it IPs.txt for example Then: set-receiveconnector $recCon -remoteIPranges (Get-Content .\IPs.txt) TEST FIRST with a few IPs

Yes, you didnt mention you have existing :) So either add those to the text file as well or: $RecvConn = Get-ReceiveConnector -Identity "EX1\relay" Get-Content "IPs.txt" | foreach {$RecvConn.RemoteIPRanges += "$_"} Set-ReceiveConnector "EX1\relay" -RemoteIPRanges $RecvConn.RemoteIPRanges TEST FIRST

How to add bulk number of IP's into the receive connector of exchange server using powershell

Accepted answer

Yuki Sun-MSFT 41,006 Reputation points

2023-10-30T06:02:00.8866667+00:00
Hi @Surya kumar ,

Prepare the CSV file for the IPs you want to add like below:

Then you can use the following scripts to import the IPs without overwriting the existing ones. Be sure to replace the first two lines with the file path and connector identity in your environment:

$Csv = "C:\temp\IPs.csv" $RC = "EX19\TEST" $IPs = Import-Csv $Csv $RCon = Get-ReceiveConnector $RC $RemoteIPRanges = $RCon.RemoteIPRanges foreach ($IP in $IPs) { $IPEx = $IP.Expression if ($RemoteIPRanges -contains $IPEx) { Write-Host "IP address $($IPEx) already exist in receive connector $($RC)" -ForegroundColor Red } else { $RemoteIPRanges += $IPEx Set-ReceiveConnector $RC -RemoteIPRanges $RemoteIPRanges Write-Host "IP address $($IPEx) added to receive connector $($RC)" -ForegroundColor Green } }

I tried testing in my lab environment and can verify that it can work properly:

Here's a blog with more detailed instructions and script samples for your reference: Import remote IP addresses to Exchange receive connector.
(Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

1 person found this answer helpful.
Surya kumar 340 Reputation points

2023-11-07T06:33:07.9833333+00:00

@Yuki Sun-MSFT

Thanks for your response. It is working as expected. However, could you please clarify is it necessary to enclose the IP's with double quotes???

Yuki Sun-MSFT 41,006 Reputation points

2023-11-08T01:29:33.8533333+00:00

Hi @Surya kumar ,

You mean the double quotes around the IPs in the CSV file? That's not necessary. You can also prepare the file using Excel and save it as the CSV file format.

Surya kumar 340 Reputation points

2023-11-08T04:35:16.6266667+00:00

Thanks @Yuki Sun-MSFT

Can you please check is it possible with txt file? When I tried with txt, I got an error.

Yuki Sun-MSFT 41,006 Reputation points

2023-11-08T06:55:35.0233333+00:00

Hi @Surya kumar ,

Can you please check is it possible with txt file?

Yes. I tested using the syntax provided earlier by Andy and got it work in my lab:

TXT file:

Command:

$RecvConn = Get-ReceiveConnector -Identity "EX19\TEST" Get-Content "C:\temp\IPs.txt" | foreach {$RecvConn.RemoteIPRanges += "$_"} Set-ReceiveConnector "EX19\TEST" -RemoteIPRanges $RecvConn.RemoteIPRanges

Surya kumar 340 Reputation points

2023-11-08T07:44:46.6133333+00:00

I am wondering why it's not working from my end. I am getting the error like: Exception setting "remoteIPRanges": "Cannot convert value "system.object[]" to type "Microsoft.exchange.data.multivaluedproperty`1[Microsoft.exchange.data.IPRange]"

Yuki Sun-MSFT 41,006 Reputation points

2023-11-08T09:33:00.09+00:00

Hi @Surya kumar ,

If your txt file is in the same format as mine, which only contains the IP addresses (one IP address per line with no other characters like comma or period), I'd recommend double confirming the syntax you used to import it.

If it still doesn't work, do you mind sharing the command you are using? Be sure to remove all personal information involved for privacy concerns.

Surya kumar 340 Reputation points

2023-11-08T13:40:51.75+00:00

Hi @Yuki Sun-MSFT

As per my checks, the command executes perfectly if the IPs in the text file are completely new and no overlap with existing ips in the receive connector.

On the other hand, if I have a new ip and overlapped ip in the txt file, then it's not getting executed.

Eg: Existing ip in EX1\relay are: 192.168.1.100

Case 1: In txt file, I have 192.168.1.101 -- Executes perfectly

Case 2: In txt file, I have 192.168.1.100, 192.168.1.101 -- crashes

Please check if it's the same issue from your end. I think the issue is occurring because if-- else conditions not there in place when it comes to importing txt.

Yuki Sun-MSFT 41,006 Reputation points

2023-11-09T01:32:53.8966667+00:00

Hi @Surya kumar ,

Thanks for the share and Yes, I've just checked it from my end and can verify that it's the same. When there are overlapped IP addresses, the error occurs:

Given this, personally I'd recommend just using the CSV file as aforementioned if you need to import overlapped IPs.
Sign in to comment