WITH Base AS (SELECT Db_name(database_id) DatabaseName, last_user_seek AS last_access_time FROM sys.dm_db_index_usage_stats UNION ALL SELECT Db_name(database_id) DatabaseName, last_user_scan FROM sys.dm_db_index_usage_stats UNION ALL SELECT Db_name(database_id) DatabaseName, last_user_lookup FROM sys.dm_db_index_usage_stats UNION ALL SELECT Db_name(database_id) DatabaseName, last_user_update FROM sys.dm_db_index_usage_stats),AccessInfo AS (SELECT DatabaseName, Datediff(dd, Max(last_access_time), Getdate()) AS no_of_days FROM Base GROUP BY DatabaseName HAVING DatabaseName NOT IN ('master', 'tempdb', 'model', 'msdb'))SELECT *FROM AccessInfowhere no_of_days > 15ORDER BY 2;
We walk in the dark places no others will enterWe stand on the bridge and no one may pass