Solved

need a powershell script to add whitelist entries in bulk

Posted on 2014-01-02
10
1,433 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

732 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