User Tools

Site Tools


reference:find_forwards_assistants_etc
no way to compare when less than two revisions

Differences

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


Previous revision
reference:find_forwards_assistants_etc [2018/11/14 10:45] (current) – external edit 127.0.0.1
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 by 127.0.0.1