Database Mail Catalog views display metadata about the status of e-mail messages processed by Database Mail.
USE MSDB
select * from sysmail_allitems
Contains a row for each attachment submitted to Database Mail.
USE MSDB
select * from sysmail_mailattachments
Contains returned message details for Windows or SQL Server
USE MSDB
select * from sysmail_event_log
Contains a row for each message sent successfully
USE MSDB
select * from sysmail_sentitems
Contains one row for each failed message
USE MSDB
select * from sysmail_faileditems
Contains row for Messages with unsent or retrying status which are still in the mail queue
USE MSDB
select * from sysmail_unsentitems