steampipe plugin install awssteampipe plugin install aws

Table: aws_service_discovery_service

The AWS Service Discovery service is a fully managed service that allows you to easily discover, register, and connect services within your AWS infrastructure. It simplifies the process of building and managing complex distributed applications by providing a way for services to locate and communicate with each other dynamically.

Examples

Basic info

select
  name,
  id,
  arn,
  type,
  region
from
  aws_service_discovery_service;

List DNS services

select
  name,
  id,
  arn,
  type,
  create_date
from
  aws_service_discovery_service
where
  type ilike '%dns%';

List HTTP type services

select
  name,
  id,
  arn,
  type,
  description
from
  aws_service_discovery_service
where
  type = 'HTTP';

List services created in the last 30 days

select
  name,
  id,
  description,
  create_date
from
  aws_service_discovery_service
where
  create_date >= now() - interval '30' day;

Count services by type

select
  type,
  count(type)
from
  aws_service_discovery_service
group by
  type;

Get health check config details of services

select
  name,
  id,
  health_check_config ->> 'Type' as health_check_type,
  health_check_config ->> 'FailureThreshold' as failure_threshold,
  health_check_config ->> 'ResourcePath' as resource_path
from
  aws_service_discovery_service;

Get custom health check config details of services

select
  name,
  id,
  health_check_custom_config ->> 'FailureThreshold' as failure_threshold
from
  aws_service_discovery_service;

Get namespace details of services

select
  s.name,
  s.id,
  s.namespace_id,
  n.service_count,
  n.type as namespace_type,
  n.dns_properties
from
  aws_service_discovery_service as s,
  aws_service_discovery_namespace as n;

.inspect aws_service_discovery_service

AWS Service Discovery Service

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Amazon Resource Name (ARN) that Cloud Map assigns to the service when you create it.
create_date	timestamp with time zone	The date and time that the service was created.
description	text	A description for the service.
dns_records	jsonb	An array that contains one DnsRecord object for each Route 53 DNS record that you want Cloud Map to create when you register an instance.
health_check_config	jsonb	Public DNS and HTTP namespaces only. Settings for an optional health check. If you specify settings for a health check, Cloud Map associates the health check with the records that you specify in DnsConfig.
health_check_custom_config	jsonb	Information about an optional custom health check.
id	text	The ID that Cloud Map assigned to the service when you created it.
instance_count	bigint	The number of instances that are currently associated with the service.
name	text	The name of the service.
namespace_id	text	The ID of the namespace.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
routing_policy	text	The routing policy that you want to apply to all Route 53 DNS records that Cloud Map creates when you register an instance and specify this service.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	Information about the tags associated with the namespace.
title	text	Title of the resource.
type	text	Describes the systems that can be used to discover the service instances. DNS_HTTP The service instances can be discovered using either DNS queries or the DiscoverInstances API operation. HTTP The service instances can only be discovered using the DiscoverInstances API operation. DNS Reserved.

turbot/aws