Skip to main content

vw_accounts_properties

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

Overview​

Namevw_accounts_properties
TypeView
Idazure.storage.vw_accounts_properties

Fields​

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

SQL Definition​

SELECT
location as location,
sku as sku,
kind as kind,
identity as identity,
extendedLocation as extended_location,
tags as tags,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.primaryEndpoints') as "primary_endpoints",
JSON_EXTRACT(properties, '$.primaryLocation') as "primary_location",
JSON_EXTRACT(properties, '$.statusOfPrimary') as "status_of_primary",
JSON_EXTRACT(properties, '$.lastGeoFailoverTime') as "last_geo_failover_time",
JSON_EXTRACT(properties, '$.secondaryLocation') as "secondary_location",
JSON_EXTRACT(properties, '$.statusOfSecondary') as "status_of_secondary",
JSON_EXTRACT(properties, '$.creationTime') as "creation_time",
JSON_EXTRACT(properties, '$.customDomain') as "custom_domain",
JSON_EXTRACT(properties, '$.sasPolicy') as "sas_policy",
JSON_EXTRACT(properties, '$.keyPolicy') as "key_policy",
JSON_EXTRACT(properties, '$.keyCreationTime') as "key_creation_time",
JSON_EXTRACT(properties, '$.secondaryEndpoints') as "secondary_endpoints",
JSON_EXTRACT(properties, '$.encryption') as "encryption",
JSON_EXTRACT(properties, '$.accessTier') as "access_tier",
JSON_EXTRACT(properties, '$.azureFilesIdentityBasedAuthentication') as "azure_files_identity_based_authentication",
JSON_EXTRACT(properties, '$.supportsHttpsTrafficOnly') as "supports_https_traffic_only",
JSON_EXTRACT(properties, '$.networkAcls') as "network_acls",
JSON_EXTRACT(properties, '$.isSftpEnabled') as "is_sftp_enabled",
JSON_EXTRACT(properties, '$.isLocalUserEnabled') as "is_local_user_enabled",
JSON_EXTRACT(properties, '$.enableExtendedGroups') as "enable_extended_groups",
JSON_EXTRACT(properties, '$.isHnsEnabled') as "is_hns_enabled",
JSON_EXTRACT(properties, '$.geoReplicationStats') as "geo_replication_stats",
JSON_EXTRACT(properties, '$.failoverInProgress') as "failover_in_progress",
JSON_EXTRACT(properties, '$.largeFileSharesState') as "large_file_shares_state",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.routingPreference') as "routing_preference",
JSON_EXTRACT(properties, '$.blobRestoreStatus') as "blob_restore_status",
JSON_EXTRACT(properties, '$.allowBlobPublicAccess') as "allow_blob_public_access",
JSON_EXTRACT(properties, '$.minimumTlsVersion') as "minimum_tls_version",
JSON_EXTRACT(properties, '$.allowSharedKeyAccess') as "allow_shared_key_access",
JSON_EXTRACT(properties, '$.isNfsV3Enabled') as "is_nfs_v3_enabled",
JSON_EXTRACT(properties, '$.allowCrossTenantReplication') as "allow_cross_tenant_replication",
JSON_EXTRACT(properties, '$.defaultToOAuthAuthentication') as "default_to_oauth_authentication",
JSON_EXTRACT(properties, '$.publicNetworkAccess') as "public_network_access",
JSON_EXTRACT(properties, '$.immutableStorageWithVersioning') as "immutable_storage_with_versioning",
JSON_EXTRACT(properties, '$.allowedCopyScope') as "allowed_copy_scope",
JSON_EXTRACT(properties, '$.storageAccountSkuConversionStatus') as "storage_account_sku_conversion_status",
JSON_EXTRACT(properties, '$.dnsEndpointType') as "dns_endpoint_type",
JSON_EXTRACT(properties, '$.isSkuConversionBlocked') as "is_sku_conversion_blocked",
JSON_EXTRACT(properties, '$.accountMigrationInProgress') as "account_migration_in_progress",
subscriptionId,
resourceGroupName,
accountName
FROM azure.storage.accounts_properties
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND accountName = 'replace-me';