Viewing messages, logs, and attachments - Amazon Relational Database Service

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();