find goldmine deleted contact

It seems some how one of our contacts has been delted and no one knows how. As far as I can tell only 3 people have the rights to delete a contact, but I don't know where in the logs to look to see who , when, and how it was done. Is there a way to get that information?
kevlauseAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
TommyTupaConnect With a Mentor Commented:
This can be accomplished by querying the conttlog table.

The following query will give you all deletes sorted by user:
select * from conttlog where fieldname='zzzdel' order by userid

If you want to search a particular table use this query:
select * from conttlog where fieldname='zzzdel' and tableid = '&' order by userid.

Table names:
& - Contact1
' - Contact2
* - ContGrps
) - ContHist
( - ContSupp
% - Conttlog
0 - ContUDef

The FRECID column in conttlog refers to the recid of the corresponding table.

The syncstamp and logstamp refer to the date\time of the change.  You can convert syncstamp and logstamp to actual values by entering the Goldsync Administration Center, Right-Clicking on 'Servers', and selecting 'Date\Time Stamp Conversion'.


HTH,
TT

0
All Courses

From novice to tech pro — start learning today.