Report of Canvas native login users?

I appreciate your assistance. Is there a way to get or script a report that lists which users are configured for Canvas native login (instead of institutions SSO)?

I did a little digging and found which table and field hold the encrypted password, but understandably Instructure hides that field.

Thank you so much for your helpful thoughts!!

Linda

Find more posts tagged with

Accepted answers

All comments

ColinMurtaugh

You could pull a User Provisioning Report (Account Admin > Settings > Reports > Provisioning) and use the authentication_provider_id column to determine whether the login is associated with your SSO provider or is a Canvas native login. Canvas native logins will have an authentication_provider_id of null (or sometimes 1).

-Colin

Unanswered Questions

Concluded Course and Canvas Data Services
Canvas Data Services sent out an alert that a course was concluded (because the course was concluded) and the status of each user in the UI is set to complete, however, the enrollments API endpoint shows the status of each user in the course as active. Is this a common issue? Have I misinterpreted how the individual…
Canvas Media Question
How can one track Canvas Media use without having the reports available from Canvas Studio? Checking API endpoints and the Data 2 schema, there do not seem to be dedicated Canvas Media endpoints. Am I missing some? A method I've considered is using the body field of the wiki_pages table, as this contains the html code of…
Canvas Catalog API - Completed Certificates
Hello, I'm trying to utilize an API call to pull completed certificates and was hoping to download and store the certs as a backup. I can successfully run the API call but it will not allow me to view the certificate unless I access the URL while signed into an account where it's "my" cert. Is there a permissions setting…
UI for weekly progression idea
UI for weekly progression idea that rest in the Schedule tab of the **K-12 UI** of Canvas it's incomplete and I really would not take it and push it into instance but I am going to post it here because in the past people like @James && @robotcars || @Steve_25 have had terrific input in the past... maybe w/their eyes and…
Canvas integration with React + Flask webapp - initially for authenticaiton
I have a new React + Flask webapp. It has its own login for users to start using the app. I have added this as an external tool in Canvas. What I want initially is to see of canvas users can start using the webapp without having to login if they click on the external tool link in a canvas course. I have 2 methods…