User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

reference:find_forwards_assistants_etc [2018/11/14 10:45] (current)
Line 1: Line 1:
 +======Database query to find forwards/​assistants etc in user settings======
 +Go to Settings -> Database -> Query
 +Alternatively,​ at a command prompt in the VPOP3 directory run
 +  psql
 +(The password is '​vpop3pass'​)
 +Then, type
 +  select username,​dataname,​datavalue from users.usersettings inner join 
 +  users.users using(usernumber) where datavalue ilike '​%searchname%';​
 +  ​
 +(replace '​searchname'​ with the name you want to search for)
 +N.B. VPOP3 does not need to be stopped while you do this
reference/find_forwards_assistants_etc.txt ยท Last modified: 2018/11/14 10:45 (external edit)