steampipe plugin install azuresteampipe plugin install azure

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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
authorization_policies	jsonb		The shared access policies you can use to secure a connection to the iot hub.
cloud_environment	text		The Azure Cloud Environment.
cloud_to_device	jsonb		CloudToDevice properties of the iot hub.
comments	text		Iot hub comments.
diagnostic_settings	jsonb		A list of active diagnostic settings for the iot hub.
enable_file_upload_notifications	boolean		Indicates if file upload notifications are enabled for the iot hub.
etag	text		An unique read-only string that changes whenever the resource is updated.
event_hub_endpoints	jsonb		The event hub-compatible endpoint properties.
features	text		The capabilities and features enabled for the iot hub. Possible values include: 'None', 'DeviceManagement'.
host_name	text		The name of the host.
id	text		The resource identifier.
ip_filter_rules	jsonb		The IP filter rules of the iot hub.
locations	jsonb		Primary and secondary location for iot hub.
messaging_endpoints	jsonb		The messaging endpoint properties for the file upload notification queue.
min_tls_version	text		Specifies the minimum TLS version to support for this iot hub.
name	text	=	The resource name.
private_endpoint_connections	jsonb		Private endpoint connections created on this iot hub.
provisioning_state	text		The iot hub provisioning state.
public_network_access	text		Indicates whether requests from public network are allowed.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
routing	jsonb		Routing properties of the iot hub.
sku_capacity	text		Iot hub SKU capacity.
sku_name	text		Iot hub SKU name.
sku_tier	text		Iot hub SKU tier.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The iot hub state.
storage_endpoints	jsonb		The list of azure storage endpoints where you can upload files.
subscription_id	text	=, !=, ~~, ~~, !~~, !~~	The Azure Subscription ID in which the resource is located.
tags	jsonb		A map of tags for the resource.
title	text		Title of the resource.
type	text		The 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