logs.ExecutionLog_gross - V
type: V ( view ), modify_date: 2022-06-30 17:01:04
RepoObject_guid: BB90291C-9D61-EB11-84DC-A81E8446D5B0
Examples
--get detailed PlantUML sequence diagram
--you could add skinparam to modify it, for example
--skinparam maxmessagesize 250
Select
id
, puml_Sequence
, execution_instance_guid
, parent_execution_log_id
, proc_schema_name
, proc_name
, step_id
, step_name
, created_dt
, source_object
, target_object
, inserted
, updated
, deleted
From
logs.ExecutionLog_gross
Where
id
Between 33386 And 33404
Order By
id;
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
_
sql_modules_definition
logs.ExecutionLog_gross - V script
/*
<<property_start>>exampleUsage
--get detailed PlantUML sequence diagram
--you could add skinparam to modify it, for example
--skinparam maxmessagesize 250
Select
id
, puml_Sequence
, execution_instance_guid
, parent_execution_log_id
, proc_schema_name
, proc_name
, step_id
, step_name
, created_dt
, source_object
, target_object
, inserted
, updated
, deleted
From
logs.ExecutionLog_gross
Where
id
Between 33386 And 33404
Order By
id;
<<property_end>>
*/
CREATE View [logs].[ExecutionLog_gross]
As
Select
id
, parent_execution_log_id
, duration_current_execution_guid = DateDiff (
ss
, Min ( created_dt ) Over ( Partition By current_execution_guid )
, Max ( created_dt ) Over ( Partition By current_execution_guid )
)
, duration_execution_instance_guid = DateDiff (
ss
, Min ( created_dt ) Over ( Partition By execution_instance_guid )
, Max ( created_dt ) Over ( Partition By execution_instance_guid )
)
, duration_step = Iif(Not step_name In ( 'start', 'end' )
, DateDiff ( ss, Lag ( created_dt ) Over ( Order By id ), created_dt )
, Null)
, created_dt
, proc_schema_name
, proc_name
, step_id
, step_name
, inserted
, updated
, deleted
, source_object
, target_object
, execution_instance_guid
, ssis_execution_id
, sub_execution_id
, current_execution_guid
, proc_id
, info_01
, info_02
, info_03
, info_04
, info_05
, info_06
, info_07
, info_08
, info_09
, event_info
, parameter_01
, parameter_02
, parameter_03
, parameter_04
, parameter_05
, parameter_06
, parameter_07
, parameter_08
, parameter_09
, parameter_10
, parameter_11
, parameter_12
, parameter_13
, parameter_14
, parameter_15
, parameter_16
, parameter_17
, parameter_18
, parameter_19
, parameter_20
--
, created_dt_min_execution_instance_guid = Min ( created_dt ) Over ( Partition By execution_instance_guid )
, created_dt_max_execution_instance_guid = Max ( created_dt ) Over ( Partition By execution_instance_guid )
--
, puml_Sequence = --
--combine the result with
--skinparam maxmessagesize 250
Case
When source_object Is Null
And target_object Is Null
Then
Concat (
Char ( 13 ) + Char ( 10 )
, '== '
, concat(quotename([proc_schema_name]),'.',quotename([proc_name])) --proc_fullname
, ' - '
, step_name
, ' =='
, Char ( 13 ) + Char ( 10 )
, Char ( 13 ) + Char ( 10 )
)
Else
Concat (
--
Case
When Not source_object Is Null
Then
QuoteName ( source_object, '"' )
End
, Case
When Not inserted Is Null
Then
Case
When source_object Is Null
Then
'?-> '
Else
' -> '
End
When Not updated Is Null
Then
Case
When source_object Is Null
Then
'?->o '
Else
' ->O '
End
When Not deleted Is Null
Then
Case
When source_object Is Null
Then
'?->x '
Else
' ->x '
End
Else
Case
When source_object Is Null
Then
'?--> '
Else
' --> '
End
End
, Case
When Not target_object Is Null
Then
QuoteName ( target_object, '"' )
End
--
--, ' : ' , QUOTENAME([step_name] , '"')
, ' : '
, step_name
, Char ( 13 ) + Char ( 10 )
-- "r" - rectangle note
, 'rnote right:'
, Coalesce ( inserted, updated, deleted )
--
)
End
From
logs.ExecutionLog