Export Azure File Sync drive mappings from Azure to a CSV file

AFS-Export.ps1

$RSG_Name = Read-Host "Enter the name of the Resource Group in which the Sync Service resides:"
$SyncService_Name = Read-Host "Enter the name of the Sync Service:"
$ExportPath = Read-Host "Enter the path and filename (ending with .csv) to export to:"

$StorageSyncGroups = Get-AzStorageSyncGroup -ResourceGroupName $RSG_Name -StorageSyncServiceName $SyncService_Name

$Objects = foreach ($_SSG in $StorageSyncGroups) {
    $_SSE = Get-AzStorageSyncServerEndpoint -ResourceGroupName $RSG_Name -StorageSyncServiceName $SyncService_Name -SyncGroupName $_SSG.SyncGroupName

    New-Object -TypeName PSObject -Property @{
        SyncGroupName = $_SSG.SyncGroupName
        SyncServerName = $_SSE.FriendlyName
        SyncServerLocalPath = $_SSE.ServerLocalPath
        CloudTiering = $_SSE.CloudTiering
    } | Select-Object SyncGroupName,SyncServerName,SyncServerLocalPath,CloudTiering
}

$Objects | Export-Csv -NoTypeInformation -NoClobber "${ExportPath}"