1104,1476.8 Query_Results_1 System.Activities System.Activities.Statements System.Activities.Expressions System.Activities.Validation System.Activities.XamlIntegration Microsoft.VisualBasic Microsoft.VisualBasic.Activities System System.Collections System.Collections.Generic System.Data System.Diagnostics System.Drawing System.IO System.Linq System.Net.Mail System.Xml System.Xml.Linq System.Windows.Markup UiPath.Core UiPath.Core.Activities UiPath.Excel System.Xml.Serialization System.Text.RegularExpressions Microsoft.VisualBasic.CompilerServices UiPath.Database UiPath.Abbyy.Core.FlexiCapture UiPath.Abbyy.Core.FlexiCapture.Enums UiPath.Abbyy.Core.FlexiCapture.ValidationStationAdapters System.Collections.ObjectModel System.Activities.DynamicUpdate System.ComponentModel System.Runtime.Serialization UiPath.Excel.Activities System.Activities Microsoft.VisualBasic mscorlib System.Data System.Data.DataSetExtensions System System.Drawing System.Core System.Xml System.Xml.Linq PresentationFramework WindowsBase PresentationCore System.Xaml UiPath.System.Activities UiPath.UiAutomation.Activities UiPath.Excel.Activities UiPath.Excel System.ValueTuple System.ServiceModel UiPath.CV UiPath.Mail System.ComponentModel.Composition UiPath.System.Activities.Design System.Memory UiPath.Database UiPath.Abbyy.Activities UiPath.Abbyy.Core UiPath.Java.Activities System.Runtime.Serialization False False True 270,2.5 60,75.2 300,77.5 300,147 983 1375 __ReferenceID0 200,147 200,68.8 True False False True [hour_now] [CInt(Now.Hour)] [min_now] [CInt(Now.Minute)] [time1_split] [time_1.Split({“to”},StringSplitOptions.None)] [time2_split] [time_2.Split({“to”},StringSplitOptions.None)] [time3_split] [time_3.Split({“to”},StringSplitOptions.None)] [time4_split] [time_4.Split({“to”},StringSplitOptions.None)] True [splt_hr1] [time1_split(0).Split({“:”},StringSplitOptions.None)] [splt_hr2] [time2_split(0).Split({“:”},StringSplitOptions.None)] [splt_hr3] [time3_split(0).Split({“:”},StringSplitOptions.None)] [splt_hr4] [time4_split(0).Split({“:”},StringSplitOptions.None)] False False True False False False False [start_time] [time1_split(0).Split({“:”},StringSplitOptions.None)] [starttime_hr] [CInt(start_time(0))] [starttime_mn] [CInt(start_time(1))] False False [end_time] [time1_split(1).Split({“:”},StringSplitOptions.None)] [endtime_mn] [CInt(end_time(1))] [state_threshold] ["State / Threshold 1"] False False False False False False [start_time] [time2_split(0).Split({“:”},StringSplitOptions.None)] [starttime_hr] [CInt(start_time(0))] [starttime_mn] [CInt(start_time(1))] False False [end_time] [time2_split(1).Split({“:”},StringSplitOptions.None)] [endtime_mn] [CInt(end_time(1))] [state_threshold] ["State / Threshold 2"] False False False False False False [start_time] [time3_split(0).Split({“:”},StringSplitOptions.None)] [starttime_hr] [CInt(start_time(0))] [starttime_mn] [CInt(start_time(1))] False False [end_time] [time3_split(1).Split({“:”},StringSplitOptions.None)] [endtime_mn] [CInt(end_time(1))] [state_threshold] ["State / Threshold 3"] False False False False False False [start_time] [time4_split(0).Split({“:”},StringSplitOptions.None)] [starttime_hr] [CInt(start_time(0))] [starttime_mn] [CInt(start_time(1))] False False [end_time] [time4_split(1).Split({“:”},StringSplitOptions.None)] [endtime_mn] [CInt(end_time(1))] [state_threshold] State / Threshold 4 [freq] [CInt(frequency)] False False [completed_arg] 0 [completed] [CInt(completed_arg)] [tot] [freq-completed] True False False False True True True False False True False True False True False True False False False False False False True False False False False False True False True False True False True False True True False [mysql_query_name] [row.Item(0).ToString] [mysql_query_name] [mysql_query_name.TrimEnd] [mysql_query_name] [mysql_query_name.TrimStart] [mysql_query] [row.Item(1).ToString] [col_index] [sql_db_queries_data.Columns.IndexOf(customer)] [myexe_nonexe] [row.Item(col_index).ToString] True False True False False False True [add_row1] [report_build_table1.NewRow] False False [add_row] [report_build_table.NewRow] [add_row("S.No")] [sno] [add_row("Name")] [mysql_query_name] False False True False [add_row("Description")] ["Total buffer cache hit %."] False False [add_row("State / Threshold")] ["< 90%"] [add_row("State / Threshold")] ["< 85%"] True False [add_row("Description")] ["Check index status is valid."] False False [add_row("State / Threshold")] ["<>.Valid"] [add_row("State / Threshold")] ["<>.Valid"] True False [add_row("Description")] ["Daily Report"] False False [add_row("State / Threshold")] ["N/A"] [add_row("State / Threshold")] ["N/A"] True False [add_row("Description")] ["Check datafile is online."] False False [add_row("State / Threshold")] ["<> Online"] [add_row("State / Threshold")] ["<> Online"] True False [add_row("Description")] ["Name of tablespaces with low free space percentage."] True False [add_row("State / Threshold")] ["> 85%"] [add_row("State / Threshold")] ["> 80%"] True False [add_row("Description")] ["Check database instance availability status (1). "] True False [add_row("State / Threshold")] ["< 1"] [add_row("State / Threshold")] ["< 2"] True False [add_row("Description")] ["Monitors database resources utilization such as processes, sessions and  transactions."] True False [add_row("State / Threshold")] ["N/A"] [add_row("State / Threshold")] ["N/A"] True False [add_row("Description")] ["Number of sessions waiting for locks."] True False [add_row("State / Threshold")] [""] [add_row("State / Threshold")] [""] True False [add_row("Description")] ["Check for users whose default tablespace or temp tablespace is SYSTEM  tablespace."] True False [add_row("State / Threshold")] [">= 1"] [add_row("State / Threshold")] [">= 1"] True False [add_row("Description")] ["Check tablespace is online"] False False [add_row("State / Threshold")] ["<>Online"] [add_row("State / Threshold")] ["<>Online"] True False [add_row("Description")] ["Name of tablespaces with low free space percentage."] False False [add_row("State / Threshold")] ["<10%"] [add_row("State / Threshold")] ["<15%"] True False [add_row("Description")] ["Name of tablespaces with low free space percentage."] False False [add_row("State / Threshold")] [">85%"] [add_row("State / Threshold")] [">80%"] [add_row1] [report_build_table1.NewRow] [sno] [sno+1] False False True False True False True False False False False True True True False False False True False [buffer_hit_sev] [CDbl(sql_query_output.Rows(0)(2).ToString)] False False True [add_row1("Test")] [buffer_hit_sev] False False False False False False True False True False True False False False [summary] Buffer Hit Ratio is less than 90% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] True False True False False False True False [summary] Buffer Hit Ratio is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False [check_index] [sql_query_output.Rows(0)(0).ToString+":"+sql_query_output.Rows(0)(1).ToString+" "+ sql_query_output.Rows(1)(0).ToString+":"+sql_query_output.Rows(1)(1).ToString+" "+ sql_query_output.Rows(2)(0).ToString+":"+sql_query_output.Rows(2)(1).ToString+" "+ sql_query_output.Rows(3)(0).ToString+":"+sql_query_output.Rows(3)(1).ToString+" "+ sql_query_output.Rows(4)(0).ToString+":"+sql_query_output.Rows(4)(1).ToString] [add_row1("Test")] [check_index] False False True True False True False True False False False True False [summary] Buffer Hit Ratio is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False True False [summary] Buffer Hit Ratio is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False False False True False [sql_output_cnt] [sql_query_output.Rows.Count] [daily_user_login] [sql_query_output.Rows(0)(0).ToString+":"+sql_query_output.Rows(0)(1).ToString] True True [daily_user_login] [sql_query_output.Rows(inc)(0).ToString+":"+sql_query_output.Rows(inc)(3).ToString] [inc] [inc+1] False False False False [add_row1("Test")] [daily_user_login] False False True True False False False True False False False True False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] ["TIC16403"] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False True False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] ["TIC16403"] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False False False True False True True False True False False False [datafile_status] OFFLINE False False [summary] Datafile Status is Offline [customer] [summary] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L2"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] True False [datafile_status] ONLINE [add_row1("Test")] [datafile_status] True False True False False False True False [table_free_space] [sql_query_output.Rows(0)(0).ToString+" "+sql_query_output.Rows(0)(1).ToString+" "+sql_query_output.Rows(0)(1).ToString] [add_row1("Test")] [table_free_space] False False True True False False False True False True False False False [summary] Datafile Status is Offline [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False False False [summary] Datafile Status is Offline [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] True False False False True False False False [instance_availability] OFFLINE [add_row(state_threshold)] [instance_availability] False False [summary] Instance Availability is Offline [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L2"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] [instance_availability] ONLINE False False [add_row1("Test")] [instance_availability] False False False False [resorce_utilization] [sql_query_output.Rows(0)(3).ToString] [add_row1("Test")] [resorce_utilization] False False True True False False False True False False False False False [summary] resource threshold value is less than 90% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L2"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L2"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False False False [session_waiting] [sql_query_output.Rows(0)(1).ToString] [add_row1("Test")] [session_waiting] False False True True False False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False False False [system_tab_users] [sql_query_output.Rows(0)(0).ToString+" "+sql_query_output.Rows(0)(1).ToString+" "+sql_query_output.Rows(0)(2).ToString] [add_row1("Test")] [system_tab_users] False False True True False True False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False False False [tab_space_avail] [sql_query_output.Rows(0)(0).ToString+" "+sql_query_output.Rows(0)(1).ToString+" "+sql_query_output.Rows(0)(2).ToString] [add_row1("Test")] [tab_space_avail] False False True True False True False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False False False [table_free_space] [sql_query_output.Rows(0)(0).ToString+" "+sql_query_output.Rows(0)(1).ToString+" "+sql_query_output.Rows(0)(2).ToString] [add_row1("Test")] [table_free_space] False False True False False False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [inc] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] False False True False [table_free_space] [sql_query_output.Rows(0)(0).ToString+" "+sql_query_output.Rows(0)(1).ToString+" "+sql_query_output.Rows(0)(2).ToString] [add_row1("Test")] [table_free_space] False False True True False False False True False False False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] True False True False True False False False [summary] resource threshold value is less than 85% [customer] [summary] [subject] [incident_num] False False [weekely_row] [weekely_report_table.NewRow] [weekely_row("S.No")] [tic_nums+1] [tic_nums] [tic_nums+1] [weekely_row("Client")] [customer] [weekely_row("INCIDENT")] [incident_num] [weekely_row("Ticket Type")] ["L1"] [weekely_row("Description")] [mysql_query_name] [weekely_row("Sibelco Ticket Assigned Time")] [Now.ToString] True False True False True False False True False True False True False True False False False False False True True False True False False False True False False False True False True False True False True False False False False False True False False False True False True False True False False False True False False False True False True False False False True False True False True False False False True False False False True False False False True False True False True False False False True False True False False False True False True False True False False False True False False False True False False False True False False False True False False False True False True False True False True False True False True False True False True False True False True False False False False False True False False False True False True False True False [completed] [completed+1] True False False False False True False True False False [3] ["L1"] True [3] ["L2"] True [3] ["L3"] True False False False False True False False