User Tools

Site Tools


reference:find_forwards_assistants_etc

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