Skip to main content

vw_live_events

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

Overview​

Namevw_live_events
TypeView
Idazure.media_services.vw_live_events

Fields​

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

SQL Definition​

SELECT
location as location,
systemData as system_data,
tags as tags,
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.input') as "input",
JSON_EXTRACT(properties, '$.preview') as "preview",
JSON_EXTRACT(properties, '$.encoding') as "encoding",
JSON_EXTRACT(properties, '$.transcriptions') as "transcriptions",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.resourceState') as "resource_state",
JSON_EXTRACT(properties, '$.crossSiteAccessPolicies') as "cross_site_access_policies",
JSON_EXTRACT(properties, '$.useStaticHostname') as "use_static_hostname",
JSON_EXTRACT(properties, '$.hostnamePrefix') as "hostname_prefix",
JSON_EXTRACT(properties, '$.streamOptions') as "stream_options",
JSON_EXTRACT(properties, '$.created') as "created",
JSON_EXTRACT(properties, '$.lastModified') as "last_modified",
subscriptionId,
resourceGroupName,
accountName,
liveEventName
FROM azure.media_services.live_events
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND accountName = 'replace-me';