K B
asked on
Extract all email addresses with PowerShell from Exchange
I cannot seem to figure out why the portion of the code that reads...
So, I do not want the primary SMTP address to appear in the output at all.
Any ideas experts?
K.B.
? {$_.PrefixString -ceq "smtp" -or "sip"}
...from the below script is not filtering out primary SMTP addresses.So, I do not want the primary SMTP address to appear in the output at all.
Get-Mailbox -ResultSize Unlimited|
% {
$usr = Get-User $_.SamAccountName
$_ | Select-Object DisplayName, UserPrincipalName, ForwardingAddress, Alias, LegacyExchangeDN, RecipientType,RecipientTypeDetails,
@{Name="FirstName" ;Expression={$usr.FirstName}},
@{Name="LastName" ;Expression={$usr.LastName }},
@{Name="StreetAddress" ;Expression={($usr.StreetAddress) -replace '(.*?)[\r|\n](.*?)' , '$1 $2' }},
@{Name="City" ;Expression={$usr.City}},
@{Name="StateOrProvince";Expression={$usr.StateOrProvince}},
@{Name="PostalCode" ;Expression={$usr.PostalCode}},
@{Name="CountryOrRegion";Expression={$usr.CountryOrRegion}},
@{Name="Phone" ;Expression={$usr.Phone}},
@{Name="HomePhone" ;Expression={$usr.HomePhone}},
@{Name="MobilePhone" ;Expression={$usr.MobilePhone}},
@{Name="Fax" ;Expression={$usr.Fax}},
@{Name="Pager" ;Expression={$usr.Pager}},
@{Name="Department" ;Expression={$usr.Department}},
@{Name="Office" ;Expression={$usr.Office}},
@{Name="Title" ;Expression={$usr.Title}},
@{Name="WebPage" ;Expression={$usr.WebPage}},
@{Name="Notes" ;Expression={$usr.Notes}},
@{Name="EmailAddresses" ;Expression={($_.EmailAddresses | ? {$_.PrefixString -ceq "smtp" -or "sip"} | % {$_.SmtpAddress}) -join ";"}}
} |
ConvertTo-CSV -notype |
% { $_ -replace '"'} |
Out-File C:\scripts\Mailboxes.csv
Any ideas experts?
K.B.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER