SELV Production User Accounts

This list of user accounts is as of 4/25/15, and is based on the field coordinator inventory user list provided by Timoteo (attached). 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.

User Name	Password	First Name	Last Name	Email	Permissions
admin	Xa4312j8$	backdoor	account	info@villagereach.org	Admin
jzamor	ignored	Field	Coordinator	josh.zamor@villagereach.org	Admin, All Provinces
sjackson	ignored	Sarah	Jackson	sarah.jackson@villagereach.org	Admin, All Provinces
tmutenga	ignored	Tatenda	Mutenga	tatenda.mutenga@villagereach.org	Admin, All Provinces
vsampath	ignored	Vidya	Sampath	vidya.sampath@villagereach.org	Admin, All Provinces
jmausse	ignored	Jaime	Mausse	fc1@villagereach.org	Maputo
cmandlate	ignored	CecÃlia	Mandlate	fc2@villagereach.org	Maputo
ecastigo	ignored	Engracia	Castigo	fc3@villagereach.org	Gaza
csoares	ignored	Carmen	Soares	fc4@villagereach.org	Gaza
jandre	ignored	JoÃ£o	AndrÃ©	fc5@villagereach.org	Cabo Delgado
ahanifo	ignored	Abdul	Hanifo	fc6@villagereach.org	Cabo Delgado
afaque	ignored	Abdul	Faque	fc7@villagereach.org	Cabo Delgado
alimite	ignored	Agostinho	Limite	fc8@villagereach.org	Niassa
nmote	ignored	Nelson	Mote	fc9@villagereach.org	Niassa
fcassimo	ignored	Focas	Cassimo	fc10@villagereach.org	Niassa

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