DBA Data[Home] [Help]

VIEW: CS.CSY_AGENT_RESPN_RESOL_B#

Source

View Text - Preformatted

select PERIOD_TYPE PERIOD_TYPE, PERIOD_NAME PERIOD_NAME, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID, INCIDENT_OWNER_ID INCIDENT_OWNER_ID, TOTAL_RESPONSE_TIME TOTAL_RESPONSE_TIME, TOTAL_SR_RESPONDED TOTAL_SR_RESPONDED, TOTAL_RESP_SLA_MISSED TOTAL_RESP_SLA_MISSED, TOTAL_AGENT_WAIT TOTAL_AGENT_WAIT, TOTAL_OTHERS_WAIT TOTAL_OTHERS_WAIT, TOTAL_RESOLVE_TIME TOTAL_RESOLVE_TIME, TOTAL_SR_RESOLVED TOTAL_SR_RESOLVED, TOTAL_WAIT_AGENT TOTAL_WAIT_AGENT, TOTAL_WAIT_SUPPORT TOTAL_WAIT_SUPPORT, TOTAL_WAIT_INTERNAL TOTAL_WAIT_INTERNAL, TOTAL_WAIT_EXTERNAL TOTAL_WAIT_EXTERNAL, TOTAL_WAIT_CUSTOMER TOTAL_WAIT_CUSTOMER, 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 from "CS"."CSY_AGENT_RESPN_RESOL_B"
View Text - HTML Formatted

SELECT PERIOD_TYPE PERIOD_TYPE
, PERIOD_NAME PERIOD_NAME
, INCIDENT_SEVERITY_ID INCIDENT_SEVERITY_ID
, INCIDENT_OWNER_ID INCIDENT_OWNER_ID
, TOTAL_RESPONSE_TIME TOTAL_RESPONSE_TIME
, TOTAL_SR_RESPONDED TOTAL_SR_RESPONDED
, TOTAL_RESP_SLA_MISSED TOTAL_RESP_SLA_MISSED
, TOTAL_AGENT_WAIT TOTAL_AGENT_WAIT
, TOTAL_OTHERS_WAIT TOTAL_OTHERS_WAIT
, TOTAL_RESOLVE_TIME TOTAL_RESOLVE_TIME
, TOTAL_SR_RESOLVED TOTAL_SR_RESOLVED
, TOTAL_WAIT_AGENT TOTAL_WAIT_AGENT
, TOTAL_WAIT_SUPPORT TOTAL_WAIT_SUPPORT
, TOTAL_WAIT_INTERNAL TOTAL_WAIT_INTERNAL
, TOTAL_WAIT_EXTERNAL TOTAL_WAIT_EXTERNAL
, TOTAL_WAIT_CUSTOMER TOTAL_WAIT_CUSTOMER
, 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
FROM "CS"."CSY_AGENT_RESPN_RESOL_B"