Table: azure_databox_edge_device - Query Azure Databox Edge Devices using SQL

Azure Databox Edge is a physical network appliance, shipped by Microsoft, that brings computation and storage capabilities to the edge of your network. It acts as a storage gateway, creating a link between your site and Azure storage. This device provides AI-enabled edge compute, network and storage capabilities.

Table Usage Guide

The azure_databox_edge_device table provides insights into Azure Databox Edge Devices within Microsoft Azure. As an IT administrator, explore device-specific details through this table, including the device's status, SKU, model description, and more. Utilize it to uncover information about the devices, such as their capacity, serial numbers, and the verification of device settings.

Examples

Basic info

Explore the status and geographical distribution of your Azure Databox Edge devices. This allows for efficient management and monitoring of your devices across different regions.

select
  name,
  id,
  type,
  data_box_edge_device_status,
  region
from
  azure_databox_edge_device;

select
  name,
  id,
  type,
  data_box_edge_device_status,
  region
from
  azure_databox_edge_device;

List offline data box edge devices

Determine the areas in which Azure Databox Edge devices are currently offline. This can be useful for identifying potential network issues or maintenance needs in your infrastructure.

select
  name,
  id,
  type,
  data_box_edge_device_status
from
  azure_databox_edge_device
where
  data_box_edge_device_status = 'Offline';

select
  name,
  id,
  type,
  data_box_edge_device_status
from
  azure_databox_edge_device
where
  data_box_edge_device_status = 'Offline';

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_databox_edge_device