Skip to content
AWS for Query.Farm

aws.datasync.describe_storage_system_resources

Example SQL Queries

SELECT * FROM
aws.datasync.describe_storage_system_resources
WHERE
"discovery_job_arn" = 'VALUE'
AND "resource_type" = 'VALUE';

Description

Returns information that DataSync Discovery collects about resources in your on-premises storage system.

Table Definition

Column NameColumn Data Type
discovery_job_arn Required Input Column

Specifies the Amazon Resource Name (ARN) of the discovery job that's collecting data from your on-premises storage system.

VARCHAR
resource_type Required Input Column

Specifies what kind of storage system resources that you want information about.

VARCHAR
filter Input Column

Filters the storage system resources that you want returned. For example, this might be volumes associated with a specific storage virtual machine (SVM).

MAP(VARCHAR, VARCHAR[])
max_results Input Column

Specifies the maximum number of storage system resources that you want to list in a response.

BIGINT
next_token Input Column

The opaque string that indicates the position to begin the next list of results in the response.

VARCHAR
resource_ids Input Column

Specifies the universally unique identifiers (UUIDs) of the storage system resources that you want information about. You can't use this parameter in combination with the Filter parameter.

VARCHAR[]
Show child fields
resource_ids[]
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
resource_details

The information collected about your storage system's resources. A response can also include Amazon Web Services storage service recommendations.

For more information, see storage resource information collected by and recommendations provided by DataSync Discovery.

STRUCT(
    "net_app_ontapsv_ms" STRUCT(
        "cluster_uuid" VARCHAR,
        "resource_id" VARCHAR,
        "svm_name" VARCHAR,
        "cifs_share_count" BIGINT,
        "enabled_protocols" VARCHAR[],
        "total_capacity_used" BIGINT,
        "total_capacity_provisioned" BIGINT,
        "total_logical_capacity_used" BIGINT,
        "max_p95_performance" STRUCT(
            "iops_read" DOUBLE,
            "iops_write" DOUBLE,
            "iops_other" DOUBLE,
            "iops_total" DOUBLE,
            "throughput_read" DOUBLE,
            "throughput_write" DOUBLE,
            "throughput_other" DOUBLE,
            "throughput_total" DOUBLE,
            "latency_read" DOUBLE,
            "latency_write" DOUBLE,
            "latency_other" DOUBLE
        ),
        "recommendations" STRUCT(
            "storage_type" VARCHAR,
            "storage_configuration" MAP(VARCHAR, VARCHAR),
            "estimated_monthly_storage_cost" VARCHAR
        )[],
        "nfs_exported_volumes" BIGINT,
        "recommendation_status" VARCHAR,
        "total_snapshot_capacity_used" BIGINT,
        "lun_count" BIGINT
    )[],
    "net_app_ontap_volumes" STRUCT(
        "volume_name" VARCHAR,
        "resource_id" VARCHAR,
        "cifs_share_count" BIGINT,
        "security_style" VARCHAR,
        "svm_uuid" VARCHAR,
        "svm_name" VARCHAR,
        "capacity_used" BIGINT,
        "capacity_provisioned" BIGINT,
        "logical_capacity_used" BIGINT,
        "nfs_exported" BOOLEAN,
        "snapshot_capacity_used" BIGINT,
        "max_p95_performance" STRUCT(
            "iops_read" DOUBLE,
            "iops_write" DOUBLE,
            "iops_other" DOUBLE,
            "iops_total" DOUBLE,
            "throughput_read" DOUBLE,
            "throughput_write" DOUBLE,
            "throughput_other" DOUBLE,
            "throughput_total" DOUBLE,
            "latency_read" DOUBLE,
            "latency_write" DOUBLE,
            "latency_other" DOUBLE
        ),
        "recommendations" STRUCT(
            "storage_type" VARCHAR,
            "storage_configuration" MAP(VARCHAR, VARCHAR),
            "estimated_monthly_storage_cost" VARCHAR
        )[],
        "recommendation_status" VARCHAR,
        "lun_count" BIGINT
    )[],
    "net_app_ontap_clusters" STRUCT(
        "cifs_share_count" BIGINT,
        "nfs_exported_volumes" BIGINT,
        "resource_id" VARCHAR,
        "cluster_name" VARCHAR,
        "max_p95_performance" STRUCT(
            "iops_read" DOUBLE,
            "iops_write" DOUBLE,
            "iops_other" DOUBLE,
            "iops_total" DOUBLE,
            "throughput_read" DOUBLE,
            "throughput_write" DOUBLE,
            "throughput_other" DOUBLE,
            "throughput_total" DOUBLE,
            "latency_read" DOUBLE,
            "latency_write" DOUBLE,
            "latency_other" DOUBLE
        ),
        "cluster_block_storage_size" BIGINT,
        "cluster_block_storage_used" BIGINT,
        "cluster_block_storage_logical_used" BIGINT,
        "recommendations" STRUCT(
            "storage_type" VARCHAR,
            "storage_configuration" MAP(VARCHAR, VARCHAR),
            "estimated_monthly_storage_cost" VARCHAR
        )[],
        "recommendation_status" VARCHAR,
        "lun_count" BIGINT,
        "cluster_cloud_storage_used" BIGINT
    )[]
)
Show child fields
resource_details.net_app_ontap_clusters[]
Show child fields
resource_details.net_app_ontap_clusters[].cifs_share_count

The number of CIFS shares in the cluster.

resource_details.net_app_ontap_clusters[].cluster_block_storage_logical_used

The storage space that's being used in the cluster without accounting for compression or deduplication.

resource_details.net_app_ontap_clusters[].cluster_block_storage_size

The total storage space that's available in the cluster.

resource_details.net_app_ontap_clusters[].cluster_block_storage_used

The storage space that's being used in a cluster.

resource_details.net_app_ontap_clusters[].cluster_cloud_storage_used

The amount of space in the cluster that's in cloud storage (for example, if you're using data tiering).

resource_details.net_app_ontap_clusters[].cluster_name

The name of the cluster.

resource_details.net_app_ontap_clusters[].lun_count

The number of LUNs (logical unit numbers) in the cluster.

resource_details.net_app_ontap_clusters[].max_p95_performance

The performance data that DataSync Discovery collects about the cluster.

Show child fields
resource_details.net_app_ontap_clusters[].max_p95_performance.iops_other

Peak IOPS unrelated to read and write operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.iops_read

Peak IOPS related to read operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.iops_total

Peak total IOPS on your on-premises storage system resource.

resource_details.net_app_ontap_clusters[].max_p95_performance.iops_write

Peak IOPS related to write operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.latency_other

Peak latency for operations unrelated to read and write operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.latency_read

Peak latency for read operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.latency_write

Peak latency for write operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.throughput_other

Peak throughput unrelated to read and write operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.throughput_read

Peak throughput related to read operations.

resource_details.net_app_ontap_clusters[].max_p95_performance.throughput_total

Peak total throughput on your on-premises storage system resource.

resource_details.net_app_ontap_clusters[].max_p95_performance.throughput_write

Peak throughput related to write operations.

resource_details.net_app_ontap_clusters[].nfs_exported_volumes

The number of NFS volumes in the cluster.

resource_details.net_app_ontap_clusters[].recommendation_status

Indicates whether DataSync Discovery recommendations for the cluster are ready to view, incomplete, or can't be determined.

For more information, see Recommendation statuses.

resource_details.net_app_ontap_clusters[].recommendations[]
Show child fields
resource_details.net_app_ontap_clusters[].recommendations[].estimated_monthly_storage_cost

The estimated monthly cost of the recommended Amazon Web Services storage service.

resource_details.net_app_ontap_clusters[].recommendations[].storage_configuration

Information about how you can set up a recommended Amazon Web Services storage service.

resource_details.net_app_ontap_clusters[].recommendations[].storage_type

A recommended Amazon Web Services storage service that you can migrate data to based on information that DataSync Discovery collects about your on-premises storage system.

resource_details.net_app_ontap_clusters[].resource_id

The universally unique identifier (UUID) of the cluster.

resource_details.net_app_ontap_volumes[]
Show child fields
resource_details.net_app_ontap_volumes[].capacity_provisioned

The total storage space that's available in the volume.

resource_details.net_app_ontap_volumes[].capacity_used

The storage space that's being used in the volume.

resource_details.net_app_ontap_volumes[].cifs_share_count

The number of CIFS shares in the volume.

resource_details.net_app_ontap_volumes[].logical_capacity_used

The storage space that's being used in the volume without accounting for compression or deduplication.

resource_details.net_app_ontap_volumes[].lun_count

The number of LUNs (logical unit numbers) in the volume.

resource_details.net_app_ontap_volumes[].max_p95_performance

The performance data that DataSync Discovery collects about the volume.

Show child fields
resource_details.net_app_ontap_volumes[].max_p95_performance.iops_other

Peak IOPS unrelated to read and write operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.iops_read

Peak IOPS related to read operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.iops_total

Peak total IOPS on your on-premises storage system resource.

resource_details.net_app_ontap_volumes[].max_p95_performance.iops_write

Peak IOPS related to write operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.latency_other

Peak latency for operations unrelated to read and write operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.latency_read

Peak latency for read operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.latency_write

Peak latency for write operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.throughput_other

Peak throughput unrelated to read and write operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.throughput_read

Peak throughput related to read operations.

resource_details.net_app_ontap_volumes[].max_p95_performance.throughput_total

Peak total throughput on your on-premises storage system resource.

resource_details.net_app_ontap_volumes[].max_p95_performance.throughput_write

Peak throughput related to write operations.

resource_details.net_app_ontap_volumes[].nfs_exported

The number of NFS volumes in the volume.

resource_details.net_app_ontap_volumes[].recommendation_status

Indicates whether DataSync Discovery recommendations for the volume are ready to view, incomplete, or can't be determined.

For more information, see Recommendation statuses.

resource_details.net_app_ontap_volumes[].recommendations[]
Show child fields
resource_details.net_app_ontap_volumes[].recommendations[].estimated_monthly_storage_cost

The estimated monthly cost of the recommended Amazon Web Services storage service.

resource_details.net_app_ontap_volumes[].recommendations[].storage_configuration

Information about how you can set up a recommended Amazon Web Services storage service.

resource_details.net_app_ontap_volumes[].recommendations[].storage_type

A recommended Amazon Web Services storage service that you can migrate data to based on information that DataSync Discovery collects about your on-premises storage system.

resource_details.net_app_ontap_volumes[].resource_id

The universally unique identifier (UUID) of the volume.

resource_details.net_app_ontap_volumes[].security_style

The volume's security style (such as Unix or NTFS).

resource_details.net_app_ontap_volumes[].snapshot_capacity_used

The amount of storage in the volume that's being used for snapshots.

resource_details.net_app_ontap_volumes[].svm_name

The name of the SVM associated with the volume.

resource_details.net_app_ontap_volumes[].svm_uuid

The UUID of the storage virtual machine (SVM) associated with the volume.

resource_details.net_app_ontap_volumes[].volume_name

The name of the volume.

resource_details.net_app_ontapsv_ms[]
Show child fields
resource_details.net_app_ontapsv_ms[].cifs_share_count

The number of CIFS shares in the SVM.

resource_details.net_app_ontapsv_ms[].cluster_uuid

The universally unique identifier (UUID) of the cluster associated with the SVM.

resource_details.net_app_ontapsv_ms[].enabled_protocols[]
resource_details.net_app_ontapsv_ms[].lun_count

The number of LUNs (logical unit numbers) in the SVM.

resource_details.net_app_ontapsv_ms[].max_p95_performance

The performance data that DataSync Discovery collects about the SVM.

Show child fields
resource_details.net_app_ontapsv_ms[].max_p95_performance.iops_other

Peak IOPS unrelated to read and write operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.iops_read

Peak IOPS related to read operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.iops_total

Peak total IOPS on your on-premises storage system resource.

resource_details.net_app_ontapsv_ms[].max_p95_performance.iops_write

Peak IOPS related to write operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.latency_other

Peak latency for operations unrelated to read and write operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.latency_read

Peak latency for read operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.latency_write

Peak latency for write operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.throughput_other

Peak throughput unrelated to read and write operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.throughput_read

Peak throughput related to read operations.

resource_details.net_app_ontapsv_ms[].max_p95_performance.throughput_total

Peak total throughput on your on-premises storage system resource.

resource_details.net_app_ontapsv_ms[].max_p95_performance.throughput_write

Peak throughput related to write operations.

resource_details.net_app_ontapsv_ms[].nfs_exported_volumes

The number of NFS volumes in the SVM.

resource_details.net_app_ontapsv_ms[].recommendation_status

Indicates whether DataSync Discovery recommendations for the SVM are ready to view, incomplete, or can't be determined.

For more information, see Recommendation statuses.

resource_details.net_app_ontapsv_ms[].recommendations[]
Show child fields
resource_details.net_app_ontapsv_ms[].recommendations[].estimated_monthly_storage_cost

The estimated monthly cost of the recommended Amazon Web Services storage service.

resource_details.net_app_ontapsv_ms[].recommendations[].storage_configuration

Information about how you can set up a recommended Amazon Web Services storage service.

resource_details.net_app_ontapsv_ms[].recommendations[].storage_type

A recommended Amazon Web Services storage service that you can migrate data to based on information that DataSync Discovery collects about your on-premises storage system.

resource_details.net_app_ontapsv_ms[].resource_id

The UUID of the SVM.

resource_details.net_app_ontapsv_ms[].svm_name

The name of the SVM

resource_details.net_app_ontapsv_ms[].total_capacity_provisioned

The total storage space that's available in the SVM.

resource_details.net_app_ontapsv_ms[].total_capacity_used

The storage space that's being used in the SVM.

resource_details.net_app_ontapsv_ms[].total_logical_capacity_used

The storage space that's being used in the SVM without accounting for compression or deduplication.

resource_details.net_app_ontapsv_ms[].total_snapshot_capacity_used

The amount of storage in the SVM that's being used for snapshots.