steampipe plugin install azure

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
allocation_policytextAllocation policy to be used by this provisioning service.
authorization_policiesjsonbList of authorization keys for a provisioning service.
cloud_environmenttextThe Azure Cloud Environment.
device_provisioning_host_nametextDevice endpoint for this provisioning service.
diagnostic_settingsjsonbA list of active diagnostic settings for the iot dps.
etagtextAn unique read-only string that changes whenever the resource is updated.
idtextThe resource identifier.
id_scopetextUnique identifier of this provisioning service..
iot_hubsjsonbList of IoT hubs associated with this provisioning service.
nametext=The resource name.
provisioning_statetextThe ARM provisioning state of the provisioning service.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
service_operations_host_nametextService endpoint for provisioning service.
sku_capacitytextIot dps SKU capacity.
sku_nametextIot dps SKU name.
sku_tiertextIot dps SKU tier.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetextCurrent state of the provisioning service.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The 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_dps