DDSQL Common Queries and Use Cases

문서 > DDSQL Editor > DDSQL Editor Guides > DDSQL Common Queries and Use Cases

이 페이지는 아직 한국어로 제공되지 않으며 번역 작업 중입니다. 번역에 관한 질문이나 의견이 있으시면 언제든지 저희에게 연락해 주십시오.

General queries

List all libraries across services in production

SELECT
    c.service_name,
    c.team,
    lib.library_name,
    lib.eol,
    lib.last_commit,
    lib.newer_versions_number,
    lib.library_version,
    lib.latest_version,
    lib.ecosystem,
    lib.language,
    lib.license,
    lib.license_type
FROM service_definition c
JOIN library lib ON lib.asset_name = c.service_name
WHERE
    lib.env = 'production'
    AND lib.relation = 'DIRECT'
    AND LOWER(c.domain) = 'domain_name'
    AND LOWER(c.vertical) = 'account'
    AND LOWER(c.type) = 'service'
ORDER BY lib.newer_versions_number DESC

List services running an old version of the tracer

SELECT *
FROM service_config
WHERE client_library_version < '1.31.0';

AWS

List of RDS instances that require SSL/TLS certificate rotation

SELECT account_id,
  aws_organisation,
  aws_environment db_instance_identifier,
  display_name,
  ca_certificate_identifier,
  engine,
  engine_version,
  tags
FROM aws_rds_instance
WHERE ca_certificate_identifier like 'rds-ca-2019'

List EBS snapshots in progress

SELECT description,
  account_id,
  progress
FROM aws_ebs_snapshot
WHERE LOWER(state) != 'completed'
  and LOWER(state) != 'available'

List lambda functions with a specific outdated runtime (in this case python 2.7)

SELECT *
FROM aws_lambda_function
WHERE runtime = 'python2.7'
LIMIT 100;

DDSQL Common Queries and Use Cases

General queries

List all libraries across services in production

List services running an old version of the tracer

AWS

List of RDS instances that require SSL/TLS certificate rotation

List EBS snapshots in progress

List lambda functions with a specific outdated runtime (in this case python 2.7)

Further reading