By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

How can I send an E-Mail listing all the RDS Instances that need to be updated?

0

Hello, I have the following question, is it possible to use Amazon EventBridge Scheduler to weekly send a message to an SNS Topic stating the RDS Instances that have pending maintenances to do?

So I know that it is possible to do it with a Lambda function and so on, but my question would be if there is a way to avoid that extra step? If it is possible of course.

What I was also testing around was to do putEvents on an Event Bus and then using the Eventbridge Rule to send the notification... writing this right now wouldn't make much sense because you can't really specify the resources that might have a maintenance pending right?

TLDR; I would like to know how you would send an E-mail listing all the RDS Instances that need to be updated for the week, if there are any. (If possible without Lambda, if not it's okay with a Lambda)

Topics
ServerlessComputeApplication IntegrationManagement & GovernanceMicroservices
Tags
AWS LambdaAmazon EventBridgeAmazon CloudWatchAmazon Simple Notification Service (SNS)Microservices
Language
English
Andre Pereira
asked a month ago435 views
1 Answer
1
Accepted Answer

You can monitor for health events on event bridge to email you when a event is raised that there is Mainteance Scheduled for an RDS instance.

https://docs.aws.amazon.com/health/latest/ug/aws-health-concepts-and-terms.html#event-type-categories

RDS-EVENT-0155 which is "The DB instance has a DB engine minor version upgrade available" https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html

Send event to SNS Topic. No Lambda needed

There is an KB article in Repost https://repost.aws/knowledge-center/notification-maintenance-rds-redshift

profile picture
EXPERT
Gary Mclean
answered a month ago
profile picture
EXPERT
Giovanni Lauria
reviewed a month ago
  • Andre Pereira
    a month ago

    Yes I have managed to have an eventbridge rule that triggers based on events, and it works, but my use case would be to have that "event" weekly check... If that makes sense, so instead of waiting for that event I would need to have that "event" manually generated each week but that is not the goal, the goal is for every week on monday for example to have an SNS Topic listing if there are RDS Instances to be updated if there are list the needed system-update, db-upgrade, hardware-maintenance or ca-certificate-rotation.

    I have successfully created a lambda function for it but I would just like to know if there is an alternative for it.

    Thank you for the resources tho they are helpful for sure. But not fully tailored for my use case.

  • Gary Mclean EXPERT
    a month ago

    Hey Andre, I think the only way then would be the lambda function to enumerate your RDS instances and report via Email. Not sure if a Step Function could perform a similar action

  • Andre Pereira
    a month ago

    Hey Gary, I see very well I thank you for your time and answers, I guess I leave the Eventbridge Scheduler triggering the lambda Function and sending the "report" via SNS to the designated people. :) wish you a great day.

  • Gary Mclean EXPERT
    a month ago

    Hey Andre, if you’re happy with the answer. I’d appreciate it if you could accept the answer. Have a good day. Gary.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content