SQL Server - Failed Logins

failedLogins.sql

declare @Time_Start datetime = getdate()-7;
declare @Time_End datetime = getdate();
-- Create the temporary table
DECLARE @ErrorLog TABLE (logdate datetime
                      , processinfo varchar(255)
                      , Message varchar(500))
-- Populate the temporary table
INSERT @ErrorLog (logdate, processinfo, Message)
   EXEC master.dbo.xp_readerrorlog 0, 1, null, null , @Time_Start, @Time_End, N'desc';
-- Filter the temporary table
SELECT * --LogDate, Message
  FROM @ErrorLog
 WHERE (Message LIKE '%error%' OR Message LIKE '%failed%')
 ORDER BY logdate DESC