I'm not sure why I always get the result System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
, instead of the correct string without the curly brackets:
This is the script that I'm using wrapped in the Powershell remoting best practice I've learned so far.ProvisioningErrors : {ProxyAddresses}
ProvisioningErrors : {UserPrincipalName}
Code: Select all
If (-not (Get-Module MSOnline) ) {
Write-Host "No Microsoft Online PowerShell module installed" -WarningAction
Try { Install-Module MSOnline -ErrorAction Stop; Import-Module MSOnline -ErrorAction Stop }
Catch { Write-Warning "Unable to load Microsoft Office 365 module because $($Error[0])"; Exit }
}
Try {
$UserCredential = Get-Credential
Connect-MsolService -Credential $UserCredential
Get-MsolDirSyncProvisioningError -ErrorCategory PropertyConflict |
Select DisplayName,
UserPrincipalName,
ObjectType,
LastDirSyncTime,
{$_.ProvisioningErrors},
@{n='ProxyAddresses'; e={$_.ProxyAddresses -join ', '}},
ImmutableId,
ObjectId |
Export-Csv -NoTypeInformation C:\RESULT\DirSync.csv
}
Catch { Write-Warning "Unable to execute PowerShell remoting session because $($Error[0])"; Exit }
How to fix the ProvisioningErrors column so that it only exports the proper text without the curly brackets?ProvisioningErrors
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
System.Collections.Generic.List`1[Microsoft.Online.Administration.DirSyncProvisioningError]
Thank you in advance.