Solved

need a powershell script to add whitelist entries in bulk

Posted on 2014-01-02
10
1,450 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 

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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Uncontrolled local administrators groups within any organization pose a huge security risk. Because these groups are locally managed it becomes difficult to audit and maintain them.
Group policies can be applied selectively to specific devices with the help of groups. Utilising this, it is possible to phase-in group policies, over a period of time, by randomly adding non-members user or computers at a set interval, to a group f…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

707 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