The Course Lists with Guardian Email Addresses Query will give you the Email Addresses for Guardians of students in a specified Course.
When Executing the query, you can select the School Year, Course Title (School ID# only,no section), School, and the Guardian settings for Lives with Student and Receives Mail (default value is Yes for both).
The resulting report will include all sections for the Course ID with a count of students for each section. The student will be listed multiple times if they have more than one Guardian with an email address on record in iPass.
Example: (names substituted for security purposes)
| Course ID | Name | Course Sec | ID | GL | Last Name | First Name | Last Name | First Name | Email Address |
| E1011 | English 1 | 01 | 98475 | 09 | Student Last 1 | Student First 1 | Father Last 1 | Father First 1 | father@gmail.com |
| E1011 | English 1 | 01 | 98475 | 09 | Student Last 1 | Student First 1 | Mother Last 1 | Mother First 1 | mother@gmail.com |
| E1011 | English 1 | 01 | 98468 | 09 | Student Last 2 | Student First 2 | Mother Last 2 | Mother First 2 | mother@yahoo.com |
| E1011 | English 1 | 01 | 98838 | 09 | Student Last 3 | Student First 3 | Mother Last 3 | Mother First 3 | mother@yahoo.com |
| E1011 | English 1 | 01 | 70835 | 09 | Student Last 4 | Student First 4 | Mother Last 4 | Mother First 4 | mother@charter.net |
| E1011 | English 1 | 01 | 13135 | 09 | Student Last 5 | Student First 5 | Father Last 5 | Father First 5 | father@gmail.com |
| E1011 | English 1 | 01 | 15093 | 09 | Student Last 6 | Student First 6 | Father Last 6 | Father First 6 | |
| E1011 | English 1 | 01 | 15093 | 09 | Student Last 6 | Student First 6 | Mother Last 6 | Mother First 6 | mother@qmail.qcc.edu |
| E1011 | English 1 | 01 | 13513 | 09 | Student Last 7 | Student First 7 | Mother Last 7 | Mother First 7 | |
| E1011 | English 1 | 01 | 70809 | 09 | Student Last 8 | Student First 8 | Mother Last 8 | Mother First 8 | mother@msn.com |
| Count | 10 | ||||||||
| E1011 | English 1 | 02 | 15103 | 09 | Student Last 1 | Student First 1 | Mother Last 1 | Mother First 1 | mother@yahoo.com |
** Directions on how to download a query from iPass Help and import into your iPass account can be found in iPass Help > My Queries > Help > How do I import a query file into my iPass database?