Skip to main content

vw_packages

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

Overview​

Namevw_packages
TypeView
Idazure_extras.test_base.vw_packages

Fields​

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

SQL Definition​

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.applicationName') as "application_name",
JSON_EXTRACT(properties, '$.version') as "version",
JSON_EXTRACT(properties, '$.draftPackageId') as "draft_package_id",
JSON_EXTRACT(properties, '$.packageStatus') as "package_status",
JSON_EXTRACT(properties, '$.isEnabled') as "is_enabled",
JSON_EXTRACT(properties, '$.blobPath') as "blob_path",
JSON_EXTRACT(properties, '$.validationResults') as "validation_results",
JSON_EXTRACT(properties, '$.testTypes') as "test_types",
JSON_EXTRACT(properties, '$.targetOSList') as "target_os_list",
JSON_EXTRACT(properties, '$.inplaceUpgradeOSPair') as "inplace_upgrade_os_pair",
JSON_EXTRACT(properties, '$.lastModifiedTime') as "last_modified_time",
JSON_EXTRACT(properties, '$.flightingRing') as "flighting_ring",
JSON_EXTRACT(properties, '$.firstPartyApps') as "first_party_apps",
JSON_EXTRACT(properties, '$.galleryApps') as "gallery_apps",
JSON_EXTRACT(properties, '$.tests') as "tests",
JSON_EXTRACT(properties, '$.intuneEnrollmentMetadata') as "intune_enrollment_metadata",
subscriptionId,
resourceGroupName,
testBaseAccountName,
packageName
FROM azure_extras.test_base.packages
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND testBaseAccountName = 'replace-me';