/// <summary> /// Processes a Context event and send the result to the next block /// </summary> /// <param name="text">Event data</param> /// <param name="targetBlock">Next block</param> /// <returns></returns> private async Task ProcessContextEvent(string text, ITargetBlock <string> targetBlock) { var clientId = await TlHelper.GetPropertyValue(text, Logcfg.CLIENT_ID_PR); // If "client id" property is empty then it`s a system call, such event skipping if (clientId == string.Empty) { return; } var dateTime = await TlHelper.GetPropertyValue(text, Logcfg.DATETIME_PR); var context = await TlHelper.GetPropertyValue(text, Logcfg.CONTEXT_PR); var firstLineContext = await TlHelper.GetFirstLineContext(context); var lastLineContext = await TlHelper.GetLastLineContext(context); var user = await TlHelper.GetPropertyValue(text, Logcfg.USER_PR); var connectId = await TlHelper.GetPropertyValue(text, Logcfg.CONNECT_ID_PR); var data = Common.FS + dateTime + Common.FS + user + Common.FS + connectId + Common.FS + clientId + Common.FS + firstLineContext + Common.FS + lastLineContext + Common.RS; await targetBlock.SendAsync(data); }
/// <summary> /// Processes a DBMSSQL event and send the result to the next block /// </summary> /// <param name="text">Event data</param> /// <param name="targetBlock">Next block</param> /// <returns></returns> private async Task ProcessDbmssqlEvent(string text, ITargetBlock <string> targetBlock) { var user = await TlHelper.GetPropertyValue(text, Logcfg.USER_PR); // If "usr" property is empty then skip this event if (user == string.Empty) { return; } var sql = await TlHelper.GetPropertyValue(text, Logcfg.SQL_PR); // If "sql" property is empty then skip this event if (sql == string.Empty) { return; } var clientId = await TlHelper.GetPropertyValue(text, Logcfg.CLIENT_ID_PR); // If "client id" property is empty then it`s a system call, such event skipping if (clientId == string.Empty) { return; } var clearedSql = await TlHelper.CleanSql(sql); var normalizedSql = await Common.GetNormalizedSql(clearedSql); var hash = await Common.GetMD5Hash(normalizedSql); var dateTime = await TlHelper.GetPropertyValue(text, Logcfg.DATETIME_PR); var context = await TlHelper.GetPropertyValue(text, Logcfg.CONTEXT_PR); var firstLine = await TlHelper.GetFirstLineContext(context); var lastLine = await TlHelper.GetLastLineContext(context); var connectId = await TlHelper.GetPropertyValue(text, Logcfg.CONNECT_ID_PR); var contextExists = firstLine.Length == 0 ? 0 : 1; var data = Common.FS + dateTime + Common.FS + user + Common.FS + connectId + Common.FS + clientId + Common.FS + sql + Common.FS + normalizedSql + Common.FS + firstLine + Common.FS + lastLine + Common.FS + contextExists + Common.FS + hash + Common.RS; await targetBlock.SendAsync(data); }