Hello Aware IM, I am the proud new owner of your product and have been having a great time developing web applications. I have several apps that I would like to web enable. Many of these apps have code incorporated to capture the navigational movements of my administrators and the details of any changes. The detail audit table has the following data: Object Modified (Business Object) Object Field Modified (Attribute) Object Field Reference (ID, Name...etc) Date/Time Modified Type of Activity (Addition, Delete, Append, Update) Original Data Modified Data User who Modified Record From what I can tell this should be possible in Aware IM but since I am new at this I have not been able to make this work yet. As you can imagine my audit tables have been very large in the past because it tracked everything that was added and deleted (as well as, updates to a record). I hope that you can help me. Thank you, PEFS

Hello PEFS, There are many ways to capture change history. I will describe a generic approach, which you can extend depending on the depth of information you want to record. Object AuditTrail keeps a single change event and has the following attributes: Name: MadeOn, Type: Timestamp, Initial value: CURRENT_TIMESTAMP Name: MadeBy, Type: SystemUser Name: ObjectID, Type: Number Name: Description, Type: Text To capture a change to a particular attribute, add a rule like the following to the object of interest (Person in this example): If NOT(Person IS NEW) AND Person.DateOfBirth WAS CHANGED Then CREATE AuditTrail WITH AuditTrail.MadeBy = LoggedInSystemUser, AuditTrail.ObjectID = Person.ID, AuditTrail.Description = 'Changed DateOfBirth on Person from to ' To capture creation of a new object, add a rule like this: If Person IS NEW Then CREATE AuditTrail WITH AuditTrail.MadeBy = LoggedInSystemUser, AuditTrail.ObjectID = Person.ID, AuditTrail.Description = 'Created new Person' To capture deletion of an object, add a rule like this to the Rules When Object Is Deleted for the object: CREATE AuditTrail WITH AuditTrail.MadeBy = LoggedInSystemUser, AuditTrail.ObjectID = Person.ID, AuditTrail.Description = 'Deleted Person' You can also keep track of users logging in and out of the system. Please see sections Handling Login Events and Handling Logout Events in the Aware IM User Guide for details.

Great feedback and advice. I was able to get it to work except for the deletion part. I am unsure of where to add the rule. Is there something I have to add to the IF section of the rule? Thanks again for you help.

Unlike rules invoked when an object is created or changed, rules for object deletion are specified in a separate place. In the Configuration Tool tree on the left, expand the node for the object to which you are adding the rules. Right click "Rules (when object is deleted)" and click New. You do not need to add any conditions (the IF section) to the rule.

I have added the deletion audit code and it works great. Thank you for your prompt assistance! Do you have any documents beyond the standard documentation with tips and hints on Business Rule possibilities?

Rule Language Reference contains detailed definitions of all rule elements, How To has some tips on using rules, and there is a lot of information about rules in User Guide. All of these documents can be found in the DOCS directory under Aware IM installation directory. Specific examples of rules can also be found in this forum.

Hi Support. Am interested in implementing the approach suggested in this post; [color=blue]Object AuditTrail keeps a single change event and has the following attributes: Name: MadeOn, Type: Timestamp, Initial value: CURRENT_TIMESTAMP Name: MadeBy, Type: SystemUser [/color] [color=red]Name: ObjectID, Type: Number [/color] [color=blue]Name: Description, Type: Text [/color] If the goal was to monitor changes to multiple BO's, the attribute ObjectID could still be used, irrespective of the business object? The AuditTrail Object would just require the business object ID as input? If this is correct, then I assume that the ID's generated by AwareIM are unique to each Business Space version and increment with each instance created.

Hi Support. Another question in regards to the suggested 'AuditTrail' approach. If an attribute was updated by a Schedule System process, would this approach still work?

Every object instance has a unique ID within a business space. The approach will work whenever an attribute is changed regardless of how the change was initiated (i.e. via web browser, scheduling, incoming email, external service request, etc.)

Hi Is it possible to audit when an object is viewed/accessed even thoug no changes have been made.

Yes. Just make sure that an object is only accessed via a process. A process would create an audit record first and then show the form of the object by using the VIEW action.

Audit Records

tford

Oops -- My second line should have been:

CREATE CustomerLogs WITH CustomerLogs.Fname=Customer.Fname,CustomerLogs.Lname=Customer.Lname,CustomerLogs.AuditLogId=CustomerLogs.id

CustomerLogs.id should be in context here since it was just created in the first rule.

Craig

Tom,

Thanks for your replies...
i did the following and got it working:
Rule invoked when instance ofcustomer object is created:

If Customer IS NEW
Then
CREATE CustomerLogs WITH CustomerLogs.CustNo=ThisCustomer.CustNo,CustomerLogs.Fname=Customer.Fname,CustomerLogs.Lname=Customer.Lname
CREATE Auditog WITH Auditog.objectModified='Customer',Auditog.reference=ThisCustomer.Fname,Auditog.time=CURRENT_TIMESTAMP,Auditog.userId=LoggedInSystemUser.LoginName,Auditog.auditId=MAX Auditog.auditId+1,Auditog.action='new customer'

Rule when an instance of AuditLog is created:
If Auditog IS NEW Then
FIND CustomerLogs WHERE CustomerLogs.auditId IS UNDEFINED
CustomerLogs.auditId=Auditog.auditId

tford

Very useful improvement in build 1212 descibed at http://www.awareim.com/changelog/Readme1212.txt

Function: GET_CHANGES

Description: If an object was changed returns which attributes have been changed as well as old and new values

Parameters: Object name that has been changed

Example: IF MyObject WAS CHANGED THEN CREATE AuditRecord WITH AuditRecord.Description=GET_CHANGES(MyObject)

« Previous Page