Logs_General

Definition

CREATE   VIEW
  [adm].[Logs_General] AS
SELECT
  [v].[Created] [Event_Time],
  'CHANGE_LOG' [Event_Source],
  REPLACE(
    REPLACE([opt].[Name], 'enum.operation.type.', ''),
    '.name',
    ''
  ) [Record_Type],
  REPLACE(
    REPLACE([lt].[Name_Key], 'changelog.type.', ''),
    '.name',
    ''
  ) [Event_Type],
  'User' [Initiated_By],
  [u].[Login] [User],
  CAST([l].[Change_Log_Id] AS VARCHAR(10)) [Event_Identificator],
  'Change_Log_Id' [Event_Identificator_Description],
  [l].[New_Value] [Key_Words],
  'INFO' [Event_Category],
  NEWID() [Correlator]
FROM
  [dbo].[MR_Change_Log] [l]
  LEFT JOIN [dbo].[MR_Version] v ON v.Version_Id = l.Version_Id
  JOIN [dbo].[C_Change_Log_Type] [lt]  ON [lt].[Change_Log_Type_Id] = [l].[Change_Log_Type_Id]
  JOIN [dbo].[APP_Operation_Type] [opt]  ON [opt].[Operation_Type_Id] = [lt].[Operation_Type_Id]
  LEFT JOIN [dbo].[APP_User] [u]  ON [u].[User_Id] = [v].Creator_Id
UNION ALL
SELECT
  [l].[Accessed_Date] [Event_Time],
  'USER_BEHAVIOR' [Event_Source],
  'Visited_Url' [Record_Type],
  'from_url_to_url' [Event_Type],
  'User' [Initiated_By],
  [u].[Login] [User],
  CAST([l].[Visited_Url_Id] AS VARCHAR(10)) [Event_Identificator],
  'Visited_Url_Id' [Event_Identificator_Description],
  ISNULL(l.[From_Url] + ' => ', '') + ISNULL(l.[To_Url], ''),
  'INFO' [Event_Category],
  NEWID() [Correlator]
FROM
  ub.[Visited_Url] l
  LEFT JOIN [dbo].[APP_User] [u]  ON [u].[User_Id] = [l].[User_Id]

Columns

#	Column	Data Type	Nullable	Source
1	Event_Time	datetime2	Yes	MR_Version.Created, Visited_Url.Accessed_Date
2	Event_Source	varchar	No
3	Record_Type	nvarchar	Yes	APP_Operation_Type.Name
4	Event_Type	nvarchar	Yes	C_Change_Log_Type.Name_Key
5	Initiated_By	varchar	No
6	User	nvarchar	Yes	APP_User.Login
7	Event_Identificator	varchar	Yes	MR_Change_Log.Change_Log_Id, Visited_Url.Visited_Url_Id
8	Event_Identificator_Description	varchar	No
9	Key_Words	nvarchar	Yes	MR_Change_Log.New_Value, Visited_Url.To_Url, Visited_Url.From_Url
10	Event_Category	varchar	No
11	Correlator	uniqueidentifier	Yes

graph LR
  n1545["Logs_General"]
  n1251["MR_Version"]
  n1254["MR_Change_Log"]
  n1263["C_Change_Log_Type"]
  n1272["APP_Operation_Type"]
  n1288["APP_User"]
  n1551["Visited_Url"]
  n1268["UB_Visited_Url"]
  n1251 --> n1545
  n1254 --> n1545
  n1263 --> n1545
  n1272 --> n1545
  n1288 --> n1545
  n1551 --> n1545
  n1268 --> n1551
  style n1545 fill:#00A081,stroke:#008068,color:#fff
  click n1545 href "/actual/logsgeneral/"
  click n1251 href "/actual/mrversion/"
  click n1254 href "/actual/mrchangelog/"
  click n1263 href "/actual/cchangelogtype/"
  click n1272 href "/actual/appoperationtype/"
  click n1288 href "/actual/appuser/"
  click n1551 href "/actual/visitedurl/"
  click n1268 href "/actual/ubvisitedurl/"