vw_backup_policies

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

Overview

Name	vw_backup_policies
Type	View
Id	azure_isv.netapp.vw_backup_policies

Fields

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

SQL Definition

Sqlite3

SELECT
location as location,
tags as tags,
etag as etag,
JSON_EXTRACT(properties, '$.backupPolicyId') as "backup_policy_id",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.dailyBackupsToKeep') as "daily_backups_to_keep",
JSON_EXTRACT(properties, '$.weeklyBackupsToKeep') as "weekly_backups_to_keep",
JSON_EXTRACT(properties, '$.monthlyBackupsToKeep') as "monthly_backups_to_keep",
JSON_EXTRACT(properties, '$.volumesAssigned') as "volumes_assigned",
JSON_EXTRACT(properties, '$.enabled') as "enabled",
JSON_EXTRACT(properties, '$.volumeBackups') as "volume_backups",
subscriptionId,
resourceGroupName,
accountName,
backupPolicyName
FROM azure_isv.netapp.backup_policies
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND accountName = 'replace-me';

Postgres

SELECT
location as location,
tags as tags,
etag as etag,
json_extract_path_text(properties, '$.backupPolicyId') as "backup_policy_id",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.dailyBackupsToKeep') as "daily_backups_to_keep",
json_extract_path_text(properties, '$.weeklyBackupsToKeep') as "weekly_backups_to_keep",
json_extract_path_text(properties, '$.monthlyBackupsToKeep') as "monthly_backups_to_keep",
json_extract_path_text(properties, '$.volumesAssigned') as "volumes_assigned",
json_extract_path_text(properties, '$.enabled') as "enabled",
json_extract_path_text(properties, '$.volumeBackups') as "volume_backups",
subscriptionId,
resourceGroupName,
accountName,
backupPolicyName
FROM azure_isv.netapp.backup_policies
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND accountName = 'replace-me';