SELECT sent_date,sent_status,subject,body,* FROM msdb.dbo.sysmail_allitems
select * from msdb.dbo.sysmail_unsentitems
select * from msdb.dbo.sysmail_allitems
select * from msdb.dbo.sysmail_mailitems
select * from msdb.dbo.sysmail_event_log
select @@SERVERNAME