steampipe plugin install azure

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';

Schema for azure_databox_edge_device

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
configured_role_typesjsonbType of compute roles configured.
culturetextThe Data Box Edge/Gateway device culture.
data_box_edge_device_statustextThe status of the Data Box Edge/Gateway device. Possible values include: 'ReadyToSetup', 'Online', 'Offline', 'NeedsAttention', 'Disconnected', 'PartiallyDisconnected', 'Maintenance'.
descriptiontexthe Description of the Data Box Edge/Gateway device.
device_hcs_versiontextThe device software version number of the device (eg: 1.2.18105.6).
device_local_capacitybigintThe Data Box Edge/Gateway device local capacity in MB.
device_modeltextThe Data Box Edge/Gateway device model.
device_software_versiontextThe Data Box Edge/Gateway device software version.
device_typetextThe type of the Data Box Edge/Gateway device. Possible values include: 'DataBoxEdgeDevice'.
etagtextThe etag for the devices.
friendly_nametextThe Data Box Edge/Gateway device name.
idtextThe resource identifier.
locationtextThe location of the device. This is a supported and registered Azure geographical region (for example, West US, East US, or Southeast Asia). The geographical region of a device cannot be changed once it is created, but if an identical geographical region is specified on update, the request will succeed.
model_descriptiontextThe description of the Data Box Edge/Gateway device model.
nametext=The resource name.
node_countbigintThe number of nodes in the cluster.
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
serial_numbertextThe Serial Number of Data Box Edge/Gateway device.
sku_nametextSKU name of the resource. Possible values include: 'Gateway', 'Edge'.
sku_tiertextThe SKU tier. This is based on the SKU name. Possible values include: 'Standard'.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
time_zonetextThe Data Box Edge/Gateway device timezone.
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_databox_edge_device