Audit

Use the Audit panel to search for and display all activities performed by a user in IBM® Product Master in a defined time period. You can view details about users who log on or log out of the application, items or roles that were created, and import and export activities from the Audit panel.

In the Audit Log Search panel, enter the details of an event to search for. To customize the columns that are included in the table, click Customize button in the upper right corner of the table to display the Properties section. Click directly on the column header to sort through that particular column. To display the search results, specify the user and the date range, and then click Go at the bottom of the search interface.

The details about events that match the specified search criteria are displayed in the Search Audit Logs panel. To view more details about the user who performed an activity click the link on the user name.

All audit logs are globalized and display in the language of your current locale.

Trimming records from auditing tables

The TAUD_ALO_AUDIT_LOG table in the database contain auditing information that is safe to delete. This table is an audit log for specific events such as password changes and items added to a catalog.

Remember: The instructions provided are strictly applicable for the mentioned table only, applying changes to other application tables will lead to the application not functioning properly.
Important: Back up your database before running any of the SQL statements or doing any database actions.

Depending on the number of records in the tables, the delete statements may take a while to run. The SQL statements below assume you want to keep records after March 1, 2009. You can run all the SQLs through the Product Master UI by going to System Administrator -> DB Admin.

Estimate records for DB2: select count(*)from alo where date(ALO_TIMESTAMP)<'2009-03-01'

Delete records for DB2: delete from alo where date(ALO_TIMESTAMP)<'2009-03-01'

Estimate records for Oracle: select count(*)from alo where ALO_TIMESTAMP < to_date('2009-03-01','YYYY-MM-DD')

Delete records for Oracle: delete from alo where ALO_TIMESTAMP < to_date('2009-03-01','YYYY-MM-DD')