Configuration Guide

10.3 HotFix 1

Back Next

Viewing the Audit Log

You can view the audit log using an external data management tool (not included with Informatica MDM Hub).

If available in the data management tool you use to view the log file, you can focus your viewing by filtering entries—by audit level (view only debug-level or info-level entries), by time (view entries within the past hour), by operation success / failure (show error entries only), and so on.

The following SQL statement shows an Oracle and IBM DB2 example:

SELECT ROWID_AUDIT, FROM_SYSTEM, TO_SYSTEM, USERNAME, COMPONENT, ACTION, STATUS, TABLE_NAME, ROWID_OBJECT, ROWID_AUDIT_PREVIOUS, DATA_XML, 
CREATE_DATE FROM C_REPOS_AUDIT
WHERE CREATE_DATE >= TO_DATE('07/06/2006 12:23:00', 'MM/DD/YYYY HH24:MI:SS')
ORDER BY CREATE_DATE

The following SQL statement shows a Microsoft SQL Server example:

SELECT ROWID_AUDIT, FROM_SYSTEM, TO_SYSTEM, USERNAME, COMPONENT, ACTION, STATUS, TABLE_NAME,
ROWID_OBJECT, ROWID_AUDIT_PREVIOUS, DATA_XML,
CREATE_DATE FROM C_REPOS_AUDIT
WHERE CREATE_DATE >= CAST('01-JAN-2012' AS DATETIME)
ORDER BY CREATE_DATE

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Viewing the Audit Log

Viewing the Audit Log