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.

VIEW: CS.CSY_RESPONSE_RESOLUTIONS#

Source

View Text - Preformatted


select SUMMARY_DATE SUMMARY_DATE, OWNER_TYPE OWNER_TYPE, OWNER_GROUP_ID OWNER_GROUP_ID, INCIDENT_OWNER_ID INCIDENT_OWNER_ID, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID, TOTAL_RESPONSE_TIME TOTAL_RESPONSE_TIME, TOTAL_REQUESTS_RESPONDED TOTAL_REQUESTS_RESPONDED, TOTAL_WAIT_ON_AGENT_RESP TOTAL_WAIT_ON_AGENT_RESP, TOTAL_WAIT_ON_OTHERS_RESP TOTAL_WAIT_ON_OTHERS_RESP, TOTAL_REQUESTS_RESOLVED TOTAL_REQUESTS_RESOLVED, TOTAL_RESOLVE_TIME TOTAL_RESOLVE_TIME, TOTAL_WAIT_ON_AGENT_RESL TOTAL_WAIT_ON_AGENT_RESL, TOTAL_WAIT_ON_INT_ORG_RESL TOTAL_WAIT_ON_INT_ORG_RESL, TOTAL_WAIT_ON_EXT_ORG_RESL TOTAL_WAIT_ON_EXT_ORG_RESL, TOTAL_WAIT_ON_SUPPORT_RESL TOTAL_WAIT_ON_SUPPORT_RESL, TOTAL_WAIT_ON_CUSTOMER_RESL TOTAL_WAIT_ON_CUSTOMER_RESL, TOTAL_RESP_SLA_MISSED TOTAL_RESP_SLA_MISSED, TOTAL_RESL_SLA_MISSED TOTAL_RESL_SLA_MISSED, BEGINNING_BACKLOG BEGINNING_BACKLOG, ENDING_BACKLOG ENDING_BACKLOG, TOTAL_SR_ASSIGNED TOTAL_SR_ASSIGNED, TOTAL_SR_REASSIGNED_TO_OTHERS TOTAL_SR_REASSIGNED_TO_OTHERS, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "CS"."CSY_RESPONSE_RESOLUTIONS"

View Text - HTML Formatted

SELECT SUMMARY_DATE SUMMARY_DATE
, OWNER_TYPE OWNER_TYPE
, OWNER_GROUP_ID OWNER_GROUP_ID
, INCIDENT_OWNER_ID INCIDENT_OWNER_ID
, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, TOTAL_RESPONSE_TIME TOTAL_RESPONSE_TIME
, TOTAL_REQUESTS_RESPONDED TOTAL_REQUESTS_RESPONDED
, TOTAL_WAIT_ON_AGENT_RESP TOTAL_WAIT_ON_AGENT_RESP
, TOTAL_WAIT_ON_OTHERS_RESP TOTAL_WAIT_ON_OTHERS_RESP
, TOTAL_REQUESTS_RESOLVED TOTAL_REQUESTS_RESOLVED
, TOTAL_RESOLVE_TIME TOTAL_RESOLVE_TIME
, TOTAL_WAIT_ON_AGENT_RESL TOTAL_WAIT_ON_AGENT_RESL
, TOTAL_WAIT_ON_INT_ORG_RESL TOTAL_WAIT_ON_INT_ORG_RESL
, TOTAL_WAIT_ON_EXT_ORG_RESL TOTAL_WAIT_ON_EXT_ORG_RESL
, TOTAL_WAIT_ON_SUPPORT_RESL TOTAL_WAIT_ON_SUPPORT_RESL
, TOTAL_WAIT_ON_CUSTOMER_RESL TOTAL_WAIT_ON_CUSTOMER_RESL
, TOTAL_RESP_SLA_MISSED TOTAL_RESP_SLA_MISSED
, TOTAL_RESL_SLA_MISSED TOTAL_RESL_SLA_MISSED
, BEGINNING_BACKLOG BEGINNING_BACKLOG
, ENDING_BACKLOG ENDING_BACKLOG
, TOTAL_SR_ASSIGNED TOTAL_SR_ASSIGNED
, TOTAL_SR_REASSIGNED_TO_OTHERS TOTAL_SR_REASSIGNED_TO_OTHERS
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "CS"."CSY_RESPONSE_RESOLUTIONS"