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_compute_disk_metric_write_ops_hourly

GCP Monitoring metrics provide data about the performance of your systems. The azure_compute_disk_metric_write_ops_hourly table provides metric statistics at 1 hour intervals for the most recent 60 days.

Examples

Basic info

select
name,
timestamp,
minimum,
maximum,
average,
sample_count
from
azure_compute_disk_metric_write_ops_hourly
order by
name,
timestamp;

Operations Over 10 Bytes average

select
name,
timestamp,
round(minimum::numeric,2) as min_write_ops,
round(maximum::numeric,2) as max_write_ops,
round(average::numeric,2) as avg_write_ops,
sample_count
from
azure_compute_disk_metric_write_ops_hourly
where
average > 10
order by
name,
timestamp;

.inspect azure_compute_disk_metric_write_ops_hourly

Azure Compute Disk Metrics - Write Ops (Hourly)

NameTypeDescription
averagedouble precisionThe average of the metric values that correspond to the data point.
maximumdouble precisionThe maximum metric value for the data point.
minimumdouble precisionThe minimum metric value for the data point.
nametextThe name of the disk.
resource_grouptextThe resource group which holds this resource.
sample_countdouble precisionThe number of metric values that contributed to the aggregate value of this data point.
subscription_idtextThe Azure Subscription ID in which the resource is located.
sumdouble precisionThe sum of the metric values for the data point.
timestamptimestamp without time zoneThe time stamp used for the data point.
unittextThe units in which the metric value is reported.