...
Moz User Accounts by Province.xlsx
SQL to check user's role assignments
select u.username
, u.email
, u.verified
, u.active
, r.name as roleName
, p.name as programName
, dz.name as deliveryZoneName
from users u
left join role_assignments ra on (ra.userid=u.id)
left join roles r on (r.id=ra.roleid)
left join programs p on (p.id=ra.programid)
left join delivery_zones dz on (dz.id=ra.deliveryzoneid)
order by username