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