SELV Production User Accounts

This list of user accounts is as of 5th June 2014, and is based on the field coordinator inventory user list provided by Moz office. This set of users and permissions has been backed-up, and can be restored at any point.

For the actual SELV deployment, additional accounts for VillageReach staff will need to be added manually.

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