Step 1 -  Check userid based on the provided email id / mobile no / foreign key in mysql db


For Email -

select id,email,confirmed,disabled,entered,modified from phplist_user_user where email="EMAILID"


For Mobile - 


select id,email,confirmed,disabled,entered,modified from phplist_user_user where mobile  = "mobileno"


Step 2 - Check in Audit log - user activity


Grep  user id  in  Audit log

Eg - 

   

careratingssmt|13054|103.120.208.161|Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36|admin|2020-12-21 16:58:47|Deleted the contact having details : {"id":"140652"}
careratingssmt|13054|103.120.208.161|Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36|admin|2020-12-21 16:58:47|Push mongo jobs to redis::{"clientid":87449,"ts":201221165847,"userid":[140652],"send_to_eaf":1}
careratingssmt|13054|103.120.208.161|Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36|admin|2020-12-21 16:58:47|In commoninit RPUSH condition Jsondata:{"clientid":87449,"ts":201221165847,"userid":[140652],"send_to_eaf":1}=====Redis key:PR1_DEL_FRM_SYS
careratingssmt|13054|103.120.208.161|Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36|admin|2020-12-21 16:58:47|MongoSync :: (aredis.netcore.co.in) push_mongo_jobs_to_redis successful.
careratingssmt|13054|103.120.208.161|Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36|admin|2020-12-21 16:58:47|Delete Operation :: Redis cache key can not be deleted



https://netcore.freshdesk.com/a/tickets/1980461