Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-16"?>
- <ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.50.6000.34" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">
- <BatchSequence>
- <Batch>
- <Statements>
- <StmtSimple StatementCompId="1" StatementId="1" StatementText="Declare @Date1 datetime 
Declare @Date2 datetime 
 
select @Date1 =cast(replace(convert(varchar,getdate()-7,102),'.','-') + ' 00:00:00.000' as datetime) 
--print @Date1 
" StatementType="ASSIGN" />
- </Statements>
- <Statements>
- <StmtSimple StatementCompId="2" StatementId="2" StatementText="
select @Date2 =cast(replace(convert(varchar,getdate()-1,102),'.','-') + ' 23:59:59.000' as datetime) 
--print @Date2 
 
" StatementType="ASSIGN" />
- </Statements>
- <Statements>
- <StmtSimple StatementCompId="3" StatementEstRows="1" StatementId="3" StatementOptmLevel="FULL" StatementSubTreeCost="123.17" StatementText="
select a.ticket_number,a.type,a.parent,a.summary,a.open_date, 
CASE CAST((CONVERT(VARCHAR(10),(DATEDIFF(DAY,GETDATE()-21,a.OPEN_DATE)/7)+1)) AS INT) 
 WHEN 3 THEN 'Current' 
 ELSE 'Previous' 
 END as 'Open in Current / Previous week', 
a.last_mod_date,a.resolve_date,a.close_date,a.ass_group, 
 a.opened_by,a.assignee,a.end_user,a.requestor,a.priority,a.ticket_status,a.urgency,a.category,a.SLA_violation,a.CI, 
 a.others,a.rootcause,e.[Apps / Infra],e.[BU / Tower],e.[L1 / L2 / L3],e.Owner,e.[SDP Group Name],e.Service,e.[Sub BU / Tower],e.[TCS / Non-TCS], 
(dateadd(ss,(c.time_stamp),'1970-01-01')) as Child_ticket_tag_date, 
'week'+convert(varchar(10),(DATEDIFF(day,GETDATE()-21,DATEADD(ss, ((c.time_stamp)),'1970-01-01'))/7)+1) as weeknum, 
c.action_desc 
into #main 
from current_ticket_details (nolock) as a join SDP_Master_apps (nolock) e on a.ass_group=e.[SDP Group Name] 
left join Call_Req (nolock) as b on a.ticket_number = b.ref_num 
left join act_log c (nolock) on b.persid = c.call_req_id 
where DATEADD(ss, ((c.time_stamp)),'1970-01-01') between @Date1 and @Date2 
and (c.action_desc LIKE '%PARENT%' ) 
and a.assignee not in (select email_id from mail_details where frequency = 'ALL' and tower = 'APPS' and parm_name = 'exclusion_list') 
and a.type in ('I','R','CO') 
and a.ticket_status not in ('test','cancelled') 
and a.parent is not NULL 
order by c.time_stamp 
" StatementType="SELECT INTO" QueryHash="0xF20175EA82CD7D7F" QueryPlanHash="0x0F9A6378ECF81765">
- <StatementSetOptions ANSI_NULLS="true" ANSI_PADDING="true" ANSI_WARNINGS="true" ARITHABORT="true" CONCAT_NULL_YIELDS_NULL="true" NUMERIC_ROUNDABORT="false" QUOTED_IDENTIFIER="true" />
- <QueryPlan CachedPlanSize="280" CompileTime="1989" CompileCPU="430" CompileMemory="4000">
- <RelOp AvgRowSize="9" EstimateCPU="1E-06" EstimateIO="0.01" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Insert" NodeId="0" Parallel="false" PhysicalOp="Table Insert" EstimatedTotalSubtreeCost="123.17">
- <OutputList />
- <Update DMLRequestSort="false">
- <Object Table="[#main]" />
- <SetPredicate>
- <ScalarOperator ScalarString="[#main].[ticket_number] = [Reporting].[dbo].[current_ticket_details].[ticket_number] as [a].[ticket_number],[#main].[type] = [Reporting].[dbo].[current_ticket_details].[type] as [a].[type],[#main].[parent] = [Reporting].[dbo].[current_ticket_details].[parent] as [a].[parent],[#main].[summary] = [Reporting].[dbo].[current_ticket_details].[summary] as [a].[summary],[#main].[open_date] = [Reporting].[dbo].[current_ticket_details].[open_date] as [a].[open_date],[#main].[Open in Current / Previous week] = [Expr1020],[#main].[last_mod_date] = [Reporting].[dbo].[current_ticket_details].[last_mod_date] as [a].[last_mod_date],[#main].[resolve_date] = [Reporting].[dbo].[current_ticket_details].[resolve_date] as [a].[resolve_date],[#main].[close_date] = [Reporting].[dbo].[current_ticket_details].[close_date] as [a].[close_date],[#main].[ass_group] = [Reporting].[dbo].[current_ticket_details].[ass_group] as [a].[ass_group],[#main].[opened_by] = [Reporting].[dbo].[current_ticket_details].[opened_by] as [a].[opened_by],[#main].[assignee] = [Reporting].[dbo].[current_ticket_details].[assignee] as [a].[assignee],[#main].[end_user] = [Reporting].[dbo].[current_ticket_details].[end_user] as [a].[end_user],[#main].[requestor] = [Reporting].[dbo].[current_ticket_details].[requestor] as [a].[requestor],[#main].[priority] = [Reporting].[dbo].[current_ticket_details].[priority] as [a].[priority],[#main].[ticket_status] = [Reporting].[dbo].[current_ticket_details].[ticket_status] as [a].[ticket_status],[#main].[urgency] = [Reporting].[dbo].[current_ticket_details].[urgency] as [a].[urgency],[#main].[category] = [Reporting].[dbo].[current_ticket_details].[category] as [a].[category],[#main].[SLA_violation] = [Reporting].[dbo].[current_ticket_details].[SLA_violation] as [a].[SLA_violation],[#main].[CI] = [Reporting].[dbo].[current_ticket_details].[CI] as [a].[CI],[#main].[others] = [Reporting].[dbo].[current_ticket_details].[Others] as [a].[Others],[#main].[rootcause] = [Reporting].[dbo].[current_ticket_details].[rootcause] as [a].[rootcause],[#main].[Apps / Infra] = [Reporting].[dbo].[SDP_master_Apps].[Apps / Infra] as [e].[Apps / Infra],[#main].[BU / Tower] = [Reporting].[dbo].[SDP_master_Apps].[BU / Tower] as [e].[BU / Tower],[#main].[L1 / L2 / L3] = [Reporting].[dbo].[SDP_master_Apps].[L1 / L2 / L3] as [e].[L1 / L2 / L3],[#main].[Owner] = [Reporting].[dbo].[SDP_master_Apps].[Owner] as [e].[Owner],[#main].[SDP Group Name] = [Reporting].[dbo].[SDP_master_Apps].[SDP Group Name] as [e].[SDP Group Name],[#main].[Service] = [Reporting].[dbo].[SDP_master_Apps].[Service] as [e].[Service],[#main].[Sub BU / Tower] = [Reporting].[dbo].[SDP_master_Apps].[Sub BU / Tower] as [e].[Sub BU / Tower],[#main].[TCS / Non-TCS] = [Reporting].[dbo].[SDP_master_Apps].[TCS / Non-TCS] as [e].[TCS / Non-TCS],[#main].[Child_ticket_tag_date] = [Expr1021],[#main].[weeknum] = [Expr1022],[#main].[action_desc] = [mdb].[dbo].[act_log].[action_desc]">
- <ScalarExpressionList>
- <ScalarOperator>
- <MultipleAssign>
- <Assign>
- <ColumnReference Table="[#main]" Column="ticket_number" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="type" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="parent" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="summary" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="open_date" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="Open in Current / Previous week" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1020" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="last_mod_date" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="resolve_date" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="close_date" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="ass_group" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="opened_by" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="assignee" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="end_user" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="requestor" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="priority" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="ticket_status" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="urgency" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="category" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="SLA_violation" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="CI" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="others" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="rootcause" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="Apps / Infra" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="BU / Tower" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="L1 / L2 / L3" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="Owner" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="SDP Group Name" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="Service" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="Sub BU / Tower" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="TCS / Non-TCS" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="Child_ticket_tag_date" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1021" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="weeknum" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1022" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- <Assign>
- <ColumnReference Table="[#main]" Column="action_desc" />
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- </Identifier>
- </ScalarOperator>
- </Assign>
- </MultipleAssign>
- </ScalarOperator>
- </ScalarExpressionList>
- </ScalarOperator>
- </SetPredicate>
- <RelOp AvgRowSize="2996" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="1" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="123.16">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- <ColumnReference Column="Expr1020" />
- <ColumnReference Column="Expr1021" />
- <ColumnReference Column="Expr1022" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1020" />
- <ScalarOperator ScalarString="CASE WHEN CONVERT(int,CONVERT(varchar(10),datediff(day,getdate()-'1900-01-22 00:00:00.000',[Reporting].[dbo].[current_ticket_details].[open_date] as [a].[open_date])/(7)+(1),0),0)=(3) THEN 'Current' ELSE 'Previous' END">
- <IF>
- <Condition>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Convert DataType="int" Style="0" Implicit="false">
- <ScalarOperator>
- <Convert DataType="varchar" Length="10" Style="0" Implicit="false">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="DIV">
- <ScalarOperator>
- <Intrinsic FunctionName="datediff">
- <ScalarOperator>
- <Const ConstValue="(4)" />
- </ScalarOperator>
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1023">
- <ScalarOperator>
- <Intrinsic FunctionName="getdate" />
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'1900-01-22 00:00:00.000'" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(7)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(3)" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Condition>
- <Then>
- <ScalarOperator>
- <Const ConstValue="'Current'" />
- </ScalarOperator>
- </Then>
- <Else>
- <ScalarOperator>
- <Const ConstValue="'Previous'" />
- </ScalarOperator>
- </Else>
- </IF>
- </ScalarOperator>
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Column="Expr1022" />
- <ScalarOperator ScalarString="'week'+CONVERT(varchar(10),datediff(day,getdate()-'1900-01-22 00:00:00.000',[Expr1021])/(7)+(1),0)">
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Const ConstValue="'week'" />
- </ScalarOperator>
- <ScalarOperator>
- <Convert DataType="varchar" Length="10" Style="0" Implicit="false">
- <ScalarOperator>
- <Arithmetic Operation="ADD">
- <ScalarOperator>
- <Arithmetic Operation="DIV">
- <ScalarOperator>
- <Intrinsic FunctionName="datediff">
- <ScalarOperator>
- <Const ConstValue="(4)" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="ConstExpr1024">
- <ScalarOperator>
- <Arithmetic Operation="SUB">
- <ScalarOperator>
- <Intrinsic FunctionName="getdate" />
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'1900-01-22 00:00:00.000'" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </ColumnReference>
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1021" />
- </Identifier>
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(7)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="(1)" />
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </Arithmetic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="2980" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Top" NodeId="2" Parallel="false" PhysicalOp="Top" EstimatedTotalSubtreeCost="123.16">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- <ColumnReference Column="Expr1021" />
- </OutputList>
- <Top RowCount="true" IsPercent="false" WithTies="false">
- <TopExpression>
- <ScalarOperator ScalarString="(0)">
- <Const ConstValue="(0)" />
- </ScalarOperator>
- </TopExpression>
- <RelOp AvgRowSize="2984" EstimateCPU="0.000102984" EstimateIO="0.0112613" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Sort" NodeId="3" Parallel="false" PhysicalOp="Sort" EstimatedTotalSubtreeCost="123.16">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- <ColumnReference Column="Expr1021" />
- </OutputList>
- <MemoryFractions Input="0.00399202" Output="1" />
- <Sort Distinct="false">
- <OrderBy>
- <OrderByColumn Ascending="true">
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- </OrderByColumn>
- </OrderBy>
- <RelOp AvgRowSize="2984" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="4" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="123.149">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- <ColumnReference Column="Expr1021" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1021" />
- <ScalarOperator ScalarString="dateadd(second,[mdb].[dbo].[act_log].[time_stamp],'1970-01-01 00:00:00.000')">
- <Intrinsic FunctionName="dateadd">
- <ScalarOperator>
- <Const ConstValue="(8)" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'1970-01-01 00:00:00.000'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="2976" EstimateCPU="0.000314626" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Filter" NodeId="5" Parallel="false" PhysicalOp="Filter" EstimatedTotalSubtreeCost="123.149">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- </OutputList>
- <Filter StartupExpression="false">
- <RelOp AvgRowSize="2976" EstimateCPU="0.000603274" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="144.324" LogicalOp="Inner Join" NodeId="6" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="123.148">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- </OutputList>
- <NestedLoops Optimized="true" WithUnorderedPrefetch="true">
- <OuterReferences>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="id" />
- <ColumnReference Column="Expr1029" />
- </OuterReferences>
- <RelOp AvgRowSize="2910" EstimateCPU="0.000603274" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="144.324" LogicalOp="Inner Join" NodeId="9" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="123.087">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="id" />
- </OutputList>
- <NestedLoops Optimized="true">
- <OuterReferences>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="persid" />
- </OuterReferences>
- <RelOp AvgRowSize="2928" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="11" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="123.083">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="persid" />
- </OutputList>
- <NestedLoops Optimized="true">
- <OuterReferences>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="id" />
- </OuterReferences>
- <RelOp AvgRowSize="2910" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Inner Join" NodeId="13" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="123.08">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="id" />
- </OutputList>
- <NestedLoops Optimized="true">
- <OuterReferences>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- </OuterReferences>
- <RelOp AvgRowSize="2906" EstimateCPU="4.18E-06" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Anti Semi Join" NodeId="15" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="123.077">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- </OutputList>
- <NestedLoops Optimized="false">
- <Predicate>
- <ScalarOperator ScalarString="[Reporting].[dbo].[current_ticket_details].[assignee] as [a].[assignee]=[Expr1027]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="Expr1027" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Predicate>
- <RelOp AvgRowSize="2906" EstimateCPU="0.101682" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Left Anti Semi Join" NodeId="16" Parallel="false" PhysicalOp="Nested Loops" EstimatedTotalSubtreeCost="123.071">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- </OutputList>
- <NestedLoops Optimized="false">
- <RelOp AvgRowSize="2906" EstimateCPU="1.0479" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="24325.7" LogicalOp="Inner Join" NodeId="17" Parallel="false" PhysicalOp="Hash Match" EstimatedTotalSubtreeCost="120.529">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- </OutputList>
- <MemoryFractions Input="1" Output="0.878244" />
- <Hash>
- <DefinedValues />
- <HashKeysBuild>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- </HashKeysBuild>
- <HashKeysProbe>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- </HashKeysProbe>
- <ProbeResidual>
- <ScalarOperator ScalarString="[Reporting].[dbo].[current_ticket_details].[ass_group] as [a].[ass_group]=[Reporting].[dbo].[SDP_master_Apps].[SDP Group Name] as [e].[SDP Group Name]">
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </ProbeResidual>
- <RelOp AvgRowSize="1856" EstimateCPU="0.0004837" EstimateIO="0.00831019" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="297" LogicalOp="Table Scan" NodeId="18" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00879389" TableCardinality="297">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- </OutputList>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="SDP Group Name" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Apps / Infra" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="BU / Tower" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Sub BU / Tower" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="L1 / L2 / L3" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Service" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="Owner" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" Column="TCS / Non-TCS" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Reporting]" Schema="[dbo]" Table="[SDP_master_Apps]" Alias="[e]" IndexKind="Heap" />
- </TableScan>
- </RelOp>
- <RelOp AvgRowSize="1058" EstimateCPU="2.40851" EstimateIO="112.291" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="90546.7" LogicalOp="Clustered Index Scan" NodeId="19" Parallel="false" PhysicalOp="Clustered Index Scan" EstimatedTotalSubtreeCost="114.699" TableCardinality="2189410">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- </OutputList>
- <IndexScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="summary" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="open_date" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="last_mod_date" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="resolve_date" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="close_date" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ass_group" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="opened_by" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="assignee" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="end_user" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="requestor" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="priority" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="urgency" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="category" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="SLA_violation" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="CI" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="Others" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="rootcause" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Index="[PK_CTD_TicketNum]" Alias="[a]" IndexKind="Clustered" />
- <Predicate>
- <ScalarOperator ScalarString="[Reporting].[dbo].[current_ticket_details].[ticket_status] as [a].[ticket_status]<>N'cancelled' AND [Reporting].[dbo].[current_ticket_details].[ticket_status] as [a].[ticket_status]<>N'test' AND [Reporting].[dbo].[current_ticket_details].[parent] as [a].[parent] IS NOT NULL AND ([Reporting].[dbo].[current_ticket_details].[type] as [a].[type]=N'CO' OR [Reporting].[dbo].[current_ticket_details].[type] as [a].[type]=N'I' OR [Reporting].[dbo].[current_ticket_details].[type] as [a].[type]=N'R')">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'cancelled'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="NE">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_status" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'test'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="IS NOT">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="parent" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Logical Operation="OR">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'CO'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'I'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="type" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'R'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </Hash>
- </RelOp>
- <RelOp AvgRowSize="9" EstimateCPU="0.0001001" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="24324.7" EstimateRows="1" LogicalOp="Lazy Spool" NodeId="21" Parallel="false" PhysicalOp="Row Count Spool" EstimatedTotalSubtreeCost="2.44064">
- <OutputList />
- <RowCountSpool>
- <RelOp AvgRowSize="372" EstimateCPU="0.000212" EstimateIO="0.00534722" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table Scan" NodeId="23" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00555922" TableCardinality="50">
- <OutputList />
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues />
- <Object Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" IndexKind="Heap" />
- <Predicate>
- <ScalarOperator ScalarString="[Reporting].[dbo].[mail_details].[frequency]='ALL' AND [Reporting].[dbo].[mail_details].[tower]='APPS' AND [Reporting].[dbo].[mail_details].[parm_name]='exclusion_list' AND CONVERT_IMPLICIT(nvarchar(2000),[Reporting].[dbo].[mail_details].[email_id],0) IS NULL">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="frequency" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'ALL'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="tower" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'APPS'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="parm_name" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'exclusion_list'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="IS">
- <ScalarOperator>
- <Convert DataType="nvarchar" Length="4000" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="email_id" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="NULL" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </TableScan>
- </RelOp>
- </RowCountSpool>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="345" EstimateCPU="1E-07" EstimateIO="0" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Compute Scalar" NodeId="25" Parallel="false" PhysicalOp="Compute Scalar" EstimatedTotalSubtreeCost="0.00561832">
- <OutputList>
- <ColumnReference Column="Expr1027" />
- </OutputList>
- <ComputeScalar>
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Column="Expr1027" />
- <ScalarOperator ScalarString="CONVERT_IMPLICIT(nvarchar(2000),[Reporting].[dbo].[mail_details].[email_id],0)">
- <Convert DataType="nvarchar" Length="4000" Style="0" Implicit="true">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="email_id" />
- </Identifier>
- </ScalarOperator>
- </Convert>
- </ScalarOperator>
- </DefinedValue>
- </DefinedValues>
- <RelOp AvgRowSize="372" EstimateCPU="0.000212" EstimateIO="0.00534722" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Table Scan" NodeId="26" Parallel="false" PhysicalOp="Table Scan" EstimatedTotalSubtreeCost="0.00555922" TableCardinality="50">
- <OutputList>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="email_id" />
- </OutputList>
- <TableScan Ordered="false" ForcedIndex="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="email_id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" IndexKind="Heap" />
- <Predicate>
- <ScalarOperator ScalarString="[Reporting].[dbo].[mail_details].[frequency]='ALL' AND [Reporting].[dbo].[mail_details].[tower]='APPS' AND [Reporting].[dbo].[mail_details].[parm_name]='exclusion_list'">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="frequency" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'ALL'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="tower" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'APPS'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="EQ">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[mail_details]" Column="parm_name" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'exclusion_list'" />
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </TableScan>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Index Seek" NodeId="31" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="883450">
- <OutputList>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="id" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[mdb]" Schema="[dbo]" Table="[call_req]" Index="[call_req_x3]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="ref_num" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[Reporting].[dbo].[current_ticket_details].[ticket_number] as [a].[ticket_number]">
- <Identifier>
- <ColumnReference Database="[Reporting]" Schema="[dbo]" Table="[current_ticket_details]" Alias="[a]" Column="ticket_number" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="41" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="33" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="883450">
- <OutputList>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="persid" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="persid" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[mdb]" Schema="[dbo]" Table="[call_req]" Index="[XPKcall_req]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[mdb].[dbo].[call_req].[id]">
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="11" EstimateCPU="0.000315756" EstimateIO="0.003125" EstimateRebinds="0" EstimateRewinds="0" EstimateRows="144.324" LogicalOp="Index Seek" NodeId="37" Parallel="false" PhysicalOp="Index Seek" EstimatedTotalSubtreeCost="0.00344076" TableCardinality="14367000">
- <OutputList>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="id" />
- </OutputList>
- <IndexScan Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="id" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[mdb]" Schema="[dbo]" Table="[act_log]" Index="[act_log_x0]" IndexKind="NonClustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="call_req_id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[mdb].[dbo].[call_req].[persid]">
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[call_req]" Column="persid" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <RelOp AvgRowSize="79" EstimateCPU="0.0001581" EstimateIO="0.003125" EstimateRebinds="132.311" EstimateRewinds="11.0135" EstimateRows="1" LogicalOp="Clustered Index Seek" NodeId="39" Parallel="false" PhysicalOp="Clustered Index Seek" EstimatedTotalSubtreeCost="0.0603593" TableCardinality="14367000">
- <OutputList>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- </OutputList>
- <IndexScan Lookup="true" Ordered="true" ScanDirection="FORWARD" ForcedIndex="false" ForceSeek="false" ForceScan="false" NoExpandHint="false">
- <DefinedValues>
- <DefinedValue>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- </DefinedValue>
- <DefinedValue>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- </DefinedValue>
- </DefinedValues>
- <Object Database="[mdb]" Schema="[dbo]" Table="[act_log]" Index="[XPKact_log]" TableReferenceId="-1" IndexKind="Clustered" />
- <SeekPredicates>
- <SeekPredicateNew>
- <SeekKeys>
- <Prefix ScanType="EQ">
- <RangeColumns>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="id" />
- </RangeColumns>
- <RangeExpressions>
- <ScalarOperator ScalarString="[mdb].[dbo].[act_log].[id]">
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="id" />
- </Identifier>
- </ScalarOperator>
- </RangeExpressions>
- </Prefix>
- </SeekKeys>
- </SeekPredicateNew>
- </SeekPredicates>
- <Predicate>
- <ScalarOperator ScalarString="dateadd(second,[mdb].[dbo].[act_log].[time_stamp],'1970-01-01 00:00:00.000')>=[@Date1] AND dateadd(second,[mdb].[dbo].[act_log].[time_stamp],'1970-01-01 00:00:00.000')<=[@Date2]">
- <Logical Operation="AND">
- <ScalarOperator>
- <Compare CompareOp="GE">
- <ScalarOperator>
- <Intrinsic FunctionName="dateadd">
- <ScalarOperator>
- <Const ConstValue="(8)" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'1970-01-01 00:00:00.000'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@Date1" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- <ScalarOperator>
- <Compare CompareOp="LE">
- <ScalarOperator>
- <Intrinsic FunctionName="dateadd">
- <ScalarOperator>
- <Const ConstValue="(8)" />
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="time_stamp" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="'1970-01-01 00:00:00.000'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- <ScalarOperator>
- <Identifier>
- <ColumnReference Column="@Date2" />
- </Identifier>
- </ScalarOperator>
- </Compare>
- </ScalarOperator>
- </Logical>
- </ScalarOperator>
- </Predicate>
- </IndexScan>
- </RelOp>
- </NestedLoops>
- </RelOp>
- <Predicate>
- <ScalarOperator ScalarString="[mdb].[dbo].[act_log].[action_desc] like N'%PARENT%'">
- <Intrinsic FunctionName="like">
- <ScalarOperator>
- <Identifier>
- <ColumnReference Database="[mdb]" Schema="[dbo]" Table="[act_log]" Column="action_desc" />
- </Identifier>
- </ScalarOperator>
- <ScalarOperator>
- <Const ConstValue="N'%PARENT%'" />
- </ScalarOperator>
- </Intrinsic>
- </ScalarOperator>
- </Predicate>
- </Filter>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Sort>
- </RelOp>
- </Top>
- </RelOp>
- </ComputeScalar>
- </RelOp>
- </Update>
- </RelOp>
- </QueryPlan>
- </StmtSimple>
- </Statements>
- </Batch>
- </BatchSequence>
- </ShowPlanXML>
Add Comment
Please, Sign In to add comment