I have a PostGRE SQL external database which is collecting all IM&P messages for compliance purposes. It works great and I can use my rudimentary SQL skills to execute commands and extract message data from the public.jm table:
SELECT * FROM public.jm WHERE ( sent_date > '2018-04-03' AND sent_date < '2018-04-07' ) AND ( from_jid LIKE '%jbloggs%' AND to_jid LIKE '%jdoe%' )
This is very time consuming and I'm sure someone has written some software to automate this. Can anyone recommend a tool to parse/extract messages based on time and date criteria, and between specific users?
There must be something out there written to do this, surely?
Thanks,
Joe