AnsweredAssumed Answered

Which teacher hasn’t logged into Canvas?

Question asked by Dona Gibbons on Apr 10, 2018
Latest reply on Apr 19, 2018 by

The question that I am being asked to find:


Which faculty member hasn’t logged into Canvas, yet, for a specific term, whose course is online only?


I have a query that checks the "current_login_at" to see when the last login into Canvas.  However, I discovered one faculty member the date is not valid because the date is the last time the faculty member appears when they used a Desktop Web Browser.  The GUI Page View shows the faculty member has been using Mobile Canvas App ever since.  


What field and table is User's Profile Current Login stored?  Since it appears the pseudonym_dim.current_login_at is not connected to Mobile Canvas App login.