Skip to main content

vw_application_definitions

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

Overview​

Namevw_application_definitions
TypeView
Idazure.managed_applications.vw_application_definitions

Fields​

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

SQL Definition​

SELECT
managedBy as managed_by,
sku as sku,
JSON_EXTRACT(properties, '$.lockLevel') as "lock_level",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.isEnabled') as "is_enabled",
JSON_EXTRACT(properties, '$.authorizations') as "authorizations",
JSON_EXTRACT(properties, '$.artifacts') as "artifacts",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.packageFileUri') as "package_file_uri",
JSON_EXTRACT(properties, '$.storageAccountId') as "storage_account_id",
JSON_EXTRACT(properties, '$.mainTemplate') as "main_template",
JSON_EXTRACT(properties, '$.createUiDefinition') as "create_ui_definition",
JSON_EXTRACT(properties, '$.notificationPolicy') as "notification_policy",
JSON_EXTRACT(properties, '$.lockingPolicy') as "locking_policy",
JSON_EXTRACT(properties, '$.deploymentPolicy') as "deployment_policy",
JSON_EXTRACT(properties, '$.managementPolicy') as "management_policy",
JSON_EXTRACT(properties, '$.policies') as "policies",
subscriptionId,
resourceGroupName,
applicationDefinitionName
FROM azure.managed_applications.application_definitions
WHERE subscriptionId = 'replace-me';