steampipe plugin install awssteampipe plugin install aws

Table: aws_directory_service_directory

AWS Directory Service for Microsoft Active Directory, also known as AWS Managed Microsoft Active Directory (AD), enables your directory-aware workloads and AWS resources to use managed Active Directory (AD) in AWS.

Examples

Basic Info

select
  name,
  arn,
  directory_id
from
  aws_directory_service_directory;

List MicrosoftAD type directories

select
  name,
  arn,
  directory_id,
  type
from
  aws_directory_service_directory
where
  type = 'MicrosoftAD';

Get details about the shared directories

select
  name,
  directory_id,
  sd ->> 'ShareMethod' share_method,
  sd ->> 'ShareStatus' share_status,
  sd ->> 'SharedAccountId' shared_account_id,
  sd ->> 'SharedDirectoryId' shared_directory_id
from
  aws_directory_service_directory,
  jsonb_array_elements(shared_directories) sd;

Get snapshot limit details of each directory

select
  name,
  directory_id,
  snapshot_limit ->> 'ManualSnapshotsCurrentCount' as manual_snapshots_current_count,
  snapshot_limit ->> 'ManualSnapshotsLimit' as manual_snapshots_limit,
  snapshot_limit ->> 'ManualSnapshotsLimitReached' as manual_snapshots_limit_reached
from
  aws_directory_service_directory;

select
  name,
  directory_id,
  e ->> 'CreatedDateTime' as topic_created_date_time,
  e ->> 'Status' as topic_status,
  e ->> 'TopicArn' as topic_arn,
  e ->> 'TopicName' as topic_name
from
  aws_directory_service_directory,
  jsonb_array_elements(event_topics) as e;

Control examples

.inspect aws_directory_service_directory

AWS Directory Service Directory

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
access_url	text	The access URL for the directory, such as http://<alias>.awsapps.com.
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.
alias	text	The alias for the directory.
arn	text	The Amazon Resource Name (ARN) that uniquely identifies the directory.
connect_settings	jsonb	A DirectoryConnectSettingsDescription object that contains additional information about an AD Connector directory.
description	text	The description for the directory.
desired_number_of_domain_controllers	bigint	The desired number of domain controllers in the directory if the directory is Microsoft AD.
directory_id	text	The directory identifier.
dns_ip_addrs	jsonb	The IP addresses of the DNS servers for the directory.
edition	text	The edition associated with this directory.
event_topics	jsonb	Amazon SNS topic names that receive status messages from the specified Directory ID.
launch_time	timestamp with time zone	Specifies when the directory was created.
name	text	The fully qualified name of the directory.
owner_directory_description	jsonb	Describes the AWS Managed Microsoft AD directory in the directory owner account.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
radius_settings	jsonb	A RadiusSettings object that contains information about the RADIUS server.
radius_status	text	The status of the RADIUS MFA server connection.
region	text	The AWS Region in which the resource is located.
regions_info	jsonb	Lists the Regions where the directory has replicated.
share_method	text	The method used when sharing a directory to determine whether the directory should be shared within your AWS organization (ORGANIZATIONS) or with any AWS account by sending a shared directory request (HANDSHAKE).
share_notes	text	A directory share request that is sent by the directory owner to the directory consumer.
share_status	text	Current directory status of the shared AWS Managed Microsoft AD directory.
shared_directories	jsonb	Details about the shared directory in the directory owner account for which the share request in the directory consumer account has been accepted.
short_name	text	The short name of the directory.
size	text	The directory size.
snapshot_limit	jsonb	Obtains the manual snapshot limits for a directory.
sso_enabled	boolean	Indicates if single sign-on is enabled for the directory. For more information, see EnableSso and DisableSso.
stage	text	The current stage of the directory.
stage_last_updated_date_time	timestamp with time zone	The date and time that the stage was last updated.
stage_reason	text	Additional information about the directory stage.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags currently associated with the Directory Service Directory.
title	text	Title of the resource.
type	text	The directory type.
vpc_settings	jsonb	A DirectoryVpcSettingsDescription object that contains additional information about a directory.

turbot/aws

Table: aws_directory_service_directory

Examples

Basic Info

List MicrosoftAD type directories

Get details about the shared directories

Get snapshot limit details of each directory

Control examples

.inspect aws_directory_service_directory

Steampipe

Resources

Community

turbot/aws

Table: aws_directory_service_directory

Examples

Basic Info

List MicrosoftAD type directories

Get details about the shared directories

Get snapshot limit details of each directory

Get SNS topic details of each directory

Control examples

.inspect aws_directory_service_directory