Table: azure_iothub_dps - Query Azure IoT Hub Device Provisioning Services using SQL

Azure IoT Hub Device Provisioning Service is a helper service for IoT Hub that enables zero-touch, just-in-time provisioning to the right IoT hub without requiring human intervention, enabling customers to provision millions of devices in a secure and scalable manner. It provides a seamless, highly scalable way to register and provision IoT devices with an IoT hub. It enables customers to automate the process of registering devices with IoT Hub, reducing the complexity of initial device setup.

Table Usage Guide

The azure_iothub_dps table provides insights into Device Provisioning Services within Azure IoT Hub. As an IoT developer, explore device-specific details through this table, including status, registration, and configuration. Utilize it to uncover information about devices, such as their provisioning status, the IoT hub they are associated with, and the attestation mechanism used.

Examples

Basic info

Explore which Azure IoT Hub Device Provisioning Services (DPS) are available and where they are located to better manage and distribute your IoT devices across different regions. This helps in planning and optimizing the distribution of your IoT devices.

select
  name,
  id,
  region,
  type
from
  azure_iothub_dps;

select
  name,
  id,
  region,
  type
from
  azure_iothub_dps;

List iot hub dps which are not active

Determine the areas in which IoT Hub Device Provisioning Services within Azure are not currently active. This can be beneficial for identifying potential issues or areas of underutilization within your IoT network.

select
  name,
  id,
  region,
  type
from
  azure_iothub_dps
where
  state <> 'Active';

select
  name,
  id,
  region,
  type
from
  azure_iothub_dps
where
  state != 'Active';

Schema for azure_iothub_dps

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.
allocation_policy	text		Allocation policy to be used by this provisioning service.
authorization_policies	jsonb		List of authorization keys for a provisioning service.
cloud_environment	text		The Azure Cloud Environment.
device_provisioning_host_name	text		Device endpoint for this provisioning service.
diagnostic_settings	jsonb		A list of active diagnostic settings for the iot dps.
etag	text		An unique read-only string that changes whenever the resource is updated.
id	text		The resource identifier.
id_scope	text		Unique identifier of this provisioning service..
iot_hubs	jsonb		List of IoT hubs associated with this provisioning service.
name	text	=	The resource name.
provisioning_state	text		The ARM provisioning state of the provisioning service.
region	text		The Azure region/location in which the resource is located.
resource_group	text	=	The resource group which holds this resource.
service_operations_host_name	text		Service endpoint for provisioning service.
sku_capacity	text		Iot dps SKU capacity.
sku_name	text		Iot dps SKU name.
sku_tier	text		Iot dps SKU tier.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		Current state of the provisioning service.
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_dps