turbot/azure

steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_api_managementazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_application_security_groupazure_compute_availability_setazure_compute_diskazure_compute_disk_encryption_setazure_compute_disk_metric_read_opsazure_compute_disk_metric_read_ops_dailyazure_compute_disk_metric_read_ops_hourlyazure_compute_disk_metric_write_opsazure_compute_disk_metric_write_ops_dailyazure_compute_disk_metric_write_ops_hourlyazure_compute_imageazure_compute_resource_skuazure_compute_snapshotazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_cosmosdb_accountazure_cosmosdb_mongo_databaseazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_diagnostic_settingazure_express_route_circuitazure_firewallazure_key_vaultazure_key_vault_keyazure_key_vault_secretazure_kubernetes_clusterazure_locationazure_log_alertazure_log_profileazure_management_lockazure_mysql_serverazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_serverazure_providerazure_public_ipazure_resource_groupazure_role_assignmentazure_role_definitionazure_route_tableazure_security_center_auto_provisioningazure_security_center_contactazure_security_center_settingazure_security_center_subscription_pricingazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_tableazure_storage_table_serviceazure_subnetazure_subscriptionazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_storage_blob_service

The properties of a storage account's Blob service endpoint, including properties for Storage Analytics, CORS (Cross-Origin Resource Sharing) rules and soft delete settings.

Examples

Basic info

select
name,
storage_account_name,
location,
sku_name,
sku_tier
from
azure_storage_blob_service;

List of storage blob service where delete retention policy is not enabled

select
name,
storage_account_name,
delete_retention_policy -> 'enabled' as delete_retention_policy_enabled
from
azure_storage_blob_service
where
delete_retention_policy -> 'enabled' = 'false';

List of storage blob service where versioning is not enabled

select
name,
storage_account_name,
is_versioning_enabled
from
azure_storage_blob_service
where
not is_versioning_enabled;

CORS rules info for storage blob service

select
name,
storage_account_name,
cors -> 'allowedHeaders' as allowed_headers,
cors -> 'allowedMethods' as allowed_methods,
cors -> 'allowedMethods' as allowed_methods,
cors -> 'exposedHeaders' as exposed_headers,
cors -> 'maxAgeInSeconds' as max_age_in_seconds
from
azure_storage_blob_service
cross join jsonb_array_elements(cors_rules) as cors;

.inspect azure_storage_blob_service

Azure Storage Blob Service

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
automatic_snapshot_policy_enabledbooleanSpecifies whether automatic snapshot creation is enabled, or not
change_feed_enabledbooleanSpecifies whether change feed event logging is enabled for the Blob service
container_delete_retention_policyjsonbThe blob service properties for container soft delete
cors_rulesjsonbA list of CORS rules for a storage account’s Blob service
default_service_versiontextIndicates the default version to use for requests to the Blob service if an incoming request’s version is not specified
delete_retention_policyjsonbThe blob service properties for blob soft delete
idtextContains ID to identify a blob uniquely
is_versioning_enabledbooleanSpecifies whether the versioning is enabled, or not
nametextThe friendly name that identifies the blob
regiontextThe Azure region/location in which the resource is located.
resource_grouptextThe resource group which holds this resource.
restore_policyjsonbThe blob service properties for blob restore policy
sku_nametextThe sku name
sku_tiertextContains the sku tier
storage_account_nametextA unique read-only string that changes whenever the resource is updated
subscription_idtextThe Azure Subscription ID in which the resource is located.
titletextTitle of the resource.
typetextType of the resource