Can i get a list of unconfirmed email addresses in Canvas?

[valerie_weagle]

We have run into an issue where newly enrolled students have not been receiving the email from Instructure to confirm their email address. They do get the email when we manually re-send it but that is not a sustainable workflow to do for every new student.  Is there a way I can get a list of all users with unconfirmed email addresses in my system?

The issue has become that they are now not receiving announcement notifications or other Canvas-generated communications which has negatively affected participation in a number of our recent course offerings.

We believe the root issue is in our SSO set-up and are actively attempting to fix this for new accounts, but need a way to know who it affected in the past.

[dbrace · Accepted solution]

Hi @valerie_weagle,

If there is a way to do it, it could probably involve using Canvas Data 2 (DAP). You can refer to https://developerdocs.instructure.com/services/dap as a starting point for help generating a report.

I would proceed with a mix of tools/reports/steps, such as:

1. How do I view bounced email notifications for users in an account? - Instructure Community - 434165 to see if any are institution email addresses are not working
2. If you think it is a SPAM issue, you (if necessary, work with your IT Department) should be able to look at logs for your email provider to find out what emails from instructure.com (I believe the specific email address is notifications@instructure.com) are being blocked.
3. How do I view reports for an account? - Instructure Community - 109
   
   1. as an opportunity to see what all email addresses are
   2. use "Provisioning" and download Users CSV for the applicable term(s) and (sub)account(s)
4. from your systems that contain user account information before Canvas, export a list of email addresses that are correct and compare them (making sure that they are in the same order, probably by their ID number) to the provisioning report(s)
5. change any email addresses that are not correct
6. create and upload a users.csv
   1. How do I format CSV text files for uploading SIS data into a Canvas account? - Instructure Community...
   2. SIS Import Format Documentation - Canvas LMS REST API Documentation
   3. at my institution (I believe) our users.csv file contains the bare minimum for Canvas user account creation
      1. user_id = this is their institution ID number
      2. login_id = what they use to log into our SSO/IdP
      3. first_name = their first name
      4. last_name = their last name
      5. email = their institution provided email address
      6. status = we only ever use "active"
   4. How do I import SIS data to a Canvas account? - Instructure Community - 98
7. consider...
   1. altering your Canvas user account creation process to not require confirming an email address that is provided by an institution (https://canvas.instructure.com/doc/api/users.html)
   2. if not already done, disabling (not selecting) the "Users can delete their institution-assigned email address" option ( How do I set details for an account? - Instructure Community - 194 )

I hope all of this helps.

-Doug