Deleted record, who??

[froilan.alfaro]

You can tell who has erased a record?, Remains in some log of CRM or MySQL?

[eggsurplus]

Look in the module's table in the database at the modified_user_id. This will tell you who deleted the record.

select users.user_name, cases.date_modified, cases.deleted
from cases 
inner join users on cases.modified_user_id = users.id
where cases.id = ''

[salesagility]

if you have access to the database, find the record (deleted=1) and it will have the modified user ID which you can use the Users table to cross reference

[froilan.alfaro]

Teh table cases is emply

[eggsurplus]

My guess is that you aren't having an issue with a case record being deleted. What you'll need to do is go to the table for the module/tab that you have a deleted record for. You can simply replace "cases" in the query with the appropriate table to find who deleted the record. If it is an account replace "cases" with "accounts".

[froilan.alfaro]

OK, already found

by the way, do you know the last time you deleted = 0 before being deleted = 1??

[andopes]

All mark as deleted changes on some record are considered as a regular record modification, so this date time information is stored on date_modified.
You can ensure after marking as deleted some record it can not be modified unless undeleted, so the current date_modified indicates the time it was deleted.