turbot/azure

steampipe plugin install azuresteampipe plugin install azure

Azure + Steampipe

Azure provides on-demand cloud computing platforms and APIs to authenticated customers on a metered pay-as-you-go basis.

Steampipe is an open source CLI to instantly query cloud APIs using SQL.

For example:

select
display_name,
user_type
from
azure_ad_user
+----------------------+-----------+
| display_name | user_type |
+----------------------+-----------+
| Dwight Schrute | Member |
| Jim Halpert | Member |
| Pam Beesly | Member |
| Michael Scott | Member |
| Stanley Hudson | Member |
+----------------------+-----------+

Documentation

Get started

Install

Download and install the latest Azure plugin:

steampipe plugin install azure

Credentials

ItemDescription
CredentialsUse the az login command to setup your Azure Default Connection
PermissionsGrant the Global Reader permission to your user.
RadiusEach connection represents a single Azure Subscription.
Resolution1. Client Credentials
2. Client Certificate
3. Resource Owner Password
4. Azure Managed Service Identity
5. If no credentials are supplied, then the az cli credentials are used

Configuration

Installing the latest azure plugin will create a config file (~/.steampipe/config/azure.spc) with a single connection named azure:

connection "azure_sub_000000" {
plugin = "azure"
subscription_id = "00000000-0000-0000-0000-000000000000"
}

Get involved