Problem:
I needed to identify all devices that were making use of an existing Exchange 2010 receive connector. I wanted to list all of the IP addresses in a searchable document that could be sorted.
Solution:
Running the below command exported all devices by IP address and could be sorted by the receive connector they used:
Get-MessageTrackingLog -Start "06/20/2018 09:00:00" -End "06/20/2018 11:00:00" -ResultSize unlimited | Select-Object eventid,sender,timestamp,connectorid,@{Name="ClientIp";Expression={$_.ClientIp}},@{Name="Recipients";Expression={$_.recipients}},@{Name="RecipientStatus";Expression={$_.recipientstatus}},messagesubject | Export-csv c:\temp\ConnectorStats.csv
