turbot/oci

steampipe plugin install ocisteampipe plugin install oci
oci_apigateway_apioci_autoscaling_auto_scaling_configurationoci_budget_alert_ruleoci_budget_budgetoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_core_block_volume_replicaoci_core_boot_volumeoci_core_boot_volume_attachmentoci_core_boot_volume_backupoci_core_boot_volume_metric_read_opsoci_core_boot_volume_metric_read_ops_dailyoci_core_boot_volume_metric_read_ops_hourlyoci_core_boot_volume_metric_write_opsoci_core_boot_volume_metric_write_ops_dailyoci_core_boot_volume_metric_write_ops_hourlyoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_instanceoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_database_autonomous_databaseoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_snapshotoci_functions_applicationoci_identity_api_keyoci_identity_auth_tokenoci_identity_authentication_policyoci_identity_availability_domainoci_identity_compartmentoci_identity_customer_secret_keyoci_identity_dynamic_groupoci_identity_groupoci_identity_network_sourceoci_identity_policyoci_identity_tag_defaultoci_identity_tag_namespaceoci_identity_tenancyoci_identity_useroci_kms_keyoci_kms_key_versionoci_kms_vaultoci_logging_logoci_logging_log_groupoci_mysql_backupoci_mysql_channeloci_mysql_db_systemoci_nosql_tableoci_nosql_table_metric_read_throttle_countoci_nosql_table_metric_read_throttle_count_dailyoci_nosql_table_metric_read_throttle_count_hourlyoci_nosql_table_metric_storage_utilizationoci_nosql_table_metric_storage_utilization_dailyoci_nosql_table_metric_storage_utilization_hourlyoci_nosql_table_metric_write_throttle_countoci_nosql_table_metric_write_throttle_count_dailyoci_nosql_table_metric_write_throttle_count_hourlyoci_objectstorage_bucketoci_ons_notification_topicoci_ons_subscriptionoci_region

Table: oci_file_storage_file_system

Oracle Cloud Infrastructure File Storage service provides a durable, scalable, secure, enterprise-grade network file system. You can connect to a File Storage service file system from any bare metal, virtual machine, or container instance in your Virtual Cloud Network (VCN).

Examples

Basic info

select
display_name,
id,
lifecycle_state as state,
availability_domain,
metered_bytes,
time_created
from
oci_file_storage_file_system;

List file systems that are not active

select
display_name,
id,
lifecycle_state as state
from
oci_file_storage_file_system
where
lifecycle_state <> 'ACTIVE';

List cloned file systems

select
display_name,
id,
lifecycle_state as state
from
oci_file_storage_file_system
where
is_clone_parent;

List file systems with Oracle managed encryption (default encryption uses Oracle managed encryption keys)

select
display_name,
id,
lifecycle_state as state,
time_created
from
oci_file_storage_file_system
where
length(kms_key_id) = 0;

List file systems with customer managed encryption keys

select
display_name,
id,
lifecycle_state as state,
kms_key_id,
time_created
from
oci_file_storage_file_system
where
length(kms_key_id) <> 0;

.inspect oci_file_storage_file_system

OCI File Storage File System

NameTypeDescription
availability_domaintextThe availability domain the file system is in.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
defined_tagsjsonbDefined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
display_nametextA user-friendly name. It does not have to be unique, and it is changeable.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the file system.
is_clone_parentbooleanSpecifies whether the file system has been cloned.
is_hydratedbooleanSpecifies whether the data has finished copying from the source to the clone.
kms_key_idtextThe OCID of the KMS key used to encrypt the encryption keys associated with this file system.
lifecycle_detailstextAdditional information about the current 'lifecycleState'.
lifecycle_statetextThe current state of the file system.
metered_bytesbigintThe number of bytes consumed by the file system.
regiontextThe OCI region in which the resource is located.
source_detailsjsonbSource information for the file system.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneThe date and time the file system was created.
titletextTitle of the resource.