Let’s install the mod, and run a check for a specific control in this example:Ĭloning into 'steampipe-mod-oci-compliance'.
Scratches the surface of the possibilities.įor more information, plus examples and instructions, be sure to visit the oci_compliance page. Team works on, and that made finding an oci_compliance module an excitingĬenter for Internet Security (CIS) compliance reporting built on top of Steampipe, and that just
Mods can be a collection of SQL scripts built for custom reporting. | oci_core_dhcp_options | OCI Core DHCP Options | oci_core_boot_volume_backup | OCI Core Boot Volume Backup | | oci_cloud_guard_target | OCI Cloud Guard Target | | oci_cloud_guard_responder_recipe | OCI Cloud Guard Responder Recipe | | oci_cloud_guard_managed_list | OCI Cloud Guard Managed List | | oci_cloud_guard_detector_recipe | OCI Cloud Guard Detector Recipe | | oci_cloud_guard_configuration | OCI Cloud Guard Configuration | | oci_autoscaling_auto_scaling_configuration | OCI Auto Scaling Configuration | | oci_apigateway_api | OCI Apigateway Api |
Other helpful commands in the shell (note that they all begin with a dot):Įxample of opening the CLI and listing the available tables: Shell, you can run queries by typing them out, or by copying and pasting them from an external Run the steampipe query command to enter the shell. Lastly, you can run an interactive Steampipe shell, which offers more tools for navigating | ok | Inventory not publicly accessible. | ok | bootstrap_testing not publicly accessible. | ok | jon-test-rep not publicly accessible. | resource | status | reason | region | compartment | Steampipe query objectstorage_bucket_public_access_blocked.sql You can install the plugin using the syntax below: Steampipe has a plugin which adds support for Oracle Cloud Infrastructure ( OCI). The instructions walk you through using Homebrew if you’re on a Mac, an installer script for Linux, or on Windows via Windows Subsystem for Linux with Ubuntu. Install instructions for Windows, Mac, and Linux are provided on the Steampipe webpage. See the official Steampipe introduction for more background. The tool seems to be growing quickly, so I’ll try to link to their excellent documentation whenever I have a chance. I had the opportunity to perform an evaluation of Steampipe, and I wanted to share some of my experiences. It supports multiple cloud providers (plugins), supports a Postgres-like SQL query language, and provides an interactive CLI to navigate through resources. Steampipe is a new open source tool for running queries against cloud resources. I admit that I haven’t used anything by Turbot in the past, but I’m an instant fan now that I’ve been pulled into the wonderful world of Steampipe. I must be virtually hanging out in the wrong circles these days, because Steampipe by Turbot seems like it came out of nowhere.
Photo credit: Photo by Gabriela Palai from Pexels