cannot query msdb.dbo.sysmail_faileditems

[mnbob70]

Blazor static SSR page trying to display a count of failed dbmail items. The following code works when running with my windows identify from Visual Studio because I have full Sql Admin privileges. On our production web server using an identity that has been granted DatabaseMailUserRole and db_datareader, the following query always returns 0 for the count. I tried granting db_owner privileges but that still didn't work.

	public void GetAutoReportMonitorCount2()
	{
		var sql = @"SELECT	COUNT(*)
				FROM	FilingData.dbo.tbl_WebReportRequests r
				JOIN	msdb.dbo.sysmail_faileditems fi on fi.mailitem_id = r.mailitem_id
				AND	r.ExcludeFromReportMonitor = 0";
		using SqlConnection con = new SqlConnection(_logsContext.Database.GetConnectionString());
		con.Open();
		using SqlCommand cmd = new SqlCommand(sql, con);
		count2 = (int)cmd.ExecuteScalar();
	}

[mnbob70]

Did not realize that sysadmin is required to access msdb sysmail tables.