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: CS.CS_INCIDENT_ACTION_AUDIT#

Source

View Text - Preformatted


select INCIDENT_ACTION_AUDIT_ID INCIDENT_ACTION_AUDIT_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INCIDENT_ACTION_ID INCIDENT_ACTION_ID, INCIDENT_ID INCIDENT_ID, ACTION_OWNER_ID ACTION_OWNER_ID, ACTION_RESPONSE_FLAG ACTION_RESPONSE_FLAG, ACTION_STATUS_ID ACTION_STATUS_ID, ACTION_SEVERITY_ID ACTION_SEVERITY_ID, CHANGE_ACTION_TYPE_FLAG CHANGE_ACTION_TYPE_FLAG, CHANGE_RESPONSIBLE_GROUP_ CHANGE_RESPONSIBLE_GROUP_, CHANGE_ACTION_SEVERITY_FLAG CHANGE_ACTION_SEVERITY_FLAG, RESPONSIBLE_GROUP_ID RESPONSIBLE_GROUP_ID, OLD_RESPONSIBLE_GROUP_ID OLD_RESPONSIBLE_GROUP_ID, OLD_ACTION_SEVERITY_ID OLD_ACTION_SEVERITY_ID, OLD_ACTION_TYPE_ID OLD_ACTION_TYPE_ID, OLD_ACTION_STATUS_ID OLD_ACTION_STATUS_ID, OLD_ACTION_OWNER_ID OLD_ACTION_OWNER_ID, CHANGE_ACTION_STATUS_FLAG CHANGE_ACTION_STATUS_FLAG, CHANGE_ACTION_OWNER_FLAG CHANGE_ACTION_OWNER_FLAG, ACTION_TYPE_ID ACTION_TYPE_ID, ACTION_RESPONSE ACTION_RESPONSE, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE, OLD_EXPECTED_RESOLUTION_DATE OLD_EXPECTED_RESOLUTION_DATE, CHANGE_EXPECTED_DATE_FLAG CHANGE_EXPECTED_DATE_FLAG, CHANGE_RESPONSIBLE_GROUP_FLAG CHANGE_RESPONSIBLE_GROUP_FLAG, NEW_WORKFLOW_FLAG NEW_WORKFLOW_FLAG, WORKFLOW_PROCESS_NAME WORKFLOW_PROCESS_NAME, WORKFLOW_PROCESS_ITEMKEY WORKFLOW_PROCESS_ITEMKEY from "CS"."CS_INCIDENT_ACTION_AUDIT"

View Text - HTML Formatted

SELECT INCIDENT_ACTION_AUDIT_ID INCIDENT_ACTION_AUDIT_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INCIDENT_ACTION_ID INCIDENT_ACTION_ID
, INCIDENT_ID INCIDENT_ID
, ACTION_OWNER_ID ACTION_OWNER_ID
, ACTION_RESPONSE_FLAG ACTION_RESPONSE_FLAG
, ACTION_STATUS_ID ACTION_STATUS_ID
, ACTION_SEVERITY_ID ACTION_SEVERITY_ID
, CHANGE_ACTION_TYPE_FLAG CHANGE_ACTION_TYPE_FLAG
, CHANGE_RESPONSIBLE_GROUP_ CHANGE_RESPONSIBLE_GROUP_
, CHANGE_ACTION_SEVERITY_FLAG CHANGE_ACTION_SEVERITY_FLAG
, RESPONSIBLE_GROUP_ID RESPONSIBLE_GROUP_ID
, OLD_RESPONSIBLE_GROUP_ID OLD_RESPONSIBLE_GROUP_ID
, OLD_ACTION_SEVERITY_ID OLD_ACTION_SEVERITY_ID
, OLD_ACTION_TYPE_ID OLD_ACTION_TYPE_ID
, OLD_ACTION_STATUS_ID OLD_ACTION_STATUS_ID
, OLD_ACTION_OWNER_ID OLD_ACTION_OWNER_ID
, CHANGE_ACTION_STATUS_FLAG CHANGE_ACTION_STATUS_FLAG
, CHANGE_ACTION_OWNER_FLAG CHANGE_ACTION_OWNER_FLAG
, ACTION_TYPE_ID ACTION_TYPE_ID
, ACTION_RESPONSE ACTION_RESPONSE
, EXPECTED_RESOLUTION_DATE EXPECTED_RESOLUTION_DATE
, OLD_EXPECTED_RESOLUTION_DATE OLD_EXPECTED_RESOLUTION_DATE
, CHANGE_EXPECTED_DATE_FLAG CHANGE_EXPECTED_DATE_FLAG
, CHANGE_RESPONSIBLE_GROUP_FLAG CHANGE_RESPONSIBLE_GROUP_FLAG
, NEW_WORKFLOW_FLAG NEW_WORKFLOW_FLAG
, WORKFLOW_PROCESS_NAME WORKFLOW_PROCESS_NAME
, WORKFLOW_PROCESS_ITEMKEY WORKFLOW_PROCESS_ITEMKEY
FROM "CS"."CS_INCIDENT_ACTION_AUDIT"