turbot/gcp_thrifty

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

Params

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

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;

Tags