DECLARE @filename VARCHAR(500) 
SELECT @filename = SUBSTRING(path, 0,LEN(path) - CHARINDEX('\',REVERSE(path)) + 1)+ '\Log.trc'
	FROM sys.traces
	WHERE is_default = 1 ;

SELECT
  te.Name AS EventName
  ,tsv.subclass_name AS SubEventName
  ,StartTime
  ,LoginName
  ,SessionLoginName
  ,ApplicationName
  ,HostName
  ,DatabaseName
  ,TextData
  ,SPID
  ,Error
  ,Success
  ,IsSystem
FROM fn_trace_gettable(@fileName, DEFAULT) gt 
  INNER JOIN sys.trace_events te ON EventClass = te.trace_event_id 
  LEFT JOIN sys.trace_subclass_values tsv on EventClass = tsv.trace_event_id and EventSubClass = tsv.subclass_value

WHERE spid != @@spid 
-- EventClass IN(20) -- Audit Login Failed
AND textdata LIKE '%your_text%'

ORDER BY StartTime DESC

DECLARE @HOURS BIGINT
SET @HOURS = 24
-- ONE WEEK = 168 HOURS IF SO

-- #################

IF OBJECT_ID('tempdb..#TempSqlLogTable') IS NOT NULL
DROP TABLE #TempSqlLogTable


CREATE TABLE #TempSqlLogTable
(
	[DateTime] DATETIME,
	[Owner] NVARCHAR(255),
	[EventText] NVARCHAR(MAX)
)

INSERT INTO #TempSqlLogTable
EXEC sys.xp_readerrorlog 0, 1

SELECT * 
FROM #TempSqlLogTable AS EL
WHERE DATEDIFF(HH, EL.[DateTime], GETUTCDATE() )  <= @HOURS

--AND EL.EventText LIKE '%mirror%'

ORDER BY EL.[DateTime] DESC