Control: Instances with more then 32 vCPU should be reviewed

Description

Large compute instances are unusual, expensive and should be reviewed.

Usage

Run the control in your terminal:

powerpipe control run gcp_thrifty.control.compute_instance_large

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run gcp_thrifty.control.compute_instance_large --share

Steampipe Tables

gcp_compute_instance

SQL

select
  self_link as resource,
  case
    when status not in ('RUNNING', 'PROVISIONING', 'STAGING', 'REPAIRING') then 'info'
    when machine_type_name like any ($1) then 'ok'
    else 'info'
  end as status,
  title || ' has type ' || machine_type_name || ' and is ' || status || '.' as reason
  
  , location, project
from
  gcp_compute_instance;

Params

Args	Name	Default	Description	Variable
$1	compute_instance_allowed_types	`["%-micro","%-small","%-medium","%-2","%-4","%-8","%-16","%-30","%-32","%-1g","%-2g"]`	A list of allowed instance types. PostgreSQL wildcards are supported.	compute_instance_allowed_types

Control: Instances with more then 32 vCPU should be reviewed

Description

Usage

Steampipe Tables

SQL

Params

Tags