User Emails (or Student IDs ) CD2

[ZaidGandhi]

Hi, 

Does anyone know a way to find student IDs or user emails from CD2?

I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have the primary key of userID and accountID and only their full name. 

Is there some other place that I should be looking?

Thanks

Z