turbot/azure_thrifty

GitHub

Azure Thrifty Mod

Be Thrifty on Azure! This mod checks for unused resources and opportunities to optimize your spend on Azure.

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

Download and install Steampipe (https://steampipe.io/downloads). Or use Brew:

brew tap turbot/tap
brew install steampipe

Install the Azure plugin with Steampipe:

steampipe plugin install azure

Clone:

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

Usage

Start your dashboard server to get started:

steampipe dashboard

By default, the dashboard interface will then be launched in a new browser window at https://localhost:9194. From here, you can run benchmarks by selecting one or searching for a specific one.

Instead of running benchmarks in a dashboard, you can also run them within your terminal with the steampipe check command:

Run all benchmarks:

steampipe check all

Run a single benchmark:

steampipe check benchmark.compute

Run a specific control:

steampipe check control.compute_disk_unattached

Different output formats are also available, for more information please see Output Formats.

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 its source file, e.g., controls/sql.sp, but these can be overwritten in several ways:

  • Copy and rename the steampipe.spvars.example file to steampipe.spvars, and then modify the variable values inside that file

  • Pass in a value on the command line:

    steampipe check benchmark.compute --var=compute_disk_max_size_gb=100
  • Set an environment variable:

    compute_disk_max_size_gb=100 steampipe check control.compute_disk_large
    • 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.

Common and Tag Dimensions

The benchmark queries use common properties (like connection_name, resource_group, region, subscription and subscription_id) and tags that are defined in the form of a default list of strings in the mod.sp file. These properties can be overwritten in several ways:

  • Copy and rename the steampipe.spvars.example file to steampipe.spvars, and then modify the variable values inside that file

  • Pass in a value on the command line:

    steampipe check benchmark.compute --var 'common_dimensions=["connection_name", "resource_group", "subscription"]'
    steampipe check benchmark.compute --var 'tag_dimensions=[ "Department", "Environment"]'
  • Set an environment variable:

    SP_VAR_common_dimensions='["connection_name", "resource_group", "subscription"]' steampipe check control.compute_disk_large
    SP_VAR_tag_dimensions='[ "Department", "Environment"]' steampipe check control.compute_disk_large

Contributing

If you have an idea for additional controls or just want to help maintain and extend this mod (or others) we would love you to join the community and start contributing.

Please see the contribution guidelines and our code of conduct. All contributions are subject to the Apache 2.0 open source license.

Want to help but not sure where to start? Pick up one of the help wanted issues: