Adding and Viewing DESCRIPTION_LONGDESCRIPTION e-Audit Data

In a previous post, I showed how to setup a view for your audit data which is great, but what happens when you want to audit the data for Long Description of an attribute?  In Maximo Database Configuration, you can enable the auditing on the WORKORDER.DESCRIPTION_LONGDESCRIPTION but if you want to view the correct data, there is more setup required.

In order to properly show the last value for the long description like this screenshot below, you have to create the proper relationship.

Audit

When you enable the auditing on the WORKORDER object, Maximo will create a A_WORKORDER object which holds all the audit data.  Find the A_WORKORDER object in Database Configurations and click on the Relationship tab.  Click New Row and add this where clause:

ldownertable = 'workorder' and ldownercol = 'description' and ldkey = :workorderid and eaudittransid = :eaudittransid

Set the relationship name to A_DESCRIPTION_LONGDESCRIPTION and the Child Object should be A_LONGDESCRIPTION and finally it should look like this:

Audit1

Now if you want to view the data in a view from our previous post, you can go to Application Designer and add another column to the table and set the attribute to ‘A_DESCRIPTION_LONGDESCRIPTION.LDTEXT’

Audit2

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobileEZPlanner and EZInsight.

Find Out More

Leave a Reply