Archive
Archive for February, 2021
[EXO] Various ways to grab all SMTP address from mailbox
February 19, 2021
No comments
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
$Mailbox = @{ ResultSize = “Unlimited” } $Filter = @{ FilterScript = {$_.PrefixString -ceq “smtp”} } $Select = @{ Property = @{Name=”First Name”;Expression={$_.DisplayName.Split(“,”)[1].Trim()}}, @{Name=”Last Name”;Expression={$_.DisplayName.Split(“,”)[0].Trim()}}, “DisplayName”, “ServerName”, “PrimarySmtpAddress”, @{Name=”EmailAddresses”;Expression={$_.EmailAddresses | Where-Object @Filter}} } Get-Mailbox @Mailbox | Select-Object @Select #Split all SMTP using comma (Get-Mailbox -ResultSize Unlimited |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses |Where-Object {$_.PrefixString -ceq “smtp”} | ForEach-Object {$_.SmtpAddress}}}) |Select-Object DisplayName,ServerName,PrimarySmtpAddress, @{Name=“EmailAddresses”;Expression={$_.EmailAddresses.Split() -join(“,”)}} |Export-Csv C:\scripts\temp\addresses2.csv -NoTypeInformation Get-Mailbox -ResultSize Unlimited |Select Name, PrimarySMTPAddress, @{Name=’EmailAddresses’;Expression={[string]::join(“;”, ($_.EmailAddresses -cmatch ‘smtp’))}} Get-Mailbox -ResultSize Unlimited | Select-Object DisplayName,PrimarySmtpAddress, @{Name="EmailAddresses";Expression={$_.EmailAddresses | Where-Object {$_.PrefixString -ceq "smtp"} | ForEach-Object {$_.SmtpAddress}}} | Sort-Object DisplayName | Export-CSV "\\sf3\user1\shared\share\e\all_SMTP_Addresses.csv" -NoTypeInformation |
Categories: Exchange, Powershell
[EXO] Concert IMCEAEX string to X500
February 16, 2021
No comments
Simple script to convert IMCEAEX to X500 Address.
1 2 3 4 5 6 7 8 9 10 11 |
$IMCEAEX = Read-Host -Prompt "Enter IMCEAEX string to convert to X500" $IMCEAEX = $IMCEAEX -replace '_', '/' $IMCEAEX = $IMCEAEX -replace '\+20', ' ' $IMCEAEX = $IMCEAEX -replace '\+28', '(' $IMCEAEX = $IMCEAEX -replace '\+29', ')' $IMCEAEX = $IMCEAEX -replace '\+2E', '.' $IMCEAEX = $IMCEAEX -replace 'IMCEAEX-', '' $IMCEAEXNew = $IMCEAEX -split ('@') $IMCEAEX = $IMCEAEXNew[0] $IMCEAEX = 'X500:' + $IMCEAEX write-host $IMCEAEX |