vw_managed_ccfs

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

Overview

Name	vw_managed_ccfs
Type	View
Id	azure.confidential_ledger.vw_managed_ccfs

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
tags as tags,
JSON_EXTRACT(properties, '$.appName') as "app_name",
JSON_EXTRACT(properties, '$.appUri') as "app_uri",
JSON_EXTRACT(properties, '$.identityServiceUri') as "identity_service_uri",
JSON_EXTRACT(properties, '$.memberIdentityCertificates') as "member_identity_certificates",
JSON_EXTRACT(properties, '$.deploymentType') as "deployment_type",
JSON_EXTRACT(properties, '$.runningState') as "running_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.nodeCount') as "node_count",
subscriptionId,
resourceGroupName,
appName
FROM azure.confidential_ledger.managed_ccfs
WHERE subscriptionId = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
json_extract_path_text(properties, '$.appName') as "app_name",
json_extract_path_text(properties, '$.appUri') as "app_uri",
json_extract_path_text(properties, '$.identityServiceUri') as "identity_service_uri",
json_extract_path_text(properties, '$.memberIdentityCertificates') as "member_identity_certificates",
json_extract_path_text(properties, '$.deploymentType') as "deployment_type",
json_extract_path_text(properties, '$.runningState') as "running_state",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.nodeCount') as "node_count",
subscriptionId,
resourceGroupName,
appName
FROM azure.confidential_ledger.managed_ccfs
WHERE subscriptionId = 'replace-me';