Is there any possibility to find out who or when a Contact record was deleted?

Version 2

    Details

    Is there any possibility to find out who or when a Contact record was deleted?


    Resolution

    [INFORMATION]
    - GoldMine does not have an auditing  capability and therefore does not track by default and application wise  who and when or how a record was deleted.
    - It might be possible when  the SQL database property Recovery Model set to Full  a  knowledgeable SQL DBA would be able to find out, but this is outside the  GoldMine Technical Support boundaries.
    - GoldMine itself tracks changes  of a record once the record was at least one time synchronized (for example via  GoldSync, Sync Wizard - without Sync Only current contact, Outlook  Sync  - without sync only current contact). At this point the related  Tlog entry changes from a value zznew (new and not yet synchronized) to  zsnew (new and synchronized) as from this point on the sync changes for  the record from a record level sync (the whole record will be taken) to a  field level sync (only changed field values are considered to be  synced)

    Please review the available screen recording which explains also a little bit further. This video can be reviewed or downloaded from https://www.screencast.com/t/B5D9Qfg9Z

    - If a customer is regularly synchronizing then there might be a chance to find  out who and when a record was deleted but otherwise there is nothing  from within GoldMine itself logging a deletion of a record.

    - What partners or customers may want to consider is a trigger recording all deletions of Contact1 records into a  separate database/table, but this is outside the GoldMine Technical Support boundaries, therefore we cannot not assist in creation,  optimizing, investigating or troubleshooting such a trigger, however the attached archive contains an example trigger that could be used to achieve the above task.

    The archive contains 3 files >>
    1_GoldMineC1AuditionlogsDBcreation script will create a new database,
    2_GoldMineC1AuditionlogsTablecreation script will create a new table within the new database and
    3_GoldMineC1Auditionlogs  AUDIT_DELETE_GMPE2016_1 generates a trigger on the CONTACT1 table which  will record Deletion actions with additional information like which  machine which Windows User Date and Time and the application.

    Review the table content from time to time or if necessary, this table may  then help further in investigating how those mentioned records vanished.