Reporting on Microsoft Teams chat details

[zerofidelis]

Hello All!

We recently integrated ServiceNow with Microsoft Teams and I'm having some issues with one of the requests that came to me.  The user wants to be able to, in a single view, see both the work notes associated with the Incident ticket, as well as the Teams Chat details stored in sn_tcm_collab_hook_ms_teams.  

I've tried creating Database Views for this, but when I join the 2 tables, even if I can get the condition to display the correct results, much of the information will not display (Ticket Number is empty, Transcripts are empty, etc...).  I also tried creating a relationship between the two to try and populate a related list hoping I could report off it, but even when I verified all of the sys_ids and source tables were correct, and the logs were returning the right entries, the related list was still showing everything instead of scoping down to just the entries associated with that incident.  Even if I was to get the relationship working, I'm not 100% sure it would help me since the report_view permissions for the Teams table seem to be locked to maint anyway.  

That all said, I'm not really sure how to proceed here.  I could probably use an existing Flow we created to copy the Transcript into the work notes of the INC ticket everytime it updates, but that seems horrible, so I came here hoping someone could offer a better suggestion.  Feel free to ask any questions necessary and I will try to respond as quickly as I can with specific details.

Thanks in advance!