eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: IBC.IBC_AUDIT_LOGS#

Source

View Text - Preformatted


select AUDIT_LOG_ID AUDIT_LOG_ID, ACTIVITY ACTIVITY, USER_ID USER_ID, TIME_STAMP TIME_STAMP, OBJECT_TYPE OBJECT_TYPE, PARENT_VALUE PARENT_VALUE, OBJECT_VALUE1 OBJECT_VALUE1, OBJECT_VALUE2 OBJECT_VALUE2, OBJECT_VALUE3 OBJECT_VALUE3, OBJECT_VALUE4 OBJECT_VALUE4, OBJECT_VALUE5 OBJECT_VALUE5, DESCRIPTION DESCRIPTION, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, INTERNAL_FLAG INTERNAL_FLAG, APPLICATION_ID APPLICATION_ID, MESSAGE_NAME MESSAGE_NAME, EXTRA_INFO1_TYPE EXTRA_INFO1_TYPE, EXTRA_INFO1_REF_TYPE EXTRA_INFO1_REF_TYPE, EXTRA_INFO1_VALUE EXTRA_INFO1_VALUE, EXTRA_INFO2_TYPE EXTRA_INFO2_TYPE, EXTRA_INFO2_REF_TYPE EXTRA_INFO2_REF_TYPE, EXTRA_INFO2_VALUE EXTRA_INFO2_VALUE, EXTRA_INFO3_TYPE EXTRA_INFO3_TYPE, EXTRA_INFO3_REF_TYPE EXTRA_INFO3_REF_TYPE, EXTRA_INFO3_VALUE EXTRA_INFO3_VALUE, EXTRA_INFO4_TYPE EXTRA_INFO4_TYPE, EXTRA_INFO4_REF_TYPE EXTRA_INFO4_REF_TYPE, EXTRA_INFO4_VALUE EXTRA_INFO4_VALUE, EXTRA_INFO5_TYPE EXTRA_INFO5_TYPE, EXTRA_INFO5_REF_TYPE EXTRA_INFO5_REF_TYPE, EXTRA_INFO5_VALUE EXTRA_INFO5_VALUE, OBJECT_STATUS OBJECT_STATUS, MESSAGE_APPLICATION MESSAGE_APPLICATION from "IBC"."IBC_AUDIT_LOGS"

View Text - HTML Formatted

SELECT AUDIT_LOG_ID AUDIT_LOG_ID
, ACTIVITY ACTIVITY
, USER_ID USER_ID
, TIME_STAMP TIME_STAMP
, OBJECT_TYPE OBJECT_TYPE
, PARENT_VALUE PARENT_VALUE
, OBJECT_VALUE1 OBJECT_VALUE1
, OBJECT_VALUE2 OBJECT_VALUE2
, OBJECT_VALUE3 OBJECT_VALUE3
, OBJECT_VALUE4 OBJECT_VALUE4
, OBJECT_VALUE5 OBJECT_VALUE5
, DESCRIPTION DESCRIPTION
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, INTERNAL_FLAG INTERNAL_FLAG
, APPLICATION_ID APPLICATION_ID
, MESSAGE_NAME MESSAGE_NAME
, EXTRA_INFO1_TYPE EXTRA_INFO1_TYPE
, EXTRA_INFO1_REF_TYPE EXTRA_INFO1_REF_TYPE
, EXTRA_INFO1_VALUE EXTRA_INFO1_VALUE
, EXTRA_INFO2_TYPE EXTRA_INFO2_TYPE
, EXTRA_INFO2_REF_TYPE EXTRA_INFO2_REF_TYPE
, EXTRA_INFO2_VALUE EXTRA_INFO2_VALUE
, EXTRA_INFO3_TYPE EXTRA_INFO3_TYPE
, EXTRA_INFO3_REF_TYPE EXTRA_INFO3_REF_TYPE
, EXTRA_INFO3_VALUE EXTRA_INFO3_VALUE
, EXTRA_INFO4_TYPE EXTRA_INFO4_TYPE
, EXTRA_INFO4_REF_TYPE EXTRA_INFO4_REF_TYPE
, EXTRA_INFO4_VALUE EXTRA_INFO4_VALUE
, EXTRA_INFO5_TYPE EXTRA_INFO5_TYPE
, EXTRA_INFO5_REF_TYPE EXTRA_INFO5_REF_TYPE
, EXTRA_INFO5_VALUE EXTRA_INFO5_VALUE
, OBJECT_STATUS OBJECT_STATUS
, MESSAGE_APPLICATION MESSAGE_APPLICATION
FROM "IBC"."IBC_AUDIT_LOGS"