My co-worker wrote a quick stored procedure to make searching the command logs easier also.
You can execute this proc with no parameter to see everything, or you can pass a search string. Remember it is a string and use the % wildcard appropriately.
exec AA_CmdsExecPast24Hrs '%tablename%'
exec AA_CmdsExecPast24Hrs '%Jared%'
etc.
/****** Object: StoredProcedure [dbo].[AA_CmdsExecPast24Hrs] Script Date: 10/08/2015 11:02:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Bill Russell - Bundy & Associates
-- Create date: 6/29/2015
-- Description: Returns a list of queries run over the past 24 hours.
-- =============================================
CREATE PROCEDURE [dbo].[AA_CmdsExecPast24Hrs]
@ContainsLIKE varchar(300)
AS
BEGIN
SET NOCOUNT ON;
SELECT execquery.last_execution_time AS ExecTime, ExecSQL.text AS [Script]
FROM sys.dm_exec_query_stats AS ExecQuery
CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS ExecSQL
WHERE @ContainsLIKE='' OR (@ContainsLIKE <> '' AND ExecSQL.text LIKE @ContainsLIKE)
ORDER BY ExecQuery.last_execution_time DESC
END
