Enabling audit tracking by using attributes

Edit online

You can enable e-auditing on any object in Maximo Manage for any attribute by using the Database configuration application.

Before you begin

You must login to Maximo Application Suite as an administrator to enable e-audit through the Maximo Manage user interface.

About this task

When you enable e-audit and save the changes to the attribute, an audit record is created in a corresponding audit table. The audit table is created if it is not already existing in the database. When any user adds, deletes, or modifies an e-audit enabled attribute value through any Maximo Manage application, the changes are tracked and saved in its e-audit table. Typically, the audit table is named a_<objectname>. The audit record includes the following information:
  • A copy of the changed data.
  • The username of the user who is making the change.
  • An identifier that indicates the type of change, for example, insert or update or delete, and a unique transaction ID for the change.
  • The timestamp of the change.

Procedure

  1. In Maximo Manage, go to the Database configuration application from the side navigation menu.
  2. Search for any object for which you want to enable e-audit tracking through attributes.
    For example, ASSETLOCUSERCUST
  3. Click the object name to view the details and go to the Attributes tab.
  4. Expand the specific attribute for which you want to enable e-audit, from the list of attributes.
  5. In the Advanced section, turn on Audit Enabled.
  6. Save the changes.
  7. Open the object corresponding to the application, which is supposed to display the e-audit trail.
    For example, ASSET.
  8. In the Relationships tab, click the Add icon to add a relationship.
  9. Specify a relationship name and select the object on which you enabled e-audit tracking in the Child Object field.
    For example, A_ASSET.
  10. Specify a clause in the Where Clause field.
    For example, 'assetnum = :assetnum and siteid = :sited'
  11. Click the Save Object icon to save and apply the changes.
  12. Go to Application Designer from the side navigation menu.
  13. Search for and open the application in which you want to see the e-audit trail.
  14. Add a table section to reference the relationship that you created in steps 8-11.
  15. Add any columns that you want displayed in the table.
  16. Click the Save Application Definition icon to save your changes.
    The e-audit trail is displayed in the application for which you enabled it. As users make changes, a history of the changes is displayed in the new table you added.