turbot/azure_tags

Azure Tags Mod

Run tagging controls across all your Azure subscriptions to look for untagged resources, missing tags, resources with too many tags, and more.

References

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.

Steampipe Mods are collections of named queries, and codified controls that can be used to test current configuration of your cloud resources against a desired configuration.

Documentation

Getting started

Installation

1) Install the Azure plugin:

steampipe plugin install azure

2) Clone this repo:

git clone https://github.com/turbot/steampipe-mod-azure-tags.git
cd steampipe-mod-azure-tags

Usage

Running benchmarks

Preview running all benchmarks:

steampipe check all --dry-run

Run all benchmarks:

steampipe check all

Use Steampipe introspection to view all current benchmarks:

steampipe query "select resource_name, title, description from steampipe_benchmark;"

Run an individual benchmark:

steampipe check benchmark.untagged

Running controls

Use Steampipe introspection to view all current controls:

steampipe query "select resource_name, title, description from steampipe_control;"

Run a specific control:

steampipe check control.compute_virtual_machine_untagged

Credentials

This mod uses the credentials configured in the Steampipe Azure plugin.

Configuration

Several benchmarks have input variables that can be configured to better match your environment and requirements. Each variable has a default defined in steampipe.spvars, but these can be overriden in several ways:

  • Modify the steampipe.spvars file
  • Remove or comment out the value in steampipe.spvars, after which Steampipe will prompt you for a value when running a query or check
  • Pass in a value on the command line:
    steampipe check benchmark.mandatory --var 'mandatory_tags=["Application", "Environment", "Department", "Owner"]'
  • Set an environment variable:
    SP_VAR_mandatory_tags='["Application", "Environment", "Department", "Owner"]' steampipe check control.compute_virtual_machine_mandatory
    • Note: When using environment variables, if the variable is defined in steampipe.spvars or passed in through the command line, either of those will take precedence over the environment variable value. For more information on variable definition precedence, please see the link below.

These are only some of the ways you can set variables. For a full list, please see Passing Input Variables.

Advanced usage

Remediation

Using the control output and the Azure CLI, you can remediate various tagging issues.

For instance, with the results of the compute_virtual_machine_mandatory control, you can add missing tags with the Azure CLI:

#!/bin/bash
OLDIFS=$IFS
IFS='#'
INPUT=$(steampipe check control.compute_virtual_machine_mandatory --var 'mandatory_tags=["Application"]' --output csv --header=false --separator '#' | grep 'alarm')
[ -z "$INPUT" ] && { echo "No virtual machines in alarm, aborting"; exit 0; }
while read -r group_id title description control_id control_title control_description reason resource status resource_group subscription
do
az tag create --resource-id ${resource} --tags Application=MyApplication
done <<< "$INPUT"
IFS=$OLDIFS

To remove prohibited tags from Compute virtual machines:

#!/bin/bash
OLDIFS=$IFS
IFS='#'
INPUT=$(steampipe check control.compute_virtual_machine_mandatory --var 'prohibited_tags=["Password"]' --output csv --header=false --separator '#' | grep 'alarm')
[ -z "$INPUT" ] && { echo "No virtual machines in alarm, aborting"; exit 0; }
while read -r group_id title description control_id control_title control_description reason resource status resource_group subscription
do
az tag delete --resource-id ${resource} --name Password --yes
done <<< "$INPUT"
IFS=$OLDIFS

Get involved