When dbcc checkdb last run OR Frequency of checkdb

"Script for Last Checkdb Run For All Databases"

One day you will get a call from manger during his audit and he will ask you “When checkdb was last run or what the frequency of check db is” And googling might open this blog for your help

It seems easy you can go in SQL job history and update. But what if some one have ran same manually or running manually from weeks

SQL gives us couple of ways to find same

1. Last checkdb run from boot page of sql server

dbcc traceon (3604 ,-1)
------> To get result in Output window
DBCC DBINFO (dbname)
---> In output search "dbi_dbccLastKnownGood " and date is last checkdb

2. Check errorlog : Sounds easy , but if system is rebooted ?

xp_readerrorlog 1,1 -- Current errorlog
xp_readerrorlog 2,1 -- errorlog belore last reboot
xp_readerrorlog 3,1 -- errorlog before last to last reboot

3. Check SQL server default trace

SELECT TableValues.DatabaseName, TableValues.TextData, TableValues.HostName,
            TableValues.ApplicationName,TableValues.LoginName,       TableValues.StartTime, 
            TableValues.IsSystem
FROM sys.FN_TRACE_GETTABLE(CONVERT(VARCHAR(150),
      ( SELECT TOP 1 f.[VALUE]                                                
              FROM    sys.FN_TRACE_GETINFO(NULL) f
              WHERE   f.property = 2
            )), DEFAULT) TableValues
WHERE TableValues.TextData LIKE '%CHECKDB%' AND
TableValues.EventClass = 116

These 3 could be the best ways to find same.