vw_instances_details

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

Overview

Name	vw_instances_details
Type	View
Id	azure_extras.dyn365_fraud_protection.vw_instances_details

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
location as location,
tags as tags,
systemData as system_data,
type as type,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.administration') as "administration",
subscriptionId,
resourceGroupName,
instanceName
FROM azure_extras.dyn365_fraud_protection.instances_details
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND instanceName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
location as location,
tags as tags,
systemData as system_data,
type as type,
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.administration') as "administration",
subscriptionId,
resourceGroupName,
instanceName
FROM azure_extras.dyn365_fraud_protection.instances_details
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND instanceName = 'replace-me';