Process_CSV Procesa ficheros CSV Normal 0 / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2023/06/09 19:28:28.195 - 2023/06/09 19:28:28.195 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N stagedb SQLITE Native /Volumes/T7 Touch/TFG/Stage/stage.db -1 Encrypted FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER -1 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N n_ID n_Assigned_Group Y Repeat L,A, Assign LD Split Priority Y Split Priority Split Status Y Sort ID-Audit_Date Repeat P,S,AG Y Repeat P,S,AG n_ID Y n_Assigned_Group Repeat L,A, Assign LD Y ND,PD,PS,PG first_LD,AG,RD Y t_seconds,l_seconds ifnull t_seconds,l_seconds Y Split Status Split Reason Y ifnull t_seconds,l_seconds Stream lookup Y SLAs Stream lookup Y Stream lookup SLA Response Y SLA Response SLA resolution Y SLA resolution SLA reopen Y Get_RD, Count_RD ND,PD,PS,PG Y first_LD,AG,RD Path, NA, NL Y Path, NA, NL t_seconds,l_seconds Y Split Reason Get_RD, Count_RD Y Select values BBDD Stage Y SLA reopen Time resolution, pending Y Time resolution, pending Select values Y CSV file input Sort ID-Audit_Date Y Get files from result CSV file input Y BBDD Stage TableOutput Y 1 none stagedb incidents 1000 Y N Y N N N Y N Y N

912 368 Y CSV file input CsvInput Se procesa el fichero de texto delimitado por comas para leer los campos Y 1 none path N ; "

Y

50000 N N Y N Unix UTF-8 Audit_date Date yyyy/MM/dd HH:mm:ss -1 -1 both ID String -1 -1 both Priority String -1 -1 both Status String -1 -1 both Status_Reason String -1 -1 both Assigned_Group String -1 -1 both Login String -1 -1 both Assignee String -1 -1 both Company String -1 -1 both Company_desc String -1 -1 both

176 80 Y Get_RD, Count_RD ScriptValueMod Y 1 none N 9 0 Script 1 var Resolved_date = null; if (Status_ID == 4) { Resolved_date = Audit_date; } if (n_ID == 1) { count_RD = 0; } if (Resolved_date != null) { count_RD += 1; } count_RD count_RD Integer -1 -1 N Resolved_date Resolved_date Date -1 -1 N

912 256 Y ND,PD,PS,PG AnalyticQuery Y 1 none ID Next_Date Audit_date LEAD 1 Previous_Date Audit_date LAG 1 Previous_Status_ID Status_ID LAG 1 Previous_Group Assigned_Group LAG 1

768 256 Y Path, NA, NL ScriptValueMod Y 1 none N 9 0 Script 1 //Script here var Path; if (Previous_Group==null) { Path=null; } var New_assign; if (! Assigned_Group.equals(Previous_Group)) { New_assign=1; // una reasignación de grupo reactiva el incidente if (Status_ID == 3) { Status_ID = 1; Status_Desc = "Assigned"; } if (Path == null) { Path = Assigned_Group; } else { Path = Path + "/" + Assigned_Group; } } else { New_assign=0; } Path Path String -1 -1 N New_assign New_assign Integer -1 -1 N Status_ID Status_ID Integer -1 -1 Y Status_Desc Status_Desc String -1 -1 Y

480 256 Y Repeat L,A, Assign LD ScriptValueMod Y 1 none N 9 0 Script 1 if (n_Assigned_Group == 1) { var last_Login = null; var last_Assignee = null; } // Login var Login_date; if (Login != null) { last_Login = Login; Login_Date = Audit_date; } else { Login = last_Login; Login_Date = null; } // Assignee var Assignee, last_Assignee; if (Assignee != null) { last_Assignee = Assignee; } else { Assignee = last_Assignee; } Login Login String -1 -1 Y Assignee Assignee String -1 -1 Y Login_Date Login_Date Date -1 -1 N

608 160 Y Repeat P,S,AG ScriptValueMod Y 1 none N 9 0 Script 1 // Priority var Priority, last_Priority; if (Priority != null) { last_Priority = Priority; } else { Priority = last_Priority; } // Status var Status, last_status; if (Status != null) { last_Status = Status; } else { Status = last_Status; } // Assigned_Group var Assigned_Group, last_Assigned_Group; if (Assigned_Group != null) { last_Assigned_Group = Assigned_Group; } else { Assigned_Group = last_Assigned_Group; } Priority Priority String -1 -1 Y Status Status String -1 -1 Y Assigned_Group Assigned_Group String -1 -1 Y

288 160 Y SLA Response ScriptValueMod Y 1 none N 9 0 Script 1 //Script here var expiration_response, last_expiration_response, last_response_sla, response_deadline; var SLA_response = null, SLA_response_meet, SLA_response_date = null, SLA_response_group = null, SLA_response_login = null; if (n_ID == 1) { expiration_response = dateAdd(Audit_date, "ss", Response_s); response_deadline = dateDiff(Audit_date,expiration_response,"ss"); SLA_response_meet = null; } else { expiration_response = last_expiration_response; } if (Previous_Status_ID == 3) { expiration_response = dateAdd(Audit_date, "ss", response_deadline); } var diff_er_ad = dateDiff(expiration_response,Audit_date,"ss"); var diff_fl_ad = dateDiff(first_LD,Audit_date,"ss"); // // Cumple SLA si diff_er_ad < 0 if (diff_fl_ad == 0) { // Línea donde cumple/incumple if (diff_er_ad < 0) { // Response meet SLA_response=Response_desc; SLA_response_meet=1; SLA_response_date=Audit_date; SLA_response_group=Assigned_Group; if (Login == null ) { SLA_response_login = "undefined"; } else { SLA_response_login=Login; } response_deadline = null; } else { if (SLA_response_meet == null) { //Response violated SLA_response = Response_desc; SLA_response_date=Audit_date; SLA_response_group = Assigned_Group; if (Login == null ) { SLA_response_login = "undefined"; } else { SLA_response_login=Login; } response_deadline = null; SLA_response_meet = 0; } } } // Parada de reloj if (Status_ID == 3) { if (diff_er_ad < 0) { // si todavía cumple //response_deadline = dateDiff(Audit_date,expiration_response,"ss"); expiration_response = null; } } else if (Status_ID != 4 && Status_ID != 5 && response_deadline > 0) { response_deadline = dateDiff (Audit_date, expiration_response, "ss"); } // Cumplimiento SLA if (response_deadline <= 0 && response_deadline != null) { // Response violated SLA_response = Response_desc; response_deadline = null; SLA_response_date=expiration_response; SLA_response_meet = 0; SLA_response_group = Assigned_Group; if (Login == null ) { SLA_response_login = "undefined"; } else { SLA_response_login=Login; } } last_expiration_response=expiration_response; expiration_response expiration_response Date -1 -1 N SLA_response SLA_response String -1 -1 N SLA_response_meet SLA_response_meet Integer -1 -1 N SLA_response_date SLA_response_date Date -1 -1 N SLA_response_group SLA_response_group String -1 -1 N response_deadline response_deadline Integer -1 -1 N diff_fl_ad diff_fl_ad Integer -1 -1 N SLA_response_login SLA_response_login String -1 -1 N

288 368 Y SLA reopen ScriptValueMod Y 1 none N 9 0 Script 1 //Script here var SLA_reopen = null, SLA_reopen_meet = null, SLA_reopen_date = null, SLA_reopen_group = null, SLA_reopen_login = null; if (n_ID == 1) { SLA_reopen_meet; } if (Status_ID == 4 && SLA_reopen_meet == null) { if (total_RD > 1) { SLA_reopen = "SLA violated, number of resolutions: " + total_RD; SLA_reopen_meet = 0; SLA_reopen_date=Audit_date; SLA_reopen_group = Assigned_Group; if (Login == null ) { SLA_reopen_login = "undefined"; } else { SLA_reopen_login=Login; } } else { SLA_reopen="Meets SLA, number of resolutions: " + total_RD; SLA_reopen_meet=1; SLA_reopen_date=Audit_date; SLA_reopen_group=Assigned_Group; if (Login == null ) { SLA_reopen_login = "undefined"; } else { SLA_reopen_login=Login; } } } SLA_reopen SLA_reopen String -1 -1 N SLA_reopen_meet SLA_reopen_meet Integer -1 -1 N SLA_reopen_group SLA_reopen_group String -1 -1 N SLA_reopen_date SLA_reopen_date Date -1 -1 N SLA_reopen_login SLA_reopen_login String -1 -1 N

512 368 Y SLA resolution ScriptValueMod Y 1 none N 9 0 Script 1 //Script here var expiration_resolution, last_expiration_resolution, last_resolution_sla, resolution_deadline; var SLA_resolution = null, SLA_resolution_meet, SLA_resolution_date = null, SLA_resolution_group = null, SLA_resolution_login = null; if (n_ID == 1) { expiration_resolution = dateAdd(Audit_date, "ss", Resolution_s); resolution_deadline = dateDiff(Audit_date,expiration_resolution,"ss"); SLA_resolution_meet = null; } else { expiration_resolution = last_expiration_resolution; } if (Previous_Status_ID == 3) { expiration_resolution = dateAdd(Audit_date, "ss", resolution_deadline); } var diff_er_ad = dateDiff(expiration_resolution,Audit_date,"ss"); var diff_fr_ad = dateDiff(first_RD,Audit_date,"ss"); // // Cumple SLA si diff_er_ad < 0 if (diff_fr_ad == 0) { // Primera resolución if (diff_er_ad < 0) { // Resolution meet SLA_resolution=Resolution_desc; SLA_resolution_meet=1; SLA_resolution_date=Audit_date; SLA_resolution_group=Assigned_Group; if (Login == null ) { SLA_resolution_login = "undefined"; } else { SLA_resolution_login=Login; } resolution_deadline = null; } else { if (SLA_resolution_meet == null) { // Resolution violated SLA_resolution = Resolution_desc; SLA_resolution_date=Audit_date; SLA_resolution_group = Assigned_Group; if (Login == null ) { SLA_resolution_login = "undefined"; } else { SLA_resolution_login=Login; } resolution_deadline = null; SLA_resolution_meet = 1; } } } // Parada de reloj if (Status_ID == 3 ) { if (diff_er_ad < 0) { // si todavía cumple resolution_deadline = dateDiff(Audit_date,expiration_resolution,"ss"); expiration_resolution = null; } } else if (Status_ID != 4 && Status_ID != 5 && resolution_deadline > 0) { resolution_deadline = dateDiff(Audit_date,expiration_resolution,"ss"); } // Cumplimiento SLA if (resolution_deadline <= 0 && resolution_deadline != null) { // Resolution violated SLA_resolution = Resolution_desc; resolution_deadline = null; SLA_resolution_meet = 0; SLA_resolution_group = Assigned_Group; SLA_resolution_date=expiration_resolution; if (Login == null ) { SLA_resolution_login = "undefined"; } else { SLA_resolution_login=Login; } } last_expiration_resolution=expiration_resolution; expiration_resolution expiration_resolution Date -1 -1 N SLA_resolution SLA_resolution String -1 -1 N SLA_resolution_meet SLA_resolution_meet Integer -1 -1 N SLA_resolution_date SLA_resolution_date Date -1 -1 N diff_er_ad diff_er_ad Integer -1 -1 N diff_fr_ad diff_fr_ad Integer -1 -1 N SLA_resolution_group SLA_resolution_group String -1 -1 N resolution_deadline resolution_deadline Integer -1 -1 N SLA_resolution_login SLA_resolution_login String -1 -1 N

400 368 Y SLAs DataGrid Y 1 none Priority_ID Integer -1 -1 N Priority_Desc String -1 -1 N Response_h Number -1 -1 N Resolution_h Number -1 -1 N Response_desc String -1 -1 N Resolution_desc String -1 -1 N Response_s Integer -1 -1 N Resolution_s Integer -1 -1 N 0 Critical 0.5 6 Response < 30m Resolution < 6h 1800 21600 1 High 1 12 Response < 1h Resolution < 12h 3600 43200 2 Medium 2 24 Response < 2h Resolution < 24h 7200 86400 3 Low 4 48 Response < 4h Resolution < 48h 14400 172800

64 368 Y Select values SelectValues Y 1 none Audit_date n_ID ID Priority_ID Priority_Desc Status_ID Status_Desc Reason_ID Reason_Desc Assigned_Group New_assign Login Assignee Company Company_desc Resolved_date total_RD Response_desc Resolution_desc SLA_response SLA_response_meet SLA_response_date SLA_response_group SLA_response_login SLA_resolution SLA_resolution_meet SLA_resolution_date SLA_resolution_group SLA_resolution_login SLA_reopen SLA_reopen_meet SLA_reopen_group SLA_reopen_login SLA_reopen_date l_seconds t_pending t_first_resolution t_total_resolution N

768 368 Y Sort ID-Audit_Date SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N N ID Y N N 0 N Audit_date Y N N 0 N

176 160 Y Split Priority RegexEval Y 1 none Priority result N Y Y N N N N N N N Priority_Desc String -1 -1 both Priority_ID Integer -1 -1 both

720 160 Y Split Reason RegexEval Y 1 none Status_Reason result N Y Y N N N N N N N Reason_Desc String -1 -1 both Reason_ID Integer -1 -1 both

912 160 Y Split Status RegexEval Y 1 none Status result N Y Y N N N N N N N Status_Desc String -1 -1 both Status_ID Integer -1 -1 both

816 160 Y Stream lookup StreamLookup Y 1 none SLAs N Y N N Priority_ID Priority_ID Response_desc Response_desc String Resolution_desc Resolution_desc String Response_s Response_s Integer Resolution_s Resolution_s Integer

176 368 Y Time resolution, pending ScriptValueMod Y 1 none N 9 0 Script 1 //Script here var t_first_resolution, t_total_resolution, t_pending, resolved; if (n_ID == 1) { t_first_resolution = t_seconds; t_total_resolution = t_seconds; t_pending = 0; resolved=0; } else { if (Status_ID == 1 || Status_ID == 2) { if (resolved==0) { t_first_resolution = t_first_resolution + t_seconds; t_total_resolution = t_total_resolution + t_seconds; } else { t_total_resolution = t_total_resolution + t_seconds; } if (Status_ID == 4) { resolved=1; } } if (Status_ID == 3) { t_pending = t_pending + t_seconds; } } t_first_resolution t_first_resolution Integer -1 -1 N t_total_resolution t_total_resolution Integer -1 -1 N t_pending t_pending Integer -1 -1 N

640 368 Y first_LD,AG,RD GroupBy Y 1 none Y N %%java.io.tmpdir%% grp N N ID first_LD Login_Date FIRST first_AG Audit_date FIRST first_RD Resolved_date FIRST total_RD count_RD LAST_INCL_NULL first_Login Login FIRST

624 256 Y ifnull t_seconds,l_seconds ScriptValueMod Y 1 none N 9 0 Script 1 if (t_seconds == null) { t_seconds = 0; } if (l_seconds == null) { l_seconds = t_seconds; } l_seconds t_response Integer -1 -1 Y t_seconds t_resolution Integer -1 -1 Y

176 256 Y n_Assigned_Group FieldsChangeSequence Y 1 none 1 1 n_Assigned_Group ID Assigned_Group

480 160 Y n_ID FieldsChangeSequence Y 1 none 1 1 n_ID ID

384 160 Y t_seconds,l_seconds Calculator Y 1 none Y t_seconds DATE_DIFF_SEC Next_Date Audit_date Integer -1 -1 N l_seconds DATE_DIFF_SEC first_LD first_AG Integer -1 -1 N

320 256 Y Get files from result FilesFromResult Y 1 none

64 80 Y N