Skip to main content

vw_bots

Creates, updates, deletes, gets or lists a vw_bots resource.

Overview​

Namevw_bots
TypeView
Idazure.bot_service.vw_bots

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
id as id,
name as name,
location as location,
type as type,
tags as tags,
sku as sku,
kind as kind,
etag as etag,
zones as zones,
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.iconUrl') as "icon_url",
JSON_EXTRACT(properties, '$.endpoint') as "endpoint",
JSON_EXTRACT(properties, '$.endpointVersion') as "endpoint_version",
JSON_EXTRACT(properties, '$.allSettings') as "all_settings",
JSON_EXTRACT(properties, '$.parameters') as "parameters",
JSON_EXTRACT(properties, '$.manifestUrl') as "manifest_url",
JSON_EXTRACT(properties, '$.msaAppType') as "msa_app_type",
JSON_EXTRACT(properties, '$.msaAppId') as "msa_app_id",
JSON_EXTRACT(properties, '$.msaAppTenantId') as "msa_app_tenant_id",
JSON_EXTRACT(properties, '$.msaAppMSIResourceId') as "msa_app_msi_resource_id",
JSON_EXTRACT(properties, '$.configuredChannels') as "configured_channels",
JSON_EXTRACT(properties, '$.enabledChannels') as "enabled_channels",
JSON_EXTRACT(properties, '$.developerAppInsightKey') as "developer_app_insight_key",
JSON_EXTRACT(properties, '$.developerAppInsightsApiKey') as "developer_app_insights_api_key",
JSON_EXTRACT(properties, '$.developerAppInsightsApplicationId') as "developer_app_insights_application_id",
JSON_EXTRACT(properties, '$.luisAppIds') as "luis_app_ids",
JSON_EXTRACT(properties, '$.luisKey') as "luis_key",
JSON_EXTRACT(properties, '$.isCmekEnabled') as "is_cmek_enabled",
JSON_EXTRACT(properties, '$.cmekKeyVaultUrl') as "cmek_key_vault_url",
JSON_EXTRACT(properties, '$.cmekEncryptionStatus') as "cmek_encryption_status",
JSON_EXTRACT(properties, '$.tenantId') as "tenant_id",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.isStreamingSupported') as "is_streaming_supported",
JSON_EXTRACT(properties, '$.isDeveloperAppInsightsApiKeySet') as "is_developer_app_insights_api_key_set",
JSON_EXTRACT(properties, '$.migrationToken') as "migration_token",
JSON_EXTRACT(properties, '$.disableLocalAuth') as "disable_local_auth",
JSON_EXTRACT(properties, '$.schemaTransformationVersion') as "schema_transformation_version",
JSON_EXTRACT(properties, '$.storageResourceId') as "storage_resource_id",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.networkSecurityPerimeterConfigurations') as "network_security_perimeter_configurations",
JSON_EXTRACT(properties, '$.openWithHint') as "open_with_hint",
JSON_EXTRACT(properties, '$.appPasswordHint') as "app_password_hint",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.publishingCredentials') as "publishing_credentials",
subscriptionId,
resourceGroupName,
resourceName
FROM azure.bot_service.bots
WHERE subscriptionId = 'replace-me';