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_policy_definition

Azure Policy establishes conventions for resources. Policy definitions describe resource compliance conditions and the effect to take if a condition is met. A condition compares a resource property field or a value to a required value.

Examples

Basic info

select
id,
name,
display_name,
type,
jsonb_pretty(policy_rule) as policy_rule
from
azure_policy_definition

Get the policy definition by display name

select
id,
name,
display_name,
type,
jsonb_pretty(policy_rule) as policy_rule
from
azure_policy_definition
where
display_name = 'Private endpoint connections on Batch accounts should be enabled';

.inspect azure_policy_definition

Azure Policy Definition

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
descriptiontextThe policy definition description.
display_nametextThe user-friendly display name of the policy definition.
idtextThe ID of the policy definition.
metadatajsonbThe policy definition metadata. Metadata is an open ended object and is typically a collection of key value pairs.
modetextThe policy definition mode. Some examples are All, Indexed, Microsoft.KeyVault.Data.
nametextThe name of the policy definition.
parametersjsonbThe parameter definitions for parameters used in the policy rule. The keys are the parameter names.
policy_rulejsonbThe policy rule.
policy_typetextThe type of policy definition. Possible values are NotSpecified, BuiltIn, Custom, and Static. Possible values include: 'NotSpecified', 'BuiltIn', 'Custom', 'Static'.
subscription_idtextThe Azure Subscription ID in which the resource is located.
titletextTitle of the resource.
typetextThe type of the resource (Microsoft.Authorization/policyDefinitions).