steampipe plugin install aws

Table: aws_fsx_file_system - Query AWS FSx File Systems using SQL

The AWS FSx File System is a fully managed service that makes it easy to launch and run feature-rich and highly-performant file systems. With FSx, you can leverage the rich feature sets and fast performance of widely-used open source and commercially-licensed file systems, while avoiding time-consuming administrative tasks. FSx is built on Windows Server, delivering a wide range of administrative features such as user quotas, end-user file restore, and Microsoft Active Directory integration.

Table Usage Guide

The aws_fsx_file_system table in Steampipe provides you with information about FSx File Systems within Amazon Web Services. This table allows you, as a DevOps engineer, to query file system-specific details, including its lifecycle, type, storage capacity, and associated tags. You can utilize this table to gather insights on file systems, such as their storage capacity, creation times, and statuses. The schema outlines the various attributes of the FSx File Systems for you, including the file system ID, owner ID, creation time, and associated tags.

Examples

Basic info

Explore the fundamental characteristics of your AWS FSx file systems, such as ownership details, creation time, and storage capacity. This can help manage resources and identify potential areas for optimization or troubleshooting.

select
file_system_id,
arn,
dns_name,
owner_id,
creation_time,
lifecycle,
storage_capacity
from
aws_fsx_file_system;
select
file_system_id,
arn,
dns_name,
owner_id,
creation_time,
lifecycle,
storage_capacity
from
aws_fsx_file_system;

List file systems which are encrypted

Discover the segments that are encrypted within your file systems to enhance your data security and privacy measures. This query is useful in identifying those file systems that have encryption enabled, ensuring compliance with data protection regulations.

select
file_system_id,
kms_key_id,
region
from
aws_fsx_file_system
where
kms_key_id is not null;
select
file_system_id,
kms_key_id,
region
from
aws_fsx_file_system
where
kms_key_id is not null;

Schema for aws_fsx_file_system

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
administrative_actionsjsonbA list of administrative actions for the file system that are in process or waiting to be processed.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) for the EFS file system.
creation_timetimestamp with time zoneThe time that the file system was created.
dns_nametextThe DNS name for the file system.
failure_detailsjsonbA structure providing details of any failures that occur when creating the file system has failed.
file_system_idtext=The system-generated, unique 17-digit ID of the file system.
file_system_typetextThe type of Amazon FSx file system, which can be LUSTRE, WINDOWS, or ONTAP.
file_system_type_versiontextThe version of your Amazon FSx for Lustre file system, either 2.10 or 2.12.
kms_key_idtextThe ID of the Key Management Service (KMS) key used to encrypt the file system's.
lifecycletextThe lifecycle status of the file system, following are the possible values AVAILABLE, CREATING, DELETING, FAILED, MISCONFIGURED, UPDATING.
lustre_configurationjsonbThe configuration for the Amazon FSx for Lustre file system.
network_interface_idsjsonbThe IDs of the elastic network interface from which a specific file system is accessible.
ontap_configurationjsonbThe configuration for this FSx for NetApp ONTAP file system.
open_zfs_configurationjsonbThe configuration for this FSx for NetApp ONTAP file system.
owner_idtextThe AWS account that created the file system.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
storage_capacitybigintThe storage capacity of the file system in gibibytes (GiB).
storage_typetextThe storage type of the file system.
subnet_idsjsonbSpecifies the IDs of the subnets that the file system is accessible from.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags associated with Filesystem.
titletextTitle of the resource.
vpc_idtextThe ID of the primary VPC for the file system.
windows_configurationjsonbThe configuration for this Microsoft Windows file system.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_fsx_file_system