AWS RDS VPC ID Through Powershell

Question

How to get AWS RDS VPC ID through Powershell.

Answer 1

Hi, @Vinothkumar R

AWS CLI using Powershell

You can also use the AWS CLI with PowerShell.

   % pwsh  
   PowerShell 7.2.6  
   Copyright (c) Microsoft Corporation.  
     
   https://aka.ms/powershell  
   Type 'help' to get help.  
     
   PS /Users/iwasa.takahito> aws rds describe-db-instances --db-instance-identifier hoge-db  
   {  
       "DBInstances": [  
           {  
               "DBInstanceIdentifier": "hoge-db",  
               "DBInstanceClass": "db.t3.small",  
               "Engine": "aurora-mysql",  
   :  
               "DBSubnetGroup": {  
                   "DBSubnetGroupName": "default",  
                   "DBSubnetGroupDescription": "default",  
                   "VpcId": "vpc-3b4cab5d",  
                   "SubnetGroupStatus": "Complete",  
   :  

AWS Toolkit for Powershell

Use the Select parameter to access DBInstances.DBSubnetGroup.

According to Get-RDSDBInstance , Select defaults to DBInstances.

https://docs.aws.amazon.com/powershell/latest/reference/items/Get-RDSDBInstance.html

   PS /Users/iwasa.takahito> Get-RDSDBInstance -DBInstanceIdentifier hoge-db -Select 'DBInstances.DBSubnetGroup'     
     
   DBSubnetGroupArn         :   
   DBSubnetGroupDescription : default  
   DBSubnetGroupName        : default  
   SubnetGroupStatus        : Complete  
   Subnets                  : {Amazon.RDS.Model.Subnet, Amazon.RDS.Model.Subnet, Amazon.RDS.Model.Subnet}  
   SupportedNetworkTypes    : {}  
   VpcId                    : vpc-3b4cab5d