Office 365 URLs and IP address ranges

[dan.it]

Followup to
https://forum.pfsense.org/index.php?topic=125850.msg695115#msg695115

This is still the official list:

https://support.office.com/de-de/article/urls-und-ip-adressbereiche-von-office-365-8548a211-3fe7-47cb-abb1-355ea5aa88a2

MS provides this enormous list of IPs and subnets in some crazy format or XML. I counted 343 entries!!! Do they really know, they need all of these?!

Seems to be more secure, to use a list of FQDNs. But how can I use FQDNs with wildcards like *.office365.com to alias and use them in the pfSense firewall rule set?

I found one posting, someone used Robtex.com to translate a much shorter list into IPs. But that seems not feasible by sheer amount.
Any suggestions?

[Grimson]

@dan.it:

But how can I use FQDNs with wildcards like *.office365.com to alias and use them in the pfSense firewall rule set?

´

You can't. If you want to know why, research how a domain alias works.