List Application Insights configurations for Web Apps and Function Apps

list-appinsights.ps1

$webApps = ConvertFrom-Json([string](& az webapp list --query "[*].{name: name, resourceGroup: resourceGroup}" -o json))
$webApps | ForEach-Object {
    Write-Host $_.Name
    $settings = ConvertFrom-Json([string](& az webapp config appsettings list -n $_.name -g $_.resourceGroup --query "{APPINSIGHTS_INSTRUMENTATIONKEY: [?name=='APPINSIGHTS_INSTRUMENTATIONKEY'].value | [0], APPLICATIONINSIGHTS_CONNECTION_STRING: [?name=='APPLICATIONINSIGHTS_CONNECTION_STRING'].value | [0]}"))
    $_ | Add-Member -NotePropertyName APPINSIGHTS_INSTRUMENTATIONKEY -NotePropertyValue $settings.APPINSIGHTS_INSTRUMENTATIONKEY
    $_ | Add-Member -NotePropertyName APPLICATIONINSIGHTS_CONNECTION_STRING -NotePropertyValue $settings.APPLICATIONINSIGHTS_CONNECTION_STRING
}

$funcApps = ConvertFrom-Json([string](& az functionapp list --query "[*].{name: name, resourceGroup: resourceGroup}" -o json))
$funcApps | ForEach-Object {
    Write-Host $_.Name
    $settings = ConvertFrom-Json([string](& az functionapp config appsettings list -n $_.name -g $_.resourceGroup --query "{APPINSIGHTS_INSTRUMENTATIONKEY: [?name=='APPINSIGHTS_INSTRUMENTATIONKEY'].value | [0], APPLICATIONINSIGHTS_CONNECTION_STRING: [?name=='APPLICATIONINSIGHTS_CONNECTION_STRING'].value | [0]}"))
    $_ | Add-Member -NotePropertyName APPINSIGHTS_INSTRUMENTATIONKEY -NotePropertyValue $settings.APPINSIGHTS_INSTRUMENTATIONKEY
    $_ | Add-Member -NotePropertyName APPLICATIONINSIGHTS_CONNECTION_STRING -NotePropertyValue $settings.APPLICATIONINSIGHTS_CONNECTION_STRING
}

$webApps + $funcApps | ConvertTo-Csv -NoTypeInformation