steampipe plugin install azuresteampipe plugin install azure
azure_ad_groupazure_ad_service_principalazure_ad_userazure_alert_managementazure_api_managementazure_api_management_backendazure_app_configurationazure_app_service_environmentazure_app_service_function_appazure_app_service_planazure_app_service_web_appazure_app_service_web_app_slotazure_application_gatewayazure_application_insightazure_application_security_groupazure_automation_accountazure_automation_variableazure_bastion_hostazure_batch_accountazure_cognitive_accountazure_compute_availability_setazure_compute_diskazure_compute_disk_accessazure_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_ssh_keyazure_compute_virtual_machineazure_compute_virtual_machine_metric_cpu_utilizationazure_compute_virtual_machine_metric_cpu_utilization_dailyazure_compute_virtual_machine_metric_cpu_utilization_hourlyazure_compute_virtual_machine_scale_setazure_compute_virtual_machine_scale_set_network_interfaceazure_compute_virtual_machine_scale_set_vmazure_consumption_usageazure_container_groupazure_container_registryazure_cosmosdb_accountazure_cosmosdb_mongo_collectionazure_cosmosdb_mongo_databaseazure_cosmosdb_restorable_database_accountazure_cosmosdb_sql_databaseazure_data_factoryazure_data_factory_datasetazure_data_factory_pipelineazure_data_lake_analytics_accountazure_data_lake_storeazure_databox_edge_deviceazure_databricks_workspaceazure_diagnostic_settingazure_dns_zoneazure_eventgrid_domainazure_eventgrid_topicazure_eventhub_namespaceazure_express_route_circuitazure_firewallazure_firewall_policyazure_frontdoorazure_hdinsight_clusterazure_healthcare_serviceazure_hpc_cacheazure_hybrid_compute_machineazure_hybrid_kubernetes_connected_clusterazure_iothubazure_iothub_dpsazure_key_vaultazure_key_vault_deleted_vaultazure_key_vault_keyazure_key_vault_key_versionazure_key_vault_managed_hardware_security_moduleazure_key_vault_secretazure_kubernetes_clusterazure_kubernetes_service_versionazure_kusto_clusterazure_lbazure_lb_backend_address_poolazure_lb_nat_ruleazure_lb_outbound_ruleazure_lb_probeazure_lb_ruleazure_locationazure_log_alertazure_log_profileazure_logic_app_workflowazure_machine_learning_workspaceazure_management_groupazure_management_lockazure_mariadb_serverazure_monitor_activity_log_eventazure_monitor_log_profileazure_mssql_elasticpoolazure_mssql_managed_instanceazure_mssql_virtual_machineazure_mysql_flexible_serverazure_mysql_serverazure_nat_gatewayazure_network_interfaceazure_network_security_groupazure_network_watcherazure_network_watcher_flow_logazure_policy_assignmentazure_policy_definitionazure_postgresql_flexible_serverazure_postgresql_serverazure_private_dns_zoneazure_providerazure_public_ipazure_recovery_services_backup_jobazure_recovery_services_vaultazure_redis_cacheazure_resource_groupazure_resource_linkazure_role_assignmentazure_role_definitionazure_route_tableazure_search_serviceazure_security_center_auto_provisioningazure_security_center_automationazure_security_center_contactazure_security_center_jit_network_access_policyazure_security_center_settingazure_security_center_sub_assessmentazure_security_center_subscription_pricingazure_service_fabric_clusterazure_servicebus_namespaceazure_signalr_serviceazure_spring_cloud_serviceazure_sql_databaseazure_sql_serverazure_storage_accountazure_storage_blobazure_storage_blob_serviceazure_storage_containerazure_storage_queueazure_storage_share_fileazure_storage_syncazure_storage_tableazure_storage_table_serviceazure_stream_analytics_jobazure_subnetazure_subscriptionazure_synapse_workspaceazure_tenantazure_virtual_networkazure_virtual_network_gateway

Table: azure_iothub - Query Azure IoT Hub using SQL

Azure IoT Hub is a managed service, hosted in the cloud, that acts as a central message hub for bi-directional communication between your IoT application and the devices it manages. It provides reliable and secure communication between millions of IoT devices and a cloud-hosted solution backend. Azure IoT Hub supports communications both from the device to the cloud and from the cloud to the device.

Table Usage Guide

The azure_iothub table provides insights into IoT Hubs within Azure. As a IoT developer or cloud solutions architect, explore IoT Hub-specific details through this table, including configurations, properties, and status. Utilize it to uncover information about each IoT Hub, such as its SKU, location, and the number of devices it can support, to ensure optimal performance and resource allocation.

Examples

Basic info

Explore the basic characteristics of your Azure IoT Hub resources, such as their names, IDs, regions, and types. This can help you manage your resources more effectively by understanding their distribution and categorization.

select
name,
id,
region,
type
from
azure_iothub;
select
name,
id,
region,
type
from
azure_iothub;

List hubs which are not active

Determine the areas in which certain hubs within the Azure IoT platform are not currently active. This can help prioritize troubleshooting efforts or identify opportunities for resource optimization.

select
name,
id,
region,
type
from
azure_iothub
where
state <> 'Active';
select
name,
id,
region,
type
from
azure_iothub
where
state != 'Active';

Control examples

Schema for azure_iothub

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
authorization_policiesjsonbThe shared access policies you can use to secure a connection to the iot hub.
cloud_environmenttextThe Azure Cloud Environment.
cloud_to_devicejsonbCloudToDevice properties of the iot hub.
commentstextIot hub comments.
diagnostic_settingsjsonbA list of active diagnostic settings for the iot hub.
enable_file_upload_notificationsbooleanIndicates if file upload notifications are enabled for the iot hub.
etagtextAn unique read-only string that changes whenever the resource is updated.
event_hub_endpointsjsonbThe event hub-compatible endpoint properties.
featurestextThe capabilities and features enabled for the iot hub. Possible values include: 'None', 'DeviceManagement'.
host_nametextThe name of the host.
idtextThe resource identifier.
ip_filter_rulesjsonbThe IP filter rules of the iot hub.
locationsjsonbPrimary and secondary location for iot hub.
messaging_endpointsjsonbThe messaging endpoint properties for the file upload notification queue.
min_tls_versiontextSpecifies the minimum TLS version to support for this iot hub.
nametext=The resource name.
private_endpoint_connectionsjsonbPrivate endpoint connections created on this iot hub.
provisioning_statetextThe iot hub provisioning state.
public_network_accesstextIndicates whether requests from public network are allowed.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
routingjsonbRouting properties of the iot hub.
sku_capacitytextIot hub SKU capacity.
sku_nametextIot hub SKU name.
sku_tiertextIot hub SKU tier.
statetextThe iot hub state.
storage_endpointsjsonbThe list of azure storage endpoints where you can upload files.
subscription_idtextThe Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextThe resource type.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_iothub