Oracle Cloud Thrifty Mod for Steampipe

An Oracle Cloud cost savings and waste checking tool.

Run checks in a dashboard:

Includes checks for:

• Underused Autonomous Databases
• Unused, underused and oversized Compute Instances
• Unused, underused and oversized Block Volumes and Backups
• Object Storage Buckets without lifecycle policies
• Unattached Network Public IPs
• #TODO List

Getting started

Installation

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

brew tap turbot/tap
brew install steampipe

Install the Oracle Cloud plugin with Steampipe:

steampipe plugin install oci

Clone:

git clone https://github.com/turbot/steampipe-mod-oci-thrifty.git
cd steampipe-mod-oci-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_instance_long_running

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

Credentials

This mod uses the credentials configured in the Steampipe OCI 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/compute.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.block_volume --var=boot_and_block_volume_max_size_gb=100

• Set an environment variable:

  SP_VAR_boot_and_block_volume_max_size_gb=100 steampipe check control.boot_and_block_volume_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.

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.

• Join our Slack community → and hang out with other Mod developers.

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:

• Steampipe
• OCI Thrifty Mod