Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Viewing the Audit Log

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

0 COMMENTS

We’d like to hear from you!