steampipe plugin install azure

Table: azure_network_watcher - Query Azure Network Watchers using SQL

Azure Network Watcher is a network performance monitoring and diagnostic service that enables you to monitor and diagnose conditions at a network scenario level in, to, and from Azure. It provides you with the ability to understand your network performance and health. With Network Watcher, you can monitor and diagnose your network scenarios via provided metrics and logs.

Table Usage Guide

The azure_network_watcher table provides insights into Azure Network Watchers within Azure Networking. As a network engineer, explore network-specific details through this table, including network performance and health metrics. Utilize it to uncover information about network conditions, monitor and diagnose network scenarios, and verify network performance.

Examples

List of regions where network watcher is enabled

Determine the areas in which the Azure Network Watcher service is active. This is useful for understanding where network monitoring and diagnostic services are currently deployed in your Azure environment.

select
name,
region
from
azure_network_watcher;
select
name,
region
from
azure_network_watcher;

List of Network watcher without application tag key

Determine the areas in which Azure Network Watchers are operating without an assigned application tag key. This can be useful to identify potential gaps in your tagging strategy and ensure consistent metadata across your resources.

select
name,
tags
from
azure_network_watcher
where
not tags :: JSONB ? 'application';
select
name,
tags
from
azure_network_watcher
where
json_extract(tags, '$.application') is null;

Schema for azure_network_watcher

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
cloud_environmenttextThe Azure Cloud Environment.
etagtextAn unique read-only string that changes whenever the resource is updated
idtextContains ID to identify a network watcher uniquely
nametext=The friendly name that identifies the network watcher
provisioning_statetextThe provisioning state of the network watcher resource
regiontextThe Azure region/location in which the resource is located.
resource_grouptext=The resource group which holds this resource.
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.
titletextTitle of the resource.
typetextThe resource type of the network watcher

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_network_watcher