XML parsing

PowerShell Help
1

I have an XML file with a list of IPs and URLs for Office 365. I was trying to parse by just “URL” using XML casting but I couldnot filter for just the domains.

Any thoughts?

$xdoc=[xml](get-content office365.ml) $xdoc.products.product.addresslist ## is where I'm stuck

2603:1020:201::37
2603:1020:201::204
2603:1030:1000::1d
2603:1030:f00::17
2603:1040:200::5e4
2603:1040:401::301
2603:1040:601::60f
2603:1040:a01::1e
2603:1040:c01::28
2603:1050:1::15
2620:1ec:c11::204
2620:1ec:c11::205
2a01:111:202c::204
2a01:111:202c::205
2a01:111:f100:2002::8975:2d34
2a01:111:f100:2002::8975:2da8
2a01:111:f100:4001::4625:a55a
2a01:111:f100:7000::6fdd:6cd5
2a01:111:f100:a004::bfeb:8ba7
2a01:111:f406:400::/64
2a01:111:f406:1c01::/64
2a01:111:f406:2402::/64
2a01:111:f406:8800::/64
2a01:111:f406:9400::/64
2a01:111:f406:a804::/64
2a01:111:f406:b401::/64

13.69.187.20/32
13.70.184.242/32
13.71.155.176/32
13.75.153.216/32
13.76.140.48/32
13.78.114.39/32
13.85.84.102/32
13.88.248.161/32
13.88.254.212/32
13.94.209.165/32
23.103.183.15/32
40.68.166.51/32
40.74.130.243/32
40.74.138.42/32
40.76.54.124/32
40.86.230.88/32
40.114.192.209/32
40.117.226.146/32
40.126.236.216/32
40.127.79.139/32
52.169.109.48/32
52.172.13.171/32
52.172.152.100/32
52.172.153.104/32
52.175.25.142/32
52.232.128.169/32
104.40.225.204/32
104.41.62.54/32
104.211.103.207/32
104.211.229.230/32
104.214.38.136/32
104.215.194.17/32
134.170.27.86/32
134.170.48.20/32
134.170.48.22/32
134.170.65.86/32
134.170.170.86/32
137.116.172.39/32
137.135.65.72/32
191.235.87.181/32
191.237.40.220/32

*broadcast.officeapps.live.com
*excel.officeapps.live.com
*onenote.officeapps.live.com
*powerpoint.officeapps.live.com
*view.officeapps.live.com
*visio.officeapps.live.com
*word-edit.officeapps.live.com
*word-view.officeapps.live.com
*.cdn.office.net

eus-004.www.sway.com
eus-005.www.sway.com
eus-006.www.sway.com
eus-007.www.sway.com
eus-008.www.sway.com
eus-009.www.sway.com
eus-00a.www.sway.com
eus-00b.www.sway.com
eus-00c.www.sway.com
eus-00d.www.sway.com
eus-00e.www.sway.com

wus-002.www.sway.com
wus-003.www.sway.com
wus-004.www.sway.com
wus-005.www.sway.com
wus-006.www.sway.com
wus-007.www.sway.com
wus-008.www.sway.com
wus-009.www.sway.com
wus-00a.www.sway.com
wus-00b.www.sway.com
wus-00c.www.sway.com
wus-00d.www.sway.com
wus-00e.www.sway.com

eus-www.sway-extensions.com
wus-www.sway-extensions.com
c.microsoft.com
c1.microsoft.com
prod.msocdn.com

40.76.22.51/32
40.76.30.255/32
40.76.213.143/32
40.76.216.125/32
40.76.221.181/32
40.76.222.175/32
40.83.185.108/32
40.114.8.214/32
40.114.14.121/32
40.114.15.142/32
40.114.45.182/32
40.114.40.12/32
40.114.51.204/32
40.114.51.239/32
40.118.210.94/32
40.112.188.120/32
40.118.131.134/32
40.118.135.86/32
40.118.131.27/32
40.118.209.10/32
104.41.155.129/32
104.210.43.160/32
137.135.51.71/32
137.135.52.204/32
138.91.155.70/32
138.91.159.117/32
138.91.160.172/32
138.91.245.66/32

13.107.6.160/32
13.107.9.160/32
23.97.56.236/32
23.97.78.215/32
40.76.80.180/32
40.112.223.206/32
40.127.139.229/32
104.40.214.0/32
104.43.235.252/32

tasks.office.com
cus-000.tasks.osi.office.net
ea-000.tasks.osi.office.net
eus-zzz.tasks.osi.office.net
neu-000.tasks.osi.office.net
sea-000.tasks.osi.office.net
weu-000.tasks.osi.office.net
wus-000.tasks.osi.office.net
www.outlook.com
controls.office.com
outlook.office365.com
ajax.aspnetcdn.com
prod.msocdn.com
clientlog.portal.office.com

evsecure-aia.verisign.com
sa.symcb.com
sd.symcb.com
*.omniroot.com
*.verisign.com
*.symcb.com
*.symcd.com
*.verisign.net
*.geotrust.com
*.entrust.net
*.public-trust.com
http://EVIntl-ocsp.verisign.com
http://EVSecure-ocsp.verisign.com
http://isrg.trustid.ocsp.identrust.com
http://ocsp.digicert.com
http://ocsp.entrust.net

http://ocsp.globalsign.com/ExtendedSSLSHA256CACross

http://ocsp.globalsign.com/rootr1
http://ocsp.globalsign.com/rootr2
http://ocsp2.globalsign.com/rootr3
http://ocsp.int-x3.letsencrypt.org/
http://ocsp.msocsp.com
http://ocsp.omniroot.com/baltimoreroot
http://ocsp2.globalsign.com/gsextendvalsha2g3r3

http://ocsp2.globalsign.com/gsorganizationvalsha2g2

http://ocsp2.globalsign.com/gsorganizationvalsha2g3

http://ocsp2.globalsign.com/rootr3
http://ocspx.digicert.com
http://s2.symcb.com
http://sr.symcd.com
http://su.symcd.com
http://vassg142.ocsp.omniroot.com
http://cdp1.public-trust.com/CRL/Omniroot2025.crl
http://crl.entrust.net/2048ca.crl
http://crl.entrust.net/g2ca.crl
http://crl.entrust.net/level1k.crl
http://crl.entrust.net/rootca1.crl

http://crl.globalsign.com/gs/gsextendvalsha2g3r3.crl

http://crl.globalsign.com/gs/gsorganizationvalsha2g2.crl

http://crl.globalsign.com/gsorganizationvalsha2g3.crl

http://crl.globalsign.com/root.crl
http://crl.globalsign.net/root-r2.crl
http://crl.globalsign.com/root-r3.crl
http://crl.globalsign.net/root.crl
http://crl.identrust.com/DSTROOTCAX3CRL.crl

http://crl.microsoft.com/pki/mscorp/crl/msitwww1.crl

http://crl.microsoft.com/pki/mscorp/crl/msitwww2.crl

http://crl3.digicert.com/DigiCertCloudServicesCA-1-g1.crl

http://crl3.digicert.com/DigiCertGlobalRootCA.crl
http://crl3.digicert.com/sha2-ev-server-g1.crl
http://crl3.digicert.com/sha2-ha-server-g5.crl
http://crl3.digicert.com/ssca-sha2-g5.crl

http://crl4.digicert.com/DigiCertCloudServicesCA-1-g1.crl

http://crl4.digicert.com/DigiCertGlobalRootCA.crl

http://crl4.digicert.com/DigiCertHighAssuranceEVRootCA.crl

http://crl4.digicert.com/sha2-ev-server-g1.crl
http://crl4.digicert.com/sha2-ha-server-g5.crl
http://crl4.digicert.com/ssca-sha2-g5.crl
http://EVIntl-crl.verisign.com/EVIntl2006.crl
http://EVSecure-crl.verisign.com/pca3-g5.crl

http://mscrl.microsoft.com/pki/mscorp/crl/msitwww1.crl

http://mscrl.microsoft.com/pki/mscorp/crl/msitwww2.crl

http://s1.symcb.com/pca3-g5.crl
http://sr.symcb.com/sr.crl
http://su.symcb.com/su.crl
http://vassg142.crl.omniroot.com/vassg142.crl
http://aia.entrust.net/l1k-chain256.cer
http://apps.identrust.com/roots/dstrootcax3.p7c
https://cacert.a.omniroot.com/vassg142.crt
https://cacert.a.omniroot.com/vassg142.der
https://cacert.omniroot.com/baltimoreroot.crt
https://cacert.omniroot.com/baltimoreroot.der

http://cacerts.digicert.com/DigiCertCloudServicesCA-1.crt

http://cacerts.digicert.com/DigiCertSHA2ExtendedValidationServerCA.crt

http://cacerts.digicert.com/DigiCertSHA2HighAssuranceServerCA.crt

http://cacerts.digicert.com/DigiCertSHA2SecureServerCA.crt

http://cert.int-x3.letsencrypt.org/
http://EVIntl-aia.verisign.com/EVIntl2006.cer

http://secure.globalsign.com/cacert/gsextendvalsha2g2r2.crt

http://secure.globalsign.com/cacert/gsextendvalsha2g3r3.crt

http://secure.globalsign.com/cacert/gsorganizationvalsha2g2r1.crt

http://secure.globalsign.com/cacert/gsorganizationvalsha2g3.crt

http://sr.symcb.com/sr.crt
http://su.symcb.com/su.crt

https://www.digicert.com/CACerts/DigiCertGlobalRootCA.crt

https://www.digicert.com/CACerts/DigiCertHighAssuranceEVRootCA.crt

http://www.microsoft.com/pki/mscorp/msitwww1.crt
http://www.microsoft.com/pki/mscorp/msitwww2.crt

*.aadrm.com
*.activedirectory.windowsazure.com
*.adhybridhealth.azure.com
*.azurerms.com
*.blob.core.windows.net
*.cloudapp.net
*.glbdns.microsoft.com
*.live.com
*.microsoft.com
*.microsoftonline.com
*.microsoftonline-p.com
*.microsoftonline-p.net
*.msecnd.net
*.msedge.net
*.msocdn.com
*.office.com
*.office.net
*.office365.com
*.onmicrosoft.com
*.phonefactor.net
*.portal.cloudappsecurity.com
*.queue.core.windows.net
*.servicebus.windows.net
.table.core.windows.net
.windows.net
account.activedirectory.windowsazure.com
account.office.net
accounts.office.net
adminwebservice.microsoftonline.com
agent.office.net
amp.azure.net
analytics.localytics.com
api.localytics.com
api.office.com
appsforoffice.microsoft.com
assets.onestore.ms
auth.gfx.ms
browser.pip.aria.microsoft.com
c.microsoft.com
c1.microsoft.com
clientconfig.microsoftonline-p.net
clientlog.portal.office.com
compliance.outlook.com
connect.facebook.net
contentstorage.osi.office.net
dc.services.visualstudio.com
dgps.support.microsoft.com
ecn.dev.virtualearth.net
equivio.office.com
equivioprod.cloudapp.net
firstpartyapps.oaspapps.com
graph.microsoft.com
graph.Windows.net
groupsapi2-prod.outlookgroups.ms
groupsapi3-prod.outlookgroups.ms
groupsapi4-prod.outlookgroups.ms
groupsapi-prod.outlookgroups.ms
hip.microsoftonline-p.net
home.office.com
liverdcxstorage.blob.core.windowsazure.com
login.microsoftonline.com
login.windows.net
manage.office.com
management.azure.com
mem.gfx.ms
mscrl.microsoft.com
nexus.officeapps.live.com
nexusrules.officeapps.live.com
office365servicehealthcommunications.cloudapp.net
office365zoom.cloudapp.net
outlook.office365.com
outlook.uservoice.com
platform.linkedin.com
policykeyservice.dc.ad.msft.net
portal.microsoftonline.com
portal.office.com
prod.firstpartyapps.oaspapps.com.akadns.net
prod.msocdn.com
products.office.com
protection.office.com
provisioningapi.microsoftonline.com
rink.hockeyapp.net
sdk.hockeyapp.net
secure.aadcdn.microsoftonline-p.com
signup.microsoft.com
support.content.office.net
support.office.com
technet.microsoft.com
telemetry.remoteapp.windowsazure.com
telemetryservice.firstpartyapps.oaspapps.com
templates.office.com
video.osi.office.net
videocontent.osi.office.net
videoplayercdn.osi.office.net
vortex.data.microsoft.com
wus-firstpartyapps.oaspapps.com
www.office.com
www.remoteapp.windowsazure.com
zoom-cs-prod.cloudapp.net

2603:1020:200::682f:a1d8
2603:1020:201::3c4
2603:1030:603::6a
2603:1030:603::72
2603:1030:a02::118
2603:1040:200::111
2603:1040:400::5d
2603:1040:400::5e
2603:1040:400::7b
2603:1040:601::1e7
2801:80:1d0:1c00::/64
2a01:111:2003::/48
2a01:111:200a:a::/64
2a01:111:202c::/48
2a01:111:202e::/48
2a01:111:202e::190
2a01:111:202e::191
2a01:111:202e::156
2a01:111:202d::/48
2a01:111:2035:8::/64
2a01:111:f100:1002::4134:c440
2a01:111:f100:1002::4134:d9ee
2a01:111:f100:1004::4134:f0c8
2a01:111:f100:2002::8975:2c33
2a01:111:f100:2002::8975:2d11
2a01:111:f100:2002::8975:2d98
2a01:111:f100:3002::8987:320c
2a01:111:f100:3002::8987:3552
2a01:111:f100:4001::4625:61ea
2a01:111:f100:4001::4625:a1e3
2a01:111:f100:4001::4625:a248
2a01:111:f100:6000::4134:b84b
2a01:111:f100:7000::6fdd:682b
2a01:111:f100:7000::6fdd:6b20
2a01:111:f100:7000::6fdd:6b76
2a01:111:f100:7000::6fdd:6fc4
2a01:111:f100:8000::4134:941b
2a01:111:f100:8001::d5c7:8077
2a01:111:f102:8001::1761:4237
2a01:111:f102:8001::1761:4daf
2a01:111:f100:a000::5ef5:6c55
2a01:111:f100:a001::a83f:5c85
2a01:111:f100:a004::bfeb:8c89
2a01:111:f100:a004::bfeb:8deb
2a01:111:f406:1::/64
2a01:111:f406:1000::/64
2a01:111:f406:1004::/64
2a01:111:f406:1801::/64
2a01:111:f406:1805::/64
2a01:111:f406:3404::/64
2A01:111:F406:8000::/64
2a01:111:f406:8801::/64
2a01:111:f406:a003::/64
2a01:111:f406:c00::/64
2a01:111:f100:1002::4134:d93c
2a01:111:f100:4001::4625:a4b4
2a01:111:f100:a004::bfeb:8cb8
2603:1020:201::5f2
2a01:111:f100:7000::6fdd:699d
2a01:111:f102:8001::1761:4f8a
2a01:111:f100:3002::8987:358e
2a01:111:f100:2002::8975:2cbc
2603:1040:601::4e
2603:1040:401::57

13.71.145.114/32
13.71.151.88/32
13.76.218.117/32
13.76.219.191/32
13.76.219.210/32
13.78.120.69/32
13.78.120.70/32
13.78.120.99/32
13.84.219.100/32
13.84.222.249/32
13.88.17.54/32
13.91.98.185/32
13.92.181.66/32
13.92.236.241/32
13.93.164.45/32
13.107.6.156/31
13.107.7.190/31
13.107.9.156/31
23.96.240.104/32
23.96.251.50/32
23.96.253.65/32
23.97.61.137/32
23.97.66.55/32
23.97.78.94/32
23.97.150.21/32
23.97.152.190/32
23.97.209.97/32
23.99.109.44/32
23.99.109.64/32
23.99.116.116/32
23.99.121.207/32
23.100.86.91/32
23.101.14.229/32
23.101.30.126/32
23.102.4.253/32
23.102.155.140/32
40.76.1.176/32
40.76.8.142/32
40.76.12.4/32
40.76.12.162/32
40.83.120.174/32
40.83.185.155/32
40.83.185.230/32
40.83.189.49/32
40.84.145.72/32
40.113.8.255/32
40.113.10.78/32
40.113.11.93/32
40.113.14.159/32
40.117.100.187/32
40.117.144.240/32
40.117.151.29/32
40.117.229.133/32
40.117.229.194/32
40.121.144.182/32
40.122.168.103/32
52.163.93.38/32
52.178.144.25/32
52.178.146.67/32
52.187.78.144/32
65.52.26.28/32
65.52.148.27/32
65.52.160.218/32
65.52.184.75/32
65.52.196.64/32
65.52.219.207/32
65.52.240.200/32
65.55.239.168/32
70.37.97.234/32
94.245.108.85/32
94.245.117.53/32
104.40.178.127/32
104.40.179.160/32
104.41.207.73/32
104.42.225.143/32
104.42.230.91/32
104.42.231.28/32
104.43.140.223/32
104.45.11.195/32
104.45.214.112/32
104.46.1.211/32
104.46.38.64/32
104.46.50.125/32
104.47.156.62/32
104.209.35.177/32
104.209.190.8/32
104.210.4.77/32
104.210.40.87/32
104.210.212.243/32
104.214.35.244/32
104.214.144.62/32
104.214.144.252/32
104.214.145.173/32
104.214.146.199/32
104.215.146.200/32
104.215.198.144/32
111.221.104.43/32
111.221.111.196/32
137.116.66.126/32
137.116.81.187/32
137.116.156.3/32
138.91.61.107/32
157.55.80.94/32
157.55.145.0/25
157.55.155.0/25
157.55.177.39/32
157.55.184.223/32
157.55.227.192/26
168.61.146.25/32
168.61.149.17/32
168.61.170.80/32
168.61.172.71/32
168.62.29.225/32
168.62.43.8/32
168.62.104.83/32
168.62.106.224/32
168.62.204.209/32
168.63.18.79/32
168.63.29.74/32
168.63.92.133/32
168.63.100.61/32
168.63.138.56/32
168.63.172.54/32
168.63.213.238/32
191.236.88.160/32
191.236.155.80/32
191.237.218.239/32
191.238.160.173
191.238.177.236/32
207.46.73.250/32
207.46.134.255/32
207.46.141.38/32
207.46.153.155/32
207.46.216.54/32
213.199.128.119/32

*.adhybridhealth.azure.com
*.blob.core.windows.net
*.cloudapp.net
*.microsoft.com
*.microsoftonline.com
*.microsoftonline-p.com
*.microsoftonline-p.net
*.msecnd.net
*.Portal.cloudappsecurity.com
*.queue.core.windows.net
*.servicebus.windows.net
.table.core.windows.net
.windows.net
account.activedirectory.windowsazure.com
accesscontrol.windows.net
adminwebservice.microsoftonline.com
Api.login.microsoftonline.com
clientconfig.microsoftonline-p.net
device.login.microsoftonline.com
enterpriseregistration.windows.net
equivio.office.com
equivioprod.cloudapp.net
hip.microsoftonline-p.net
Hipservice.microsoftonline.com
login.microsoft.com
Login.microsoftonline.com
logincert.microsoftonline.com
Loginex.microsoftonline.com
login-us.microsoftonline.com
login.microsoftonline-p.com
login.windows.net
management.azure.com
mscrl.microsoft.com
nexus.microsoftonline-p.com
office365servicehealthcommunications.cloudapp.net
office365zoom.cloudapp.net
policykeyservice.dc.ad.msft.net
provisioningapi.microsoftonline.com
secure.aadcdn.microsoftonline-p.com
Stamp2.login.microsoftonline.com
zoom-cs-prod.cloudapp.net

2603:1020:201::4a0
2603:1020:201::4a1
2603:1020:201::4a2
2603:1020:201::4a3
2603:1020:201::4a4
2603:1020:201::4a5
2603:1020:201::4a6
2603:1020:201::4a7
2603:1020:201::4aa
2603:1020:201::581
2603:1020:201::583
2603:1020:201::584
2603:1020:201::586
2603:1020:201::588
2603:1020:201::589
2603:1020:201::58a
2603:1020:201::58b
2603:1020:201::58c
2603:1020:201:2::/64
2603:1020:201:3::/64
2603:1030:7::2c
2603:1030:7::2d
2603:1030:7::2f
2603:1030:7::30
2603:1030:7::34
2603:1030:7::3f
2603:1030:7::40
2603:1030:7::41
2a01:111:2005:6::/64
2a01:111:f100:1002::4134:d89f
2a01:111:f100:1002::4134:d944
2a01:111:f100:1002::4134:d95f
2a01:111:f100:1002::4134:da55
2a01:111:f100:1002::4134:da5c
2a01:111:f100:1002::4134:da81
2a01:111:f100:1002::4134:dab5
2a01:111:f100:1002::4134:daee
2a01:111:f100:1002::4134:db2a
2a01:111:f100:1002::4134:db60
2a01:111:f100:1002::4134:db89
2a01:111:f100:1002::4134:dbe7
2a01:111:f100:1002::4134:dc2d
2a01:111:f100:1002::4134:dc2e
2a01:111:f100:1002::4134:dc43
2a01:111:f100:1002::4134:dc6e
2a01:111:f100:1002::4134:dd7a
2a01:111:f100:1002::4134:ddcb
2a01:111:f100:2002::8975:2c3b
2a01:111:f100:2002::8975:2c3f
2a01:111:f100:2002::8975:2c6d
2a01:111:f100:2002::8975:2cdd
2a01:111:f100:2002::8975:2cea
2a01:111:f100:2002::8975:2ced
2a01:111:f100:2002::8975:2d08
2a01:111:f100:2002::8975:2d19
2a01:111:f100:2002::8975:2d25
2a01:111:f100:2002::8975:2d4d
2a01:111:f100:2002::8975:2d6a
2a01:111:f100:2002::8975:2d97
2a01:111:f100:2002::8975:2daa
2a01:111:f100:2002::8975:2dc7
2a01:111:f100:3002::8987:30a0
2a01:111:f100:3002::8987:3103
2a01:111:f100:3002::8987:3278
2a01:111:f100:3002::8987:328f
2a01:111:f100:3002::8987:3299
2a01:111:f100:3002::8987:3344
2a01:111:f100:3002::8987:3396
2a01:111:f100:3002::8987:3398
2a01:111:f100:3002::8987:33b3
2a01:111:f100:3002::8987:33ec
2a01:111:f100:3002::8987:34eb
2a01:111:f100:3002::8987:34f8
2a01:111:f100:3002::8987:353b
2a01:111:f100:3002::8987:35b5
2a01:111:f100:4001::4625:a3ee
2a01:111:f100:4001::4625:a4b6
2a01:111:f100:4001::4625:a4ba
2a01:111:f100:4001::4625:a4c7
2a01:111:f100:4001::4625:a4cf
2a01:111:f100:4001::4625:a4ee
2a01:111:f100:4001::4625:a56f
2a01:111:f100:4001::4625:a589
2a01:111:f100:7000::6fdd:6a44
2a01:111:f100:7000::6fdd:6b96
2a01:111:f100:7000::6fdd:6bb6
2a01:111:f100:7000::6fdd:6c82
2a01:111:f100:7000::6fdd:6d1c
2a01:111:f100:7000::6fdd:6d23
2a01:111:f100:7000::6fdd:6d50
2a01:111:f100:7000::6fdd:6d88
2a01:111:f100:a004::bfeb:8a92
2a01:111:f100:a004::bfeb:8ab0
2a01:111:f100:a004::bfeb:8b12
2a01:111:f100:a004::bfeb:8b15
2a01:111:f100:a004::bfeb:8b3c
2a01:111:f100:a004::bfeb:8b47
2a01:111:f100:a004::bfeb:8b6c
2a01:111:f100:a004::bfeb:8beb
2a01:111:f100:a004::bfeb:8c55
2a01:111:f100:a004::bfeb:8c6d
2a01:111:f100:a004::bfeb:8c6f
2a01:111:f100:a004::bfeb:8c88
2a01:111:f100:a004::bfeb:8cc0
2a01:111:f100:a004::bfeb:8cdc
2a01:111:f100:a004::bfeb:8d83
2a01:111:f100:a004::bfeb:8d96
2a01:111:f100:a004::bfeb:8daa
2a01:111:f102:8001::1761:4929
2a01:111:f102:8001::1761:4948
2a01:111:f102:8001::1761:4b83
2a01:111:f102:8001::1761:4f0d
2a01:111:f102:8001::1761:4f32
2a01:111:f102:8001::1761:4f64
2a01:111:f102:8001::1761:4f8d
2a01:111:f102:8001::1761:4fc0
2a01:111:f400::/48

13.67.50.224/29
13.75.48.16/29
13.75.80.16/29
13.106.56.0/25
23.100.16.168/29
23.100.32.136/29
23.100.64.24/29
23.100.72.32/29
23.100.80.64/29
23.100.88.32/29
23.100.101.112/28
23.100.104.16/28
23.100.112.64/29
23.100.120.64/29
23.101.5.104/29
23.101.144.136/29
23.101.165.168/29
23.101.181.128/29
23.101.210.24/29
23.101.222.240/28
23.101.224.16/29
23.101.226.16/28
40.112.64.16/28
40.113.192.16/29
40.114.120.16/29
40.115.152.16/28
40.127.67.24/29
52.125.0.0/17
52.172.144.16/28
65.52.1.16/29
65.52.193.136/29
65.54.170.128/25
70.37.128.0/23
104.40.240.48/28
104.41.13.120/29
104.41.216.16/28
104.42.72.16/29
104.43.208.16/29
104.43.240.16/29
104.44.218.128/25
104.44.254.128/25
104.44.255.0/25
104.45.0.16/28
104.45.208.104/29
104.46.112.8/29
104.46.224.64/28
104.209.144.16/29
104.210.48.8/29
104.210.83.160/29
104.210.208.16/29
104.211.16.16/29
104.211.48.16/29
104.211.88.16/28
104.211.98.138/32
104.211.98.146/32
104.211.98.246/32
104.211.99.236/32
104.211.100.160/32
104.211.100.204/32
104.211.102.225/32
104.211.152.32/27
104.211.161.150/32
104.211.161.165/32
104.211.161.185/32
104.211.162.33/32
104.211.165.35/32
104.211.166.139/32
104.211.216.32/27
104.211.224.118/32
104.211.225.135/32
104.211.227.110/32
104.211.231.147/32
104.211.231.248/32
104.215.96.24/29
104.215.144.64/29
104.215.184.16/29
131.253.120.128/32
134.170.67.0/25
134.170.172.128/25
157.55.45.128/25
157.55.59.128/25
157.55.130.0/25
157.56.53.128/25
157.56.55.0/25
157.56.58.0/25
157.56.151.0/25
191.232.2.128/25
191.237.248.32/29
191.237.252.192/28

*.api.skype.com
*.broadcast.skype.com
*.cqd.lync.com
*.infra.lync.com
*.keydelivery.mediaservices.windows.net
*.lync.com
*.microsoftonline.com
*.msecnd.net
*.streaming.mediaservices.windows.net
*.users.storage.live.com
a.config.skype.com
ajax.aspnetcdn.com
aka.ms
amp.azure.net
b.config.skype.com
broadcast.skype.com
browser.pipe.aria.microsoft.com
config.edge.skype.com
evsecure-ocsp.verisign.com
evsecure-aia.verisign.com
evsecure-crl.verisign.com
graph.skype.com
mlccdn.blob.core.windows.net
ocsp.msocsp.com
pipe.skype.com
quicktips.skypeforbusiness.com
sa.symcb.com
skypemaprdsitus.trafficmanager.net
swx.cdn.skype.com
*.dc.trouter.io
*.conv.skype.com
*.asm.skype.com
*.blob.core.windows.net
*.cc.skype.com
*.config.skype.com
*.feedback.skype.com
*.giphy.com
*.licensing.mp.microsoft.com
*.msedge.net
*.msg.skype.com
*.pipe.aria.microsoft.com
*.pipe.skype.com
*.trouter.io
a.config.skype.com
amer-client-ss.msg.skype.com
amer-server-ss.msg.skype.com
apac-client-ss.msg.skype.com
apac-server-ss.msg.skype.com
api.teams.skype.com
api.teams.skype.com/amer
api.teams.skype.com/apac
api.teams.skype.com/emea
b.config.skype.com
bots.teams.skype.com
ea-api.asm.skype.com
emails.teams.skype.com
emails.teams.skype.net
emea-client-ss.msg.skype.com
emea-server-ss.msg.skype.com
eu-api.asm.skype.com
img.teams.skype.com
img.teams.skype.com/amer
img.teams.skype.com/apac
img.teams.skype.com/emea
mobile.pipe.aria.microsoft.com
prod.registrar.skype.com
prod.tpc.skype.com
s-0001.s-msedge.net
s-0002.s-msedge.net
s-0004.s-msedge.net
scsquery-ss-asia.trafficmanager.net
scsquery-ss-eu.trafficmanager.net
scsquery-ss-us.trafficmanager.net
settings.teams.skype.com
ssdesktopbuild.blob.core.windows.net
statics.teams.microsoft.com
statics.teams.skype.com
teams.microsoft.com
teams.skype.com
us-api.asm.skype.com
webhook.teams.skype.com

2603:1027::/48
2603:1037::/48
2603:1047::/48
2603:1057::/48
2620:01ec:0042::/48
2620:1ec:40::/42
2620:1ec:6::/48
2a01:111:2047:2::/64
2a01:111:2047:1::/64
2a01:111:2048:2::/64
2a01:111:2048:1::/64
2a01:111:f406:3406::/64
2a01:111:f406:3405::/64
2a01:111:200f:11::/64
2a01:111:200f:10::/64
2a01:111:2007:3::/64
2a01:111:2007:4::/64
2a01:111:200f:6::/64
2a01:111:200f:7::/64
2a01:111:200f:8::/64
2a01:111:200f:9::/64
2a01:111:2012:2::/64
2a01:111:2012:3::/64
2a01:111:2012:4::/64
2a01:111:2012:5::/64
2a01:111:2012:6::/64
2a01:111:2012:7::/64
2a01:111:202a:2::/64
2a01:111:202a:3::/64
2a01:111:202b:3::/64
2a01:111:202b:4::/64
2a01:111:202b:9::/64
2a01:111:202b:a::/64
2a01:111:2034:2::/64
2a01:111:2034:3::/64
2a01:111:2035:6::/64
2a01:111:2035:7::/64
2a01:111:2036:2::/64
2a01:111:2036:3::/64
2a01:111:203e:1::/64
2a01:111:203e:2::/64
2a01:111:2040:1::/64
2a01:111:2040:2::/64
2a01:111:2046:4::/64
2a01:111:2046:5::/64
2a01:111:2a:7::/64
2a01:111:2a:8::/64
2a01:111:f402:5802::/64
2a01:111:f402:5803::/64
2a01:111:f402:5805::/64
2a01:111:f404:0c06::/64
2a01:111:f404:0c07::/64
2a01:111:f404:0c09::/64
2a01:111:f404:0c0a::/64
2a01:111:f404:3400::/64
2a01:111:f404:3401::/64
2a01:111:f404:8002::/64
2a01:111:f404:8003::/64
2a01:111:f404:9400::/64
2a01:111:f404:9401::/64
2a01:111:f404:a000::/64
2a01:111:f404:a001::/64
2a01:111:f404:a800::/64
2a01:111:f404:a801::/64
2a01:111:f404:c0b::/64
2a01:111:f404:c0c::/64
2a01:111:f406:2400::/64
2a01:111:f406:2401::/64
2a01:111:f406:402::/64
2a01:111:f406:403::/64

13.67.56.225/32
13.67.186.105/32
13.67.209.156/32
13.67.214.76/32
13.67.222.144/32
13.67.234.27/32
13.68.31.102/32
13.68.218.89/32
13.70.89.162/32
13.70.185.128/32
13.70.189.101/32
13.70.189.149/32
13.75.42.168/32
13.75.154.195/32
13.75.159.17/32
13.75.159.51/32
13.76.188.52/32
13.76.189.79/32
13.77.5.70/32
13.78.93.8/32
13.78.94.7/32
13.78.95.252/32
13.78.112.190/32
13.88.183.247/32
13.88.241.210/32
13.89.44.84/32
13.91.40.251/32
13.91.108.91/32
13.91.252.242/32
13.92.80.132/32
13.92.136.118/32
13.93.209.18/32
13.93.226.103/32
13.94.47.37/32
13.95.88.228/32
13.95.233.176/32
13.95.236.192/32
13.107.3.0/24
13.107.3.128/32
13.107.3.129/32
13.107.8.0/24
13.107.64.0/18
13.107.66.0/24
23.97.72.141/32
23.97.78.16/32
23.97.164.28/32
23.97.169.134/32
23.99.101.49/32
23.99.115.104/32
23.99.121.255/32
23.99.122.87/32
23.99.124.9/32
23.99.213.58/32
23.101.115.193/32
23.101.116.26/32
23.101.156.198/32
23.101.158.111/32
23.102.17.214/32
23.102.24.114/32
23.103.128.0/23
23.103.130.0/24
23.103.176.128/26
23.103.176.192/27
23.103.178.128/26
23.103.178.192/27
40.68.229.156/32
40.68.230.133/32
40.69.45.108/32
40.74.62.125/32
40.74.113.62/32
40.74.129.215/32
40.74.130.253/32
40.74.143.94/32
40.76.24.32/32
40.76.24.177/32
40.76.77.68/32
40.77.16.36/32
40.78.68.158/32
40.78.71.48/32
40.78.98.202/32
40.78.145.194/32
40.79.38.101/32
40.79.74.185/32
40.83.17.24/32
40.83.176.46/32
40.83.177.162/32
40.84.28.125/32
40.86.90.132/32
40.112.151.117/32
40.112.188.2/32
40.113.16.205/32
40.113.87.220/32
40.113.136.240/32
40.114.149.220/32
40.114.244.22/32
40.115.1.44/32
40.117.100.83/32
40.117.145.132/32
40.118.6.5/32
40.118.214.164/32
40.118.244.106/32
40.118.251.206/32
40.122.165.60/32
40.122.168.86/32
40.123.50.17/32
40.127.97.30/32
40.127.129.109/32
52.112.0.0/14
52.163.224.242/32
52.163.230.187/32
52.163.231.50/32
52.163.231.126/32
52.164.255.104/32
52.165.35.53/32
52.165.45.77/32
52.169.30.95/32
52.169.104.89/32
52.169.105.194/32
52.169.105.219/32
52.169.106.115/32
52.174.144.192/32
52.174.166.73/32
52.174.166.107/32
52.174.166.156/32
52.175.38.240/32
52.178.34.159/32
52.178.36.12/32
52.178.36.169/32
52.178.38.115/32
52.178.145.227/32
52.178.148.1/32
52.178.148.152/32
52.178.158.225/32
52.232.129.71/32
52.232.132.60/32
52.232.135.81/32
52.233.29.169/32
52.233.30.121/32
65.55.127.0/24
66.119.157.192/26
66.119.158.0/25
104.40.75.8/32
104.40.76.196/32
104.41.207.112/32
104.41.210.140/32
104.42.229.230/32
104.43.12.164/32
104.44.195.0/24
104.44.200.0/23
104.44.200.0/24
104.44.201.0/24
104.46.96.162/32
104.46.97.194/32
104.46.101.116/32
104.46.105.95/32
104.208.28.54/32
104.208.31.113/32
104.208.152.137/32
104.210.1.218/32
111.221.76.128/25
111.221.77.0/26
111.221.101.75/32
111.221.122.192/26
131.253.128.0/19
131.253.160.0/20
134.170.0.0/25
134.170.54.128/25
134.170.54.0/26
134.170.113.192/26
134.170.115.128/25
137.116.132.4/32
137.116.157.126/32
137.116.159.19/32
137.116.159.228/32
137.117.109.221/32
157.55.40.128/25
157.55.46.64/26
157.55.232.128/26
157.55.238.0/25
157.56.135.64/26
157.56.185.0/26
168.61.100.177/32
168.61.152.29/32
168.61.155.249/32
168.63.14.15/32
168.63.219.57/32
168.63.245.120/32
191.233.80.151/32
191.233.95.169/32
191.234.19.21/32
191.234.20.241/32
191.234.21.145/32
191.234.23.27/32
207.46.5.0/24
207.46.155.141/32
207.46.156.136/32
207.46.230.50/32

*.outlook.com
*.um.outlook.com
*.hybridconfiguration.azurewebsites.net
*.store.core.windows.net
.outlook.office.com
autodiscover-.outlook.com
mshrcstorageprod.blob.core.windows.net
domains.live.com
delve.office.com
hybridconfiguration.azurewebsites.net
outlook.office365.com
r1.res.office365.com
r3.res.office365.com
r4.res.office365.com
smtp.office365.com
*.protection.outlook.com
*.mail.protection.outlook.com

2603:1006::/40
2603:1016::/40
2603:1020:0800::/40
2603:1026::/40
2603:1026:0200::/39
2603:1026:0400::/39
2603:1026:0600::/40
2603:1026:0800::/40
2603:1036::/39
2603:1036:0200::/40
2603:1036:0400::/40
2603:1036:0600::/40
2603:1036:0800::/38
2603:1036:0c00::/40
2603:1046::/37
2603:1046:0900::/40
2603:1056::/40
2603:1056:0400::/40
2603:1056:0600::/40
2603:1096::/38
2603:1096:0400::/40
2603:1096:0600::/40
2603:1096:0c00::/40
2603:1096:a00::/39
2603:10a6:0200::/40
2603:10a6:0400::/40
2603:10a6:0600::/40
2603:10a6:0800::/40
2603:10d6:0200::/40
2620:1ec:4::152
2620:1ec:4::153
2620:1ec:a92::152
2620:1ec:a92::153
2620:1ec:c::10
2620:1ec:c::11
2620:1ec:d::10
2620:1ec:d::11
2a01:111:f400::/48

13.107.6.152/31
13.107.9.152/31
13.107.18.10/31
13.107.19.10/31
23.103.160.0/20
23.103.224.0/19
40.96.0.0/13
40.104.0.0/15
70.37.151.128/25
111.221.112.0/21
131.253.33.215/32
132.245.0.0/16
134.170.68.0/23
157.56.96.16/28
157.56.96.224/28
157.56.106.128/28
157.56.232.0/21
157.56.240.0/20
191.232.96.0/19
191.234.6.152/32
191.234.140.0/22
191.234.224.0/22
204.79.197.215/32
206.191.224.0/19
207.46.150.128/25
207.46.203.128/26

*.sharepoint.com
*.sharepointonline.com
*.svc.ms
*.search.msit.us.trafficmanager.net
*.search.production.us.trafficmanager.net
*.search.production.emea.trafficmanager.net
*.search.production.apac.trafficmanager.net
accounts.accesscontrol.windows.net
cdn.sharepointonline.com
click.email.microsoftonline.com
login.microsoftonline.com
Mobile.pipe.aria.microsoft.com
nexus.officeapps.live.com
officeclient.microsoft.com
odc.officeapps.live.com
Oneclient.sfx.ms
privatecdn.sharepointonline.com
prod.msocdn.com
provisioningapi.microsoftonline.com
publiccdn.sharepointonline.com
spoprod-a.akamaihd.net
static.sharepointonline.com
ssw.live.com
storage.live.com
storage.live.com
watson.telemetry.microsoft.com
wns.windows.com

2620:1ec:a92::150
2620:1ec:4::150
2620:1ec:6::129
2a01:111:f402::/48
2801:80:1d0:1400::/54

13.107.6.150/31
13.107.9.150/31
40.108.0.0/19
40.108.128.0/17
104.146.0.0/19
104.146.128.0/17
134.170.200.0/21
134.170.208.0/21
191.232.0.0/23
191.234.128.0/21
191.235.0.0/20

ajax.aspnetcdn.com
*.keydelivery.mediaservices.windows.net
*.streaming.mediaservices.windows.net
r3.res.outlook.com
spoprod-a.akamaihd.net

*.assets-yammer.com
ajax.googleapis.com
*.cloudfront.net
*.yammer.com
*.yammerusercontent.com

13.107.6.158/31
13.107.9.158/31
134.170.148.0/22

2620:1ec:a92::158
2620:1ec:4::158
2620:1ec:a92::159
2620:1ec:4::159

13.67.59.89/32
40.85.91.8/32
104.208.36.70/32
104.211.54.99/32
104.211.54.134/32

13.73.106.160/32
13.75.158.234/32
13.78.58.132/32
13.79.161.29/32
13.82.54.72/32
13.93.219.105/32
40.74.129.10/32
40.118.97.54/32
52.172.158.178/32
104.41.35.170/32
104.211.163.139/32

*.onenote.com
*.msecnd.net
*.microsoft.com
*.office.net
apis.live.net
www.onedrive.com
www.onenote.com
Cdn.optimizely.com
Ajax.aspnetcdn.com
s.ytimg.com
www.youtube.com
ad.atdmt.com
Cdn.onenote.net

directory.services.live.com
odc.officeapps.live.com
docs.live.net
roaming.officeapps.live.com
nexus.officeapps.live.com
sqm.microsoft.com
watson.telemetry.microsoft.com
login.live.com
wer.microsoft.com
*-my.sharepoint.com
login.microsoftonline.com
ms.tific.com
p100-sandbox.itunes.apple.com
signup.live.com
auth.gfx.ms
view.atdmt.com
client.hip.live.com
dc2.client.hip.live.com
c.live.com
go.microsoft.com
office.microsoft.com
officeimg.vo.msecnd.net
m.webtrends.com
account.live.com
c.bing.com
partnerservices.getmicrosoftkey.com
client.hip.live.com
clientconfig.microsoftonline-p.net
cl2.apple.com
sas.office.microsoft.com
foodanddrink.services.appex.bing.com
en-US.appex-rf.msn.com
weather.tile.appex.bing.com

office15client.microsoft.com
odc.officeapps.live.com
go.microsoft.com
login.microsoftonline.com
odcsm.officeapps.live.com
*-my.sharepoint.com
ms.tific.com
roaming.officeapps.live.com
o15.officeredir.microsoft.com
office.microsoft.com
officeimg.vo.msecnd.net
m.webtrends.com
d.docs.live.net
login.live.com
auth.gfx.ms
wer.microsoft.com
*.appex.bing.com
*.appex-rf.msn.com
appexsin.stb.s-msn.com
*.acompli.net
outlook.office365.com
sdfpilot.outlook.com
graph.windows.net
api.office.com
secure.aadcdn.microsoftonline-p.com
login.windows.net
login.windows-ppe.net
com.microsoft.office.outlook.dev
go.microsoft.com
mam.manage.microsoft.com
vortex.data.microsoft.com
login.microsoftonline.com
outlook.office.com
login.windows.net
login.live.com
auth.gfx.ms
account.live.com
graph.microsoft.com
apis.live.net
accounts.google.com
mail.google.com
www.googleapis.com
api.login.yahoo.com
social.yahooapis.com
www.dropbox.com
api.dropboxapi.com
app.box.com
m.facebook.com
graph.facebook.com
www.evernote.com
www.wunderlist.com
a.wunderlist.com
bit.ly/outlookprivacy
www.acompli.com/privacy-policy
by.uservoice.com
outlook.uservoice.com
api.diagnostics.office.com
acompli-android-logs.s3.amazonaws.com
s3-us-west-2.amazonaws.com
mobile.pipe.aria.microsoft.com
data.flurry.com
app.adjust.com
rink.hockeyapp.net
sdk.hockeyapp.net
acompli.helpshift.com
play.google.com

activation.sls.microsoft.com
cdn.odc.officeapps.live.com
crl.microsoft.com
cus-odc.officeapps.live.com
cus-roaming.officeapps.live.com
ea-000.ocws.officeapps.live.com
ea-config.officeapps.live.com
ea-roaming.officeapps.live.com
Eus2-000.ocws.officeapps.live.com
eus2-config.officeapps.live.com
eus2-roaming.officeapps.live.com
eus-odc.officeapps.live.com
go.microsoft.com
insertmedia.bing.office.net
ncus-000.ocws.officeapps.live.com
ncus-odc.officeapps.live.com
ncus-roaming.officeapps.live.com
neu-000.ocws.officeapps.live.com
neu-config.officeapps.live.com
neu-odc.officeapps.live.com
neu-roaming.officeapps.live.com
Nexus.officeapps.live.com
ocsa.officeapps.live.com
ocsredir.officeapps.live.com
ocws.officeapps.live.com
odc.officeapps.live.com
office15client.microsoft.com
officecdn.microsoft.com
officecdn.microsoft.com.edgekey.net
officecdn.microsoft.com.edgesuite.net
officeclient.microsoft.com
officepreviewredir.microsoft.com
officeredir.microsoft.com
ols.officeapps.live.com
r.office.microsoft.com
scus-000.ocws.officeapps.live.com
scus-config.officeapps.live.com
scus-odc.officeapps.live.com
scus-roaming.officeapps.live.com
sea-config.officeapps.live.com
sea-odc.officeapps.live.com
sea-roaming.officeapps.live.com
weu-000.ocws.officeapps.live.com
weu-config.officeapps.live.com
weu-odc.officeapps.live.com
weu-roaming.officeapps.live.com
wus-000.ocws.officeapps.live.com
wus-config.officeapps.live.com
wus-odc.officeapps.live.com
wus-roaming.officeapps.live.com

13.67.53.38/32
13.67.56.73/32
13.69.159.30/32
13.75.42.223/32
13.75.47.33/32
13.75.47.241/32
13.107.12.51/32
23.96.208.185/32
23.96.219.115/32
23.96.219.115/32
23.97.178.173/32
23.97.218.250/32
23.99.56.164/32
23.99.56.164/32
23.99.112.148/32
40.74.50.25/32
40.76.62.115/32
40.76.62.115/32
40.78.68.109/32
40.83.178.25/32
40.83.182.229/32
40.84.147.173/32
40.84.149.239/32
40.84.188.180/32
40.84.192.103/32
40.84.192.103/32
40.86.88.12/32
40.86.88.12/32
40.113.17.180/32
40.113.17.180/32
40.113.19.21/32
40.113.22.47/32
40.122.129.128/32
40.124.14.212/32
65.52.210.135/32
104.40.28.30/32
104.40.208.40/32
104.40.208.40/32
104.40.218.31/32
104.40.234.17/32
104.209.179.144/32
104.209.212.110/32
104.210.220.25/32
137.116.74.190/32
137.116.77.120/32
168.63.234.40/32
168.63.234.40/32
191.236.108.93/32
191.236.157.212/32
207.46.237.84/32

2a01:111:2003::51
2620:1ec:5::51

23.103.132.0/22
23.103.136.0/21
23.103.156.0/22
23.103.198.0/24
23.103.200.0/22
23.103.212.0/22
40.92.0.0/14
40.107.0.0/16
65.55.88.0/24
65.55.169.0/24
94.245.120.64/26
104.47.0.0/17
134.170.132.0/24
134.170.140.0/24
157.55.133.0/25
157.55.234.0/24
157.56.110.0/23
157.56.112.0/24
207.46.51.64/26
207.46.100.0/24
207.46.163.0/24
213.199.154.0/24
213.199.180.128/26
216.32.180.0/23

2a01:111:f400:7c00::/54
2a01:111:f403::/48

2

Wow, that’s a big post. If you could post a link to the xml file (upload it somewhere) and the code between pre tags that would be very nice and we might be able to help you.

3

Oops, here is the link https://support.content.office.net/en-us/static/O365IPAddresses.xml

4

If you want URLs only, try this.

$file = [xml](Get-Content O365IPAddresses.xml)
$file.products.product.addresslist | 
Where-Object {$_.type -eq 'URL'} | Select-Object -ExpandProperty address
5

Thanks everyone! I’ll work on my posting for next time.