Skip to main content

vw_test_summaries

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

Overview​

Namevw_test_summaries
TypeView
Idazure_extras.test_base.vw_test_summaries

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.testSummaryId') as "test_summary_id",
JSON_EXTRACT(properties, '$.packageId') as "package_id",
JSON_EXTRACT(properties, '$.applicationName') as "application_name",
JSON_EXTRACT(properties, '$.applicationVersion') as "application_version",
JSON_EXTRACT(properties, '$.executionStatus') as "execution_status",
JSON_EXTRACT(properties, '$.testStatus') as "test_status",
JSON_EXTRACT(properties, '$.grade') as "grade",
JSON_EXTRACT(properties, '$.testRunTime') as "test_run_time",
JSON_EXTRACT(properties, '$.featureUpdatesTestSummary') as "feature_updates_test_summary",
JSON_EXTRACT(properties, '$.securityUpdatesTestSummary') as "security_updates_test_summary",
JSON_EXTRACT(properties, '$.inplaceUpgradesTestSummary') as "inplace_upgrades_test_summary",
JSON_EXTRACT(properties, '$.packageTags') as "package_tags",
subscriptionId,
resourceGroupName,
testBaseAccountName,
testSummaryName
FROM azure_extras.test_base.test_summaries
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND testBaseAccountName = 'replace-me';