vw_marketplace_registration_definitions_without_scopes

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

Overview

Name	vw_marketplace_registration_definitions_without_scopes
Type	View
Id	azure.managed_services.vw_marketplace_registration_definitions_without_scopes

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
plan as plan,
type as type,
JSON_EXTRACT(properties, '$.managedByTenantId') as "managed_by_tenant_id",
JSON_EXTRACT(properties, '$.authorizations') as "authorizations",
JSON_EXTRACT(properties, '$.eligibleAuthorizations') as "eligible_authorizations",
JSON_EXTRACT(properties, '$.offerDisplayName') as "offer_display_name",
JSON_EXTRACT(properties, '$.publisherDisplayName') as "publisher_display_name",
JSON_EXTRACT(properties, '$.planDisplayName') as "plan_display_name",
marketplaceIdentifier
FROM azure.managed_services.marketplace_registration_definitions_without_scopes
WHERE marketplaceIdentifier = 'replace-me';

Postgres

SELECT
id as id,
name as name,
plan as plan,
type as type,
json_extract_path_text(properties, '$.managedByTenantId') as "managed_by_tenant_id",
json_extract_path_text(properties, '$.authorizations') as "authorizations",
json_extract_path_text(properties, '$.eligibleAuthorizations') as "eligible_authorizations",
json_extract_path_text(properties, '$.offerDisplayName') as "offer_display_name",
json_extract_path_text(properties, '$.publisherDisplayName') as "publisher_display_name",
json_extract_path_text(properties, '$.planDisplayName') as "plan_display_name",
marketplaceIdentifier
FROM azure.managed_services.marketplace_registration_definitions_without_scopes
WHERE marketplaceIdentifier = 'replace-me';