?
Solved

find goldmine deleted contact

Posted on 2006-11-29
1
Medium Priority
?
508 Views
Last Modified: 2013-11-24
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?
0
Comment
Question by:kevlause
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 13

Accepted Solution

by:
TommyTupa earned 2000 total points
ID: 18042989
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

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello All, In previous article we used Hortonworks sandbox to work with Hadoop. Now, lets think to create own single node Hadoop on Linux. Here we Install and Configure Apache Hadoop on UI based Oracle Linux. I assume, you have VMware installe…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question