How can you find out who originally made a note on an account?, How can you find out who originally made a note on an account?

I need to find out who originally added a note to a contacts account.  The employee is no longer with us and the created by is blank...

Parents
  • If you look at that note record in the database, there should be a created_by value that houses a user ID.  That user ID should correlate to a user ID in the users table.  If the user was deleted it would explain why it displays a blank value in the user interface.  If that ID is no longer in the users table, because it was soft deleted (deleted = 1) and then hard-deleted (delete from users where id = '...') then you would need to load a backup of your instance to see if that user ID could be retrieved.

Reply
  • If you look at that note record in the database, there should be a created_by value that houses a user ID.  That user ID should correlate to a user ID in the users table.  If the user was deleted it would explain why it displays a blank value in the user interface.  If that ID is no longer in the users table, because it was soft deleted (deleted = 1) and then hard-deleted (delete from users where id = '...') then you would need to load a backup of your instance to see if that user ID could be retrieved.

Children