Author Posts

January 5, 2017 at 1:48 am

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

sway.com
http://www.sway.com
eus-www.sway.com
eus-000.www.sway.com
eus-001.www.sway.com
eus-002.www.sway.com
eus-003.www.sway.com
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-www.sway.com
wus-000.www.sway.com
wus-001.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-cdn.com
wus-www.sway-cdn.com
eus-www.sway-extensions.com
wus-www.sway-extensions.com
c.microsoft.com
c1.microsoft.com
prod.msocdn.com
http://www.google-analytics.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
http://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
http://www.office.com
http://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
http://www.onedrive.com
http://www.onenote.com
Cdn.optimizely.com
Ajax.aspnetcdn.com
s.ytimg.com
http://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
http://www.googleapis.com
api.login.yahoo.com
social.yahooapis.com
http://www.dropbox.com
api.dropboxapi.com
app.box.com
m.facebook.com
graph.facebook.com
http://www.evernote.com
http://www.wunderlist.com
a.wunderlist.com
bit.ly/outlookprivacy
http://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

January 5, 2017 at 6:55 am

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.

January 5, 2017 at 2:24 pm

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

January 11, 2017 at 2:22 pm

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