search

aws / aws-tools-for-powershell

The AWS Tools for PowerShell lets developers and administrators manage their AWS services from the PowerShell scripting environment.
Apache License 2.0
235 stars 78 forks source link

Get-RDSDBInstance and Get-RDSDBCluster should allow you to find resources by their resource IDs (cluster-xxxx.../db-xxxx...) #171

Closed WToorenburghIntiveo closed 3 years ago

WToorenburghIntiveo commented 3 years ago

Describe the Feature

I feel like the Get-RDSDBInstance and Get-RDSDBCluster commandlets should allow you to retrieve instances/clusters using their unique resource IDs.

Proposed Solution

Either supporting a -ResourceID parameter, or supporting Resource IDs in the -Filter parameter would be very helpful.

Additional Context

The RDS Get commandlets for DB instances and clusters only support Instance IDs via the -DBClusterIdentifier/-DBInstanceIdentifier parameters, or Instance IDs and ARNs via the -Filter parameter. This is frustrating to me, as I'm working on a script to help my team connect to RDS instances using IAM. The IAM policies for granting access to DBs only use the cluster-/db- unique IDs, and there are no other identifiers available from that information I can use to identify which actual DBs/Clusters a given user has permissions for.

Describe alternatives you've considered

The only other ways I can think of accomplishing this task is by either putting in some extra text in the IAM policies with the names of the DBs, or with some complex tagging scheme.

Environment

This is working with the AWS.Tools modules on Powershell 7.0.1 on Windows 10, version 1909

This is a :rocket: Feature Request

ashishdhingra commented 3 years ago

Hi @WToorenburghIntiveo,

Good morning.

The CmdLets Get-RDSDBInstance and Get-RDSDBCluster are autogenerated from the service model, and map to DescribeDBInstances and DescribeDBClusters service API operations. The service API operation DescribeDBInstances appear to support dbi-resource-id in Filter parameter. Whereas, service API operation DescribeDBClusters only supports db-cluster-id. The filtering support at the API level is controlled by the service. Kindly check if resource ID filter works for Get-RDSDBInstance CmdLet as supported by service.

Based on above details, this doesn't appear to be a feature request. Please let me know if this helps.

Thanks, Ashish

github-actions[bot] commented 3 years ago

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see. If you need more assistance, please either tag a team member or open a new issue that references this one. If you wish to keep having a conversation with other community members under this issue feel free to do so.