DTree Modified Date

[bvillebullet]

I am hoping this is a simple question but I see that DTree tables is where the Modified Date values reside. Is there an equivalent Modified By value (similiar to Created By) somewhere in DTree or am I missing the obvious? Do I need to hot the audit tables via LR in order to obtain the Modified By Value for reporting purposes?

 

[ggriffit]

I would look in the Audit tables, as they will tell you who, when, why and what

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/

 

[bvillebullet]

Right but then I guess the question becomes what auditable events trigger a last modified date being recorded because everything in the Audit Tables do not. I need to find the name linked to that modified date.

 

[appnair]

in livelink usually the dataid after it is introduced is the create date.If the date is indeed changed by a event that is audited that is what
I think Greg was trying to tell you.If the event is not auditable you cannot know that.If it really needs to be a witch hunt then unless the
user attacked the database directly you can pretty much find the information from webserver logs(I used LogParser from Microsoft to find playing people)
and we use SummaryTimingsLogs so it records everything with a userid context.

Now some of the things that change the ModifyDate is hard for a lay person to understand.

If you are on the side of the people that stands ModifyDate of a Object is sacred,then anything on that object say addition to ACL's(permissions),metadata changes etc changes it
It follows the file system paradigm.

However if you are on the side of the people saying that modifydate should not change unless a person changed name or content then that is also true.

Ot has built flags so that both sides can be kept happy.

If it is indeed a person who hanged something then the performerid that you see in DAUDITNEW is the KUAF.ID of the user a simple join or
using the administration gui for audit events can give you the real name of the user,if it was audited .

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

http://www.livelink.in

 

[bvillebullet]

FYI per Open Text Support CS 10.0 they added a Modified By field to DTree. We are currently on 9.7.1 but will be upgrading to 10 in the next year. On 9.7.1 you need to hit the DAuditNew Table to get the Modified By value.