Solved

need a powershell script to add whitelist entries in bulk

Posted on 2014-01-02
10
1,352 Views
Last Modified: 2014-01-08
can someone provide a powershell script for Office 365 that I can use to add in 1000+ whitelist entries. [would like the script to key on a CSV input file.]

thanks in advance,

S.
0
Comment
Question by:siber1
  • 5
  • 5
10 Comments
 
LVL 25

Accepted Solution

by:
Zephyr ICT earned 500 total points
ID: 39753199
Does something like this work for you?

Import-Csv "D:\whitelist.csv"  | foreach { Set-MailboxJunkEmailConfiguration -Identity  $_.Identity -TrustedSendersAndDomains  @{Add='your.user@yourdomain.com'} }

The csv should look something like this:

user1, your.user1@yourdomain.com
user2, your.user2@yourdomain.com
0
 

Author Comment

by:siber1
ID: 39753806
thx Spravtek, but we would mostly be whitelisting IP's or domain names. how can we modify your script to account for that?
0
 
LVL 25

Expert Comment

by:Zephyr ICT
ID: 39753916
I understood your question wrong probably ... Anyway, I will look into the script, I have to go for  a while now.

More information on how to block domains using poweshell can be found here:

http://support.microsoft.com/kb/2545137
0
 

Author Comment

by:siber1
ID: 39755568
hello spravtek any update on this?
0
 
LVL 25

Expert Comment

by:Zephyr ICT
ID: 39755722
Hi, have been looking into this yes, but first I'd like to ask which Office365 plan you have... Do you have an E1 plan or? There seems to be some mixed information regarding availability to the whitelist and such.

Thanks
0
 

Author Comment

by:siber1
ID: 39756583
Hi Spravtek, we have the E3 plan
0
 
LVL 25

Expert Comment

by:Zephyr ICT
ID: 39758604
I'm sorry for the late reaction between posts, weekend and all ...

The reason I'm asking about the E-plan is because you can be using FOPE, so that changes things...

Are you using something like this? http://www.office365advisors.com/fope-blacklists/
0
 

Author Comment

by:siber1
ID: 39759028
actually FOPE was changed to EOP. we are using EOP.

thx
0
 
LVL 25

Expert Comment

by:Zephyr ICT
ID: 39759059
Interesting.... I'm not really following the Office365 story ...

The only thing I could find is this, but how it relates to the EOP, I can't really say, I'd test it if I had Office365, let alone an E-plan.
0
 

Author Comment

by:siber1
ID: 39760927
does anyone else have an idea on this?
0

Join & Write a Comment

Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
In this video we show how to create a Distribution Group in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Recipients >>…
In this video we show how to create a mailbox database in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Servers >> Data…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now