CD2: Microsoft Sync State (for MS Teams)

[IanGoh]

We are trying to find out who is actively using the MS Teams/O365 integrations.  I can find out which courses have the "Teams Assignments" in the Course Navigation.  Unfortunately, it was added by default to alot of courses.

So we're only trying to find those that have the Integrations > Microsoft Sync State enabled at the course-level

Is that even possible within Canvas Data 2? 

Thanks

Ian

[stimme]

@IanGoh You might be able to get relevant data from canvas_logs.web_logs. The first step is finding the id for the Teams sync integration in canvas.context_external_tools. The second step is to

SELECT * 
FROM canvas_logs.web_logs 
WHERE url LIKE '%external\_tools/[teams_sync_external_tool_id]%' 
OR url LIKE '%/external\_tools/sessionless\_launch%id=[teams_sync_external_tool_id]&%';

[IanGoh]

Thanks - is there a specific external tool for the sync? AFAIK we have separate tools for Teams Assignments, One Drive and  Teams Classes?

Seemed to work for MS Teams Classes, but we were getting nothing for MS Teams Assignments.  Least with the limited data set we have.

[IanGoh]

Also, a lot fewer "sessionless_launch" vs "external_tools/id"

[IanGoh]

And just to confirm, all this means is someone clicked on the link.  It doesn't indicate whether a sync was enabled or not.

[stimme]

@IanGoh My institution has tested but not implemented these Teams integrations, and I'm not sure what to make of the very sparse web_logs that we have related to these tools. My guess would be, as you said, "all this means is someone clicked on the link." Maybe there's some clue in the text of the URLs.

It's possible that there's a URL pattern in web_logs records that doesn't include the "external_tools/[id]" pattern, but I have not tried to identify it for Teams integrations. (I do know that a lot of the old Office 365 tool's web_logs URLs are LIKE '%url=https%office365-iad-prod.instructure.com%' and don't contain the external tool ID.)