Get the recent DBCC events executed

Get-RecentDBCCEvents.sql

DECLARE @TraceFileName NVARCHAR(400);

SELECT TOP 1
       @TraceFileName = path
FROM sys.traces
WHERE is_default = 1;

SELECT *
FROM sys.fn_trace_gettable(@TraceFileName, DEFAULT) AS t
WHERE (
          t.EventClass = 22
          AND t.Severity >= 17
          AND t.StartTime > DATEADD(dd, -30, GETDATE())
      )
      OR
      (
          t.EventClass IN ( 92, 93 )
          AND t.StartTime > DATEADD(dd, -30, GETDATE())
          AND t.Duration > 15000000
      )
      OR (t.EventClass IN ( 94, 95, 116 ));