Table: aws_iam_server_certificates

This table shows data for IAM Server Certificates.

https://docs.aws.amazon.com/IAM/latest/APIReference/API_ServerCertificateMetadata.html (opens in a new tab)

The composite primary key for this table is (account_id, id).

Columns

Example Queries

These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.

Ensure that all the expired SSL/TLS certificates stored in AWS IAM are removed (Automated)

SELECT
  'Ensure that all the expired SSL/TLS certificates stored in AWS IAM are removed (Automated)'
    AS title,
  account_id,
  arn AS resource_id,
  CASE
  WHEN expiration < timezone('UTC', now()) THEN 'fail'
  ELSE 'pass'
  END
    AS status
FROM
  aws_iam_server_certificates;