Hi there, When reviewing Splunk events, some events display as below, it splits following text into two events; the second event has no datetime at the beginning, and the log is from log4net with datetime. ... FROM dbo.History202011 as QueryHistory
Inner Join TmpQueryHistoryFilter tf on (QueryHistory.Email = tf.Email or tf.Email is null)
WHERE date >= '2020-11-11' AND date <= '2020-11-12' AND (CreationDate BETWEEN '2020-11-11 16:00' AND '2020-11-12 16:00') AND QueryTypeID IN (1,4) AND CompanyID = 42
Order by QueryHistoryId
offset 0 Limit 20
) A CROSS JOIN TotalQueries B WHERE date >= '2020-11-11' AND date <= '2020-11-12' AND (CreationDate BETWEEN '2020-11-11 16:00' AND '2020-11-12 16:00') AND QueryTypeID IN (1,4) AND CompanyID = 1000
GROUP BY QueryHistory.StatusID, QueryHistory.QueryFromId
,QueryHistory.QueryTypeID
,CASE WHEN QueryHistory.EAScore >=900 THEN 1... When show source, it likes this: Any thought? Thanks,
... View more