Public/Discovery/Export-EmailsOnePerLine.ps1
|
function Export-EmailsOnePerLine { [CmdletBinding()] param ( [Parameter()] [string]$ReportPath, [Parameter(Mandatory = $true)] [ValidateSet("ProxyAddresses", "EmailAddresses", "EmailAddress", "AddressOrMember", "x500", "UserPrincipalName", "PrimarySmtpAddress", "MembersName", "Member", "Members", "MemberOf", "Aliases", "Owners", "Managers")] [String]$FindInColumn, [Parameter(ValueFromPipeline = $true, Mandatory = $true)] $RowItem ) process { foreach ($Row in $RowItem) { foreach ($expand in ($Row."$FindInColumn").split('|')) { [PSCustomObject]@{ DisplayName = $Row.DisplayName RecipientTypeDetails = $Row.RecipientTypeDetails Protocol = $Expand.split(':')[0] Domain = $Expand.split('@')[1] EmailAddress = $expand EmailNoProtocl = $Expand.split(':')[1] Identity = $Row.Identity PrimarySmtpAddress = $Row.PrimarySmtpAddress } } } } } |