Report of Canvas native login users?

[LindaWilin1]

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

[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

[LindaWilin1]

Thank you Colin!