Microsoft Teams Notifications Reporting

[Mireia Sanchez]

Hi,

Could you please let me know which is the table to report on notifications sent to Teams and if we can report on Notification Type, Content, Date and receiver (user)?

Thanks in advance!

[Community Alums]

Hello @Mireia Sanchez 

You can created report on "sys_email" table. You will find all required column for the information. 

Add filter as per your requirement. 

For example, Type is sent AND Created on This month. 

Let me know if you need more information. 

[Mireia Sanchez]

Thanks for your reply Akshay, I think though that this will report only on the notifications sent via e-mail, I was looking for the reporting on the notifications that be pushed to Microsoft Teams, which as Sebastien said seem to be located in the table sys_notification_execution

[Sebastian L]

You can find the notifications sent in the "Notification Logs": "sys_notification_execution". At least that is where I've found the teams messages that was sent from my system. There might be another way to track it, but I've not been able to locate it yet. 

[Mireia Sanchez]

Thanks Sebastian!

Could you share a screenshot on the columns that are available via that table? You can hide any confidential data/details that might appear in the report. 

I want to know the details that we can report on (date notification was sent, the receiver/username of the notification, the notification type/notification title, and if the notification content is also something visible via reporting).

Thanks again!