aws rds cli -- need to search the db-parameter-group(s) for a specific parameter

Question

Hello all. I am successful at querying "aws --no-verify-ssl rds  describe-db-parameter-groups". But, I'm trying to filter down in order to view one parameter (audit_trail). Secondly, I need to modify the parameter value to a new string. All I'm finding in the documentation, however, looks like "-> (file)". IOW search the parameter groups for the string "oracle", then the parameters for the string "audit_trail", then the parameterVaule for the string "os". Your guidance is appreciated.

Accepted Answer

Hello,

Thanks for posting to AWS re:Post.
Viewing of these parameters can be done by describe-db-parameters
https://docs.aws.amazon.com/cli/latest/reference/rds/describe-db-parameters.html

Example
aws rds describe-db-parameters --db-parameter-group-name xxxx --query 'Parameters[].{ParameterName: ParameterName, ParameterValue: ParameterValue}' --output json
https://docs.aws.amazon.com/cli/latest/userguide/cli-usage-filter.html

You can also output to a file ">filename.txt" at the end

Modify by aws rds modify-db-parameter-group --db-parameter-group-name xxxx --parameters "ParameterName='xxxx',ParameterValue=xxxx,ApplyMethod=immediate"
https://docs.aws.amazon.com/cli/latest/reference/rds/modify-db-parameter-group.html

aws rds cli -- need to search the db-parameter-group(s) for a specific parameter

관련 콘텐츠