Skip to content
AWS for Query.Farm

aws.signer.list_signing_jobs

Example SQL Queries

SELECT * FROM
aws.signer.list_signing_jobs;

Description

Lists all your signing jobs. You can use the maxResults parameter to limit the number of signing jobs that are returned in the response. If additional jobs remain to be listed, AWS Signer returns a nextToken value. Use this value in subsequent calls to ListSigningJobs to fetch the remaining values. You can continue calling ListSigningJobs with your maxResults parameter and with new values that Signer returns in the nextToken parameter until all of your signing jobs have been returned.

Table Definition

Column NameColumn Data Type
is_revoked Input Column

Indicates whether the signing job is revoked.

BOOLEAN
job_invoker Input Column

The AWS account ID of the job invoker.

VARCHAR
platform_id Input Column

The unique identifier for a signing platform.

VARCHAR
requested_by Input Column

The IAM principal that requested the signing job.

VARCHAR
signature_expires_after Input Column

Filters results to return only signing jobs with signatures expiring after a specified timestamp.

TIMESTAMP_S
signature_expires_before Input Column

Filters results to return only signing jobs with signatures expiring before a specified timestamp.

TIMESTAMP_S
status Input Column

The status of the signing job.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
created_at

The date and time that the signing job was created.

TIMESTAMP_S
job_id

The ID of the signing job.

VARCHAR
job_owner

The AWS account ID of the job owner.

VARCHAR
platform_display_name

The name of a signing platform.

VARCHAR
profile_name

The name of the signing profile that created a signing job.

VARCHAR
profile_version

The version of the signing profile that created a signing job.

VARCHAR
signature_expires_at

The time when the signature of a signing job expires.

TIMESTAMP_S
signed_object

A SignedObject structure that contains information about a signing job's signed code image.

STRUCT(
    "s3" STRUCT(
        "bucket_name" VARCHAR,
        "key" VARCHAR
    )
)
Show child fields
signed_object.s3

The S3SignedObject.

Show child fields
signed_object.s3.bucket_name

Name of the S3 bucket.

signed_object.s3.key

Key name that uniquely identifies a signed code image in your bucket.

signing_material

A SigningMaterial object that contains the Amazon Resource Name (ARN) of the certificate used for the signing job.

STRUCT(
    "certificate_arn" VARCHAR
)
Show child fields
signing_material.certificate_arn

The Amazon Resource Name (ARN) of the certificates that is used to sign your code.

source

A Source that contains information about a signing job's code image source.

STRUCT(
    "s3" STRUCT(
        "bucket_name" VARCHAR,
        "key" VARCHAR,
        "version" VARCHAR
    )
)
Show child fields
source.s3

The S3Source object.

Show child fields
source.s3.bucket_name

Name of the S3 bucket.

source.s3.key

Key name of the bucket object that contains your unsigned code.

source.s3.version

Version of your source image in your version enabled S3 bucket.