vw_access_control_records

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

Overview

Name	vw_access_control_records
Type	View
Id	azure_extras.storsimple_8000_series.vw_access_control_records

Fields

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

SQL Definition

Sqlite3

SELECT
id as id,
name as name,
type as type,
kind as kind,
JSON_EXTRACT(properties, '$.initiatorName') as "initiator_name",
JSON_EXTRACT(properties, '$.volumeCount') as "volume_count",
subscriptionId,
resourceGroupName,
managerName,
accessControlRecordName
FROM azure_extras.storsimple_8000_series.access_control_records
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managerName = 'replace-me';

Postgres

SELECT
id as id,
name as name,
type as type,
kind as kind,
json_extract_path_text(properties, '$.initiatorName') as "initiator_name",
json_extract_path_text(properties, '$.volumeCount') as "volume_count",
subscriptionId,
resourceGroupName,
managerName,
accessControlRecordName
FROM azure_extras.storsimple_8000_series.access_control_records
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND managerName = 'replace-me';