User Tools

Site Tools


reference:view_autoresponder_condition_enable_history

Database query to view autoresponder condition enable history

At a command prompt in the VPOP3 directory run

psql

(The password is 'vpop3pass')

Then, type

SELECT * FROM users.users;

Take note of the 'usernumber' for the relevant user

SELECT * FROM users.autoresponderconditions WHERE usernumber=<usernumber FROM above>;

Take note of the 'condid' for the relevant autoresponder condition

SELECT (xpath('/ss_new/ruleenabled/text()', newrow))[1] AS enabled, 
(regexp_match(updateuser, ' \((.*?)\)'))[1] AS updateuser,updatetime 
FROM settingaudit WHERE tablename='users.autoresponderconditions' 
AND keyfield='<condid from above>' ORDER BY id DESC LIMIT 100;

N.B. VPOP3 does not need to be stopped while you do this

reference/view_autoresponder_condition_enable_history.txt · Last modified: by paul