Skip to content
AWS for Query.Farm

aws.opsworks.describe_operating_systems

Example SQL Queries

SELECT * FROM
aws.opsworks.describe_operating_systems;

Description

Describes the operating systems that are supported by OpsWorks Stacks.

Table Definition

Column NameColumn Data Type
operating_systems

Contains information in response to a DescribeOperatingSystems request.

STRUCT(
    "name" VARCHAR,
    "id" VARCHAR,
    "type" VARCHAR,
    "configuration_managers" STRUCT(
        "name" VARCHAR,
        "version" VARCHAR
    )[],
    "reported_name" VARCHAR,
    "reported_version" VARCHAR,
    "supported" BOOLEAN
)[]
Show child fields
operating_systems[]
Show child fields
operating_systems[].configuration_managers[]
Show child fields
operating_systems[].configuration_managers[].name

The name of the configuration manager, which is Chef.

operating_systems[].configuration_managers[].version

The versions of the configuration manager that are supported by an operating system.

operating_systems[].id

The ID of a supported operating system, such as Amazon Linux 2.

operating_systems[].name

The name of the operating system, such as Amazon Linux 2.

operating_systems[].reported_name

A short name for the operating system manufacturer.

operating_systems[].reported_version

The version of the operating system, including the release and edition, if applicable.

operating_systems[].supported

Indicates that an operating system is not supported for new instances.

operating_systems[].type

The type of a supported operating system, either Linux or Windows.