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_read_ops

GCP Monitoring metrics provide data about the performance of your systems. The azure_compute_disk_metric_read_ops table provides metric statistics at 5 minutes intervals for the most recent 5 days.

Examples

Basic info

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

Operations Over 10 Bytes average

select
name,
timestamp,
round(minimum::numeric,2) as min_read_ops,
round(maximum::numeric,2) as max_read_ops,
round(average::numeric,2) as avg_read_ops,
sample_count
from
azure_compute_disk_metric_read_ops
where
average > 10
order by
name,
timestamp;

.inspect azure_compute_disk_metric_read_ops

Azure Compute Disk Metrics - Read Ops

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.