Viewing messages, logs, and attachments - Amazon Relational Database Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Viewing messages, logs, and attachments

You use RDS stored procedures to view messages, event logs, and attachments.

To view all email messages

  • Use the following SQL query.

    SELECT * FROM msdb.dbo.rds_fn_sysmail_allitems(); --WHERE sent_status='sent' or 'failed' or 'unsent'
To view all email event logs

  • Use the following SQL query.

    SELECT * FROM msdb.dbo.rds_fn_sysmail_event_log();
To view all email attachments

  • Use the following SQL query.

    SELECT * FROM msdb.dbo.rds_fn_sysmail_mailattachments();