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]&%';