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_virtual_machine_metric_cpu_utilization_hourly

GCP Monitoring metrics provide data about the performance of your systems. The azure_compute_virtual_machine_metric_cpu_utilization_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_virtual_machine_metric_cpu_utilization_hourly
order by
name,
timestamp;

CPU Over 80% average

select
name,
timestamp,
round(minimum::numeric,2) as min_cpu,
round(maximum::numeric,2) as max_cpu,
round(average::numeric,2) as avg_cpu,
sample_count
from
azure_compute_virtual_machine_metric_cpu_utilization_hourly
where
average > 80
order by
name,
timestamp;

.inspect azure_compute_virtual_machine_metric_cpu_utilization_hourly

Azure Compute Virtual Machine Metrics - CPU Utilization (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 virtual machine.
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.