Table: guardrails_mod_version - Query Guardrails Mod Versions using SQL

Guardrails is a service that helps manage and enforce security, compliance, and operational policies across your cloud environments. It provides a unified view of policy enforcement and compliance status across multiple cloud providers, accounts, and regions. The Mod Versions within Guardrails represent different versions of these policies, including their details and associated metadata.

Table Usage Guide

The guardrails_mod_version table provides insights into the different versions of policies within Guardrails. As a security or compliance officer, explore policy version-specific details through this table, including version numbers, descriptions, and associated metadata. Utilize it to track changes over time, understand the evolution of your policies, and ensure compliance with your organizational standards.

Examples

Version details for aws mod

Analyze the settings to understand the status and version of the AWS module in use within your workspace. This is useful to ensure you're working with the most current version and to troubleshoot any version-related issues.

select
  name,
  version,
  status,
  workspace
from
  guardrails_mod_version
where
  name = 'aws';

select
  name,
  version,
  status,
  workspace
from
  guardrails_mod_version
where
  name = 'aws';

Get recommended mod version for aws-acm

Explore the recommended version status for a specific module in the Guardrails, allowing you to ensure you're using the most suitable version for optimal performance.

select
  name,
  version,
  status
from
  guardrails_mod_version
where
  name = 'aws-acm'
  and status = 'RECOMMENDED';

select
  name,
  version,
  status
from
  guardrails_mod_version
where
  name = 'aws-acm'
  and status = 'RECOMMENDED';

List available mod versions for aws-acm

Explore the available versions of a specific module in your AWS Certificate Manager to keep track of updates or changes. This can be useful in maintaining the security and functionality of your environment.

select
  name,
  version,
  status
from
  guardrails_mod_version
where
  name = 'aws-acm'
  and status = 'AVAILABLE';

select
  name,
  version,
  status
from
  guardrails_mod_version
where
  name = 'aws-acm'
  and status = 'AVAILABLE';

List mod versions using the filter syntax

Explore which mod versions are currently in use and their status, specifically those associated with the 'aws-x' filter. This can be useful for understanding the distribution and application of different mod versions in your environment.

select
  name,
  version,
  status
from
  guardrails_mod_version
where
  filter = 'aws-x';

select
  name,
  version,
  status
from
  guardrails_mod_version
where
  filter = 'aws-x';

Schema for guardrails_mod_version

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
filter	text	=	Filter used to search for mod versions.
identity_name	text		The indentity name of the mod.
mod_peer_dependency	jsonb		Peer dependencies of the mod.
name	text	=	The name of the mod.
org_name	text	=	The name of the organization.
status	text	=	The status of the mod version.
version	text		The version of the mod.
workspace	text		Specifies the workspace URL.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- guardrails

You can pass the configuration to the command with the --config argument:

steampipe_export_guardrails --config '<your_config>' guardrails_mod_version