SELECT 
  DB_NAME(db.database_id) DatabaseName, 
  MAX(CASE WHEN ISNULL(s.last_user_seek, '1900-01-01') > ISNULL(s.last_user_scan, '1900-01-01') 
      THEN 
        CASE WHEN ISNULL(s.last_user_seek, '1900-01-01') > ISNULL(s.last_user_lookup, '1900-01-01') 
        THEN 
          s.last_user_seek
        ELSE
          s.last_user_lookup
        END
      ELSE 
        CASE WHEN ISNULL(s.last_user_scan, '1900-01-01') > ISNULL(s.last_user_lookup, '1900-01-01') 
        THEN 
          s.last_user_scan
        ELSE
          s.last_user_lookup
        END          
      END) AS last_user_read,
  MAX(last_user_update) AS last_user_update,
  db.create_date AS db_create_date
FROM sys.databases db
  LEFT JOIN sys.dm_db_index_usage_stats AS s ON s.database_id = db.database_id
GROUP BY DB_NAME(db.database_id), db.create_date
ORDER BY last_user_read, last_user_update

SELECT 
    DB_NAME(db.database_id) DatabaseName, 
    max (last_user_read) as last_user_read, 
    MAX(last_user_update) AS last_user_update,
    db.create_date AS db_create_date
FROM sys.databases db
LEFT JOIN sys.dm_db_index_usage_stats AS s ON s.database_id = db.database_id
outer apply (
    select
        last_user_read = max ( isnull (s.last_user_read, '19000101' ) )
    from (
                  select s.last_user_seek
        union all select s.last_user_lookup
        union all select s.last_user_scan
    ) s ( last_user_read )    
) r
GROUP BY DB_NAME(db.database_id), db.create_date
having ( DB_NAME(db.database_id) like '%accounting%' and datediff ( dd, max (last_user_read), getdate() ) > 5 )
ORDER BY last_user_read, last_user_update

SELECT 
    DB_NAME(db.database_id) DatabaseName, 
    max (last_user_read) as last_user_read, 
    MAX(last_user_update) AS last_user_update,
    db.create_date AS db_create_date
FROM sys.databases db
LEFT JOIN sys.dm_db_index_usage_stats AS s ON s.database_id = db.database_id
outer apply (
    select
        last_user_read = max ( isnull (s.last_user_read, '19000101' ) )
    from (values (s.last_user_seek),
                 (s.last_user_lookup),
                 (s.last_user_scan)
	 ) s ( last_user_read )    
) r
GROUP BY DB_NAME(db.database_id), db.create_date
having ( /*DB_NAME(db.database_id) like '%accounting%' and*/ datediff ( dd, max (last_user_read), getdate() ) > 5 )
ORDER BY last_user_read, last_user_update

SELECT OBJECT_NAME(IX.OBJECT_ID) Table_Name
	   ,IX.name AS Index_Name
	   ,IX.type_desc Index_Type
	   ,SUM(PS.[used_page_count]) * 8 IndexSizeKB
	   ,IXUS.user_seeks AS NumOfSeeks
	   ,IXUS.user_scans AS NumOfScans
	   ,IXUS.user_lookups AS NumOfLookups
	   ,IXUS.user_updates AS NumOfUpdates
	   ,IXUS.last_user_seek AS LastSeek
	   ,IXUS.last_user_scan AS LastScan
	   ,IXUS.last_user_lookup AS LastLookup
	   ,IXUS.last_user_update AS LastUpdate
FROM sys.indexes IX
INNER JOIN sys.dm_db_index_usage_stats IXUS ON IXUS.index_id = IX.index_id AND IXUS.OBJECT_ID = IX.OBJECT_ID
INNER JOIN sys.dm_db_partition_stats PS on PS.object_id=IX.object_id
WHERE OBJECTPROPERTY(IX.OBJECT_ID,'IsUserTable') = 1
GROUP BY OBJECT_NAME(IX.OBJECT_ID) ,IX.name ,IX.type_desc ,IXUS.user_seeks ,IXUS.user_scans ,IXUS.user_lookups,IXUS.user_updates ,IXUS.last_user_seek ,IXUS.last_user_scan ,IXUS.last_user_lookup ,IXUS.last_user_update