General Discussion Office 365 and huge list of proxy exceptions

UTM Firewall requires membership for participation - click to join

Thread Info

State Verified Answer
+1 person also asked this people also asked this
Locked Locked
Replies 4 replies
Subscribers 7 subscribers
Views 4973 views
Users 0 members are here

Options

Suggested

This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Office 365 and huge list of proxy exceptions

Erik Puscher over 3 years ago

Hello,

we are migrating to Office 365 including the migration from on premise to online Exchange.

I found this thread:

https://community.sophos.com/utm-firewall/f/general-discussion/101289/office365-deployment-best-practice

Since the last entry is years ago, are there any new solutions for the problem of maintaining these huge lists of exceptions?

It looks like the scripts aren't working anymore.

I think I need days of inserting all these ips, subnets and urls just once. And there may be many typos.

This is a little annoying, since this is the final step towards office 365 and it is such a blocker.

This thread was automatically locked due to age.

Top Replies

Amodin over 3 years ago in reply to Erik Puscher +1 verified

In these types of fields like in my example below, you can import text. What I do is copy/paste text into something like Notepad or Word to format any text I want, which is single column; i.e.: example1…

0 Amodin over 3 years ago

I would probably start with just web exceptions and go from there, and you might be able to use the one for XG: Sophos Firewall: Configure web exceptions for Office 365

Importing those should take just a few minutes versus the absurdity in that link you provided, lol.

OPNSense 64-bit | Intel Xeon 4-core v3 1225 3.20Ghz
16GB Memory | 500GB SSD HDD | ATT Fiber 1GB
(Former Sophos UTM Veteran, Former XG Rookie)
Cancel
Vote Up 0 Vote Down

Cancel
0 Erik Puscher over 3 years ago in reply to Amodin

Sadly this doesnt work an the SG210.

If found a json file from Microsoft

docs.microsoft.com/.../urls-and-ip-address-ranges

Is there somehow a chance to process this file for importing? Via command line?
Cancel
Vote Up 0 Vote Down

Cancel
+1 Amodin over 3 years ago in reply to Erik Puscher

In these types of fields like in my example below, you can import text. What I do is copy/paste text into something like Notepad or Word to format any text I want, which is single column; i.e.:

example1.com

example2.com

example3.com

then paste from Notepad into the import field.

OPNSense 64-bit | Intel Xeon 4-core v3 1225 3.20Ghz
16GB Memory | 500GB SSD HDD | ATT Fiber 1GB
(Former Sophos UTM Veteran, Former XG Rookie)
Cancel
Vote Up +1 Vote Down

Cancel
0 Erik Puscher over 3 years ago in reply to Amodin

Thank you very much. This is a lot easier.

I can process the json to a csv with all the websites/url and import it here.
Cancel
Vote Up 0 Vote Down

Cancel