No lines in MSDB.dbo.sysmail_faileditems

Question

Initially, I was getting a "no SELECT privileges" error when trying to request content for the report that I need to create. Therefore, we provided DatabaseMailUserRoleMSDB for my account - I see columns, but not one of the data that we know does not exist.

What am I missing, what do I need to do for my account to see the data?

Answer 1

select OBJECT_DEFINITION(OBJECT_id('sysmail_faileditems')) 
AS [processing-instruction(x)] FOR XML PATH('')

Shows sysmail_faileditemsdefinition

SELECT * FROM msdb.dbo.sysmail_allitems WHERE sent_status = 'failed'

Looking at sysmail_allitems. This definition

SELECT ...
FROM msdb.dbo.sysmail_mailitems
WHERE (send_request_user = SUSER_SNAME()) 
      OR (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1)

, , sysadmin, , .

Answer 2

. . database.dbo.mytable database.klowrey.mytable.

. , .