I was struggling in finding a way to export all SendConnector details including multivalue fields to a CSV file during an Exchange 2010 – 2016 Hybrid soloution plan.<\/p>\n
So I wrote the following script to do so.<\/p>\n
<\/p>\n
[powershell]<\/p>\n
Push-Location (Split-Path -path $MyInvocation.MyCommand.Definition -Parent)<\/p>\n
$outfile = "$($env:computername)_SendConnectors.csv"
\n$out = @()
\n$connectors = Get-SendConnector<\/p>\n
ForEach ($SendConnector in $connectors){
\n$SendConnect=@{}
\n$SendConnect.add("AddressSpaces", $SendConnector.AddressSpaces -join (", "))
\n$SendConnect.add("AuthenticationCredential", $SendConnector.AuthenticationCredential)
\n$SendConnect.add("Comment", $SendConnector.Comment)
\n$SendConnect.add("ConnectedDomains", $SendConnector.ConnectedDomains -join (", "))
\n$SendConnect.add("ConnectionInactivityTimeOut", $SendConnector.ConnectionInactivityTimeOut)
\n$SendConnect.add("DNSRoutingEnabled", $SendConnector.DNSRoutingEnabled)
\n$SendConnect.add("DomainSecureEnabled", $SendConnector.DomainSecureEnabled)
\n$SendConnect.add("Enabled", $SendConnector.Enabled)
\n$SendConnect.add("ErrorPolicies", $SendConnector.ErrorPolicies)
\n$SendConnect.add("ForceHELO", $SendConnector.ForceHELO)
\n$SendConnect.add("Fqdn", $SendConnector.Fqdn)
\n$SendConnect.add("HomeMTA", $SendConnector.HomeMTA)
\n$SendConnect.add("HomeMtaServerId", $SendConnector.HomeMtaServerId)
\n$SendConnect.add("Identity", $SendConnector.Identity)
\n$SendConnect.add("IgnoreSTARTTLS", $SendConnector.IgnoreSTARTTLS)
\n$SendConnect.add("IsScopedConnector", $SendConnector.IsScopedConnector)
\n$SendConnect.add("IsSmtpConnector", $SendConnector.IsSmtpConnector)
\n$SendConnect.add("LinkedReceiveConnector", $SendConnector.LinkedReceiveConnector)
\n$SendConnect.add("MaxMessageSize", $SendConnector.MaxMessageSize)
\n$SendConnect.add("Name", $SendConnector.Name)
\n$SendConnect.add("Port", $SendConnector.Port)
\n$SendConnect.add("ProtocolLoggingLevel", $SendConnector.ProtocolLoggingLevel)
\n$SendConnect.add("RequireOorg", $SendConnector.RequireOorg)
\n$SendConnect.add("RequireTLS", $SendConnector.RequireTLS)
\n$SendConnect.add("SmartHostAuthMechanism", $SendConnector.SmartHostAuthMechanism)
\n$SendConnect.add("SmartHosts", $SendConnector.SmartHosts -join (", "))
\n$SendConnect.add("SmartHostsString", $SendConnector.SmartHostsString)
\n$SendConnect.add("SmtpMaxMessagesPerConnection", $SendConnector.SmtpMaxMessagesPerConnection)
\n$SendConnect.add("SourceIPAddress", $SendConnector.SourceIPAddress)
\n$SendConnect.add("SourceRoutingGroup", $SendConnector.SourceRoutingGroup)
\n$SendConnect.add("SourceTransportServers", $SendConnector.SourceTransportServers -join (", "))
\n$SendConnect.add("TlsAuthLevel", $SendConnector.TlsAuthLevel)
\n$SendConnect.add("TlsDomain", $SendConnector.TlsDomain)
\n$SendConnect.add("UseExternalDNSServersEnabled ", $SendConnector.UseExternalDNSServersEnabled )<\/p>\n
$out += New-Object PSObject -Property $SendConnect | Select-Object `
\nAddressSpaces,AuthenticationCredential,Comment,ConnectedDomains,ConnectionInactivityTimeOut,`
\nDNSRoutingEnabled,DomainSecureEnabled,Enabled,ErrorPolicies,ForceHELO,Fqdn,HomeMTA,HomeMtaServerId,`
\nIdentity,IgnoreSTARTTLS,IsScopedConnector,IsSmtpConnector,LinkedReceiveConnector,MaxMessageSize,Name,`
\nPort,ProtocolLoggingLevel,RequireOorg,RequireTLS,SmartHostAuthMechanism,SmartHosts,SmartHostsString,`
\nSmtpMaxMessagesPerConnection,SourceIPAddress,SourceRoutingGroup,SourceTransportServers,TlsAuthLevel,`
\nTlsDomain,UseExternalDNSServersEnabled
\n}
\n$out | Export-CSV $outfile -NoTypeInformation<\/p>\n
[\/powershell]<\/p>\n","protected":false},"excerpt":{"rendered":"
I was struggling in finding a way to export all SendConnector details including multivalue fields…<\/p>\n","protected":false},"author":1,"featured_media":988,"comment_status":"open","ping_status":"open","sticky":false,"template":"template-page-builder-no-sidebar.php","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4,19,11],"tags":[],"class_list":["post-1113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-exchange","category-powershell","category-scripts"],"jetpack_featured_media_url":"https:\/\/ihni.uk\/wp-content\/uploads\/2020\/02\/Powershell.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/1113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1113"}],"version-history":[{"count":0,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/1113\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/media\/988"}],"wp:attachment":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}