steampipe plugin install awssteampipe 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;

Control examples

Schema for aws_fsx_file_system

Name	Type	Operators	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.
administrative_actions	jsonb		A list of administrative actions for the file system that are in process or waiting to be processed.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
arn	text		The Amazon Resource Name (ARN) for the EFS file system.
creation_time	timestamp with time zone		The time that the file system was created.
dns_name	text		The DNS name for the file system.
failure_details	jsonb		A structure providing details of any failures that occur when creating the file system has failed.
file_system_id	text	=	The system-generated, unique 17-digit ID of the file system.
file_system_type	text		The type of Amazon FSx file system, which can be LUSTRE, WINDOWS, or ONTAP.
file_system_type_version	text		The version of your Amazon FSx for Lustre file system, either 2.10 or 2.12.
kms_key_id	text		The ID of the Key Management Service (KMS) key used to encrypt the file system's.
lifecycle	text		The lifecycle status of the file system, following are the possible values AVAILABLE, CREATING, DELETING, FAILED, MISCONFIGURED, UPDATING.
lustre_configuration	jsonb		The configuration for the Amazon FSx for Lustre file system.
network_interface_ids	jsonb		The IDs of the elastic network interface from which a specific file system is accessible.
ontap_configuration	jsonb		The configuration for this FSx for NetApp ONTAP file system.
open_zfs_configuration	jsonb		The configuration for this FSx for NetApp ONTAP file system.
owner_id	text		The AWS account that created the file system.
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.
storage_capacity	bigint		The storage capacity of the file system in gibibytes (GiB).
storage_type	text		The storage type of the file system.
subnet_ids	jsonb		Specifies the IDs of the subnets that the file system is accessible from.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		A list of tags associated with Filesystem.
title	text		Title of the resource.
vpc_id	text		The ID of the primary VPC for the file system.
windows_configuration	jsonb		The 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