Insert Audit Records using Content Web Services (CWS)

We are in the process of migrating documents from legacy DM system to OT Content Server v 10. We understand the activity types in the legacy system does not match the activity types in Content Server (DAutitNew). We will be creating a mapping table to relate the activity types.

After doing this, is there a method/function in Content Web Services that is used to explicitly insert multiple rows into the DAuditNew table against a particular document based on the number of rows that exist in the legacy document management system.

For e.g. Lets say Document# 1000 in the legacy system has 5 rows in the activity table:

1. CREATE (10/12/2001)

2. View (04/04/2002)

3. Export (04/19/2002)

4. Add Version (09/06/2005)

5. Add Version. (11/04/2005)

How do I leverage CWS to insert multiple DAuditNew rows for a particular document.

Regards

Vijhay Devarajan

Find more posts tagged with

Comments

Appu_Nair

Hi Vijhay

Some Clues

CWS is an extendable framework.If you know oscript you can write your CWS stub so your client can do what you are doing no mean fete though but at least that is the thoory
Events that are in dauditnew actually happens when you are doing things in livelink such as adding,viewing etc and regardless of whether you do it with GUI,LAPI or WebSvcs .It is not as if you can insert things into duaditnew,I am sure you can do it but you will run into database corruption problems which OT will have your skin for
I am not too familar with writing oscript concerning dauaditnew ,but I know that when OT provides these tables they expect a programmer to make use of it.So I would see if I can figure that out reading thru the SDK or looking at some calls

In the past to carry over legacy pulls one would use OI and throw a category on it and be satisfied with reporting on that.I have enclosed a word document on how I would skin this in my way https://knowledge.opentext.com/knowledge/cs.dll?func=ll&objId=21316787&objAction=download&viewType=1

Vijhay Devarajan

Hey Appu

Does it mean, there is no custmm way to add rows into the Audit table and it seems like there is no way to migrate audit information from legacy DM system to Content Server.

The caveat when adding the audit as part of category is, users with system administration access can change the audit information., which may have implications in the future on regulatory documents.

Regards

Vijhay Devarajan

Appu_Nair

“Does it mean, there is no custmm way to add rows I”

Appu Reply:I do not know how to do this in a supported way.

“category is, users with system administration access can change the audit information”

Appu Reply:System Admins can write live reports or go to the audit RH and do some things and change audit info as well.So you have to create a process within the org

To make it work for you

From: eLink Entry: Content Web Services Forum [mailto:otdncontentwebservices971forum@elinkkc.opentext.com]
Sent: Tuesday, November 22, 2011 4:06 PM
To: eLink Recipient
Subject: Insert Audit Records using Content Web Services (CWS)

Insert Audit Records using Content Web Services (CWS)

Posted by vijhay.devarajan@sce.com (Devarajan, Vijhay) On 11-22-2011 17:01

Hey Appu

Does it mean, there is no custmm way to add rows into the Audit table and it seems like there is no way to migrate audit information from legacy DM system to Content Server.

The caveat when adding the audit as part of category is, users with system administration access can change the audit information., which may have implications in the future on regulatory documents.

Regards

Vijhay Devarajan

[To post a comment, use the normal reply function]
Topic:	Insert Audit Records using Content Web Services (CWS)
Forum:	Content Web Services Forum
Content Server:	Knowledge Center

Kyle_Swidrovich

The $LLIAPI.AuditSubsystem.Audit() script is commonly used throughout the product to register auditable events.

If you were to extend CWS to add your own "Create an Audit Event" call, then you could call the $LLIAPI.AuditSubsystem.Audit script directly, and map each audit event from the legacy DM system to the Content Server audit events.

Each registered event can be found in the registry of the $LLIAPI.AuditSubsystem.
It would be up to you to determine how to map event X in the legacy system to event Y in the Content Server system.

Extending CWS in this fashion will still leave you in a supported environment, however, Customer Support staff will not be able to assist with the details of your implementation under standard support.

Regards,
Kyle

Ferdinand Prantl

We have a similar scenario in archiving from SharePoint. We transfer audit events from the original SP document to the archived LL document in. We created custom events for SP operations not to confuse imported audit events with the standard LL ones. Then use the function Kyle mentioned to write to log.

The only issue we met was that the LL audit log cannot contain some additional information like foreign user name or textual comment. If you are satisfied with the amount of information available in a LL event you can be happy with it.

--- Ferda

Vanderpoel_Rob

Hi there,

I just came across this after having just searched the web services docs.

I certainly can't find any specific for adding custom audit records but I do see a number of Set... methods on the NodeAuditRecord class. Seems a bit odd to me that these methods exist when there is no method to add or update audit records.

So I'm curious to know what these methods are there for.

Cheers

Rob

Kyle_Swidrovich

Hi Rob,

The existence of setters for essentially read-only properties is an unfortunate side effect of the current SDO design for Content Web Services.
The source code generation for each web service currently outputs both a getter and setter for each property of an SDO.
Some cases where there should not be a setter are the audit properties (as you noted), node create / modify dates, etc.

Ideally, we would extend the model for SDOs to allow a developer to mark a property as READONLY, which would provide us with a way to exclude setters during source generation.

Unfortunately, this isn't something we'd be able to deliver on in a short time frame.

Cheers,
Kyle

Vanderpoel_Rob

Any chance of the docs indicating that these methods don't do anything?

Kyle_Swidrovich

Hi Rob,

The methods technically “do” something, as they do allow you to set local properties on the object instance.

However, no methods that consume that object will read those properties.

We’ve taken note of this and hope to clarify this in a future release of documentation.

Thanks,

Kyle