Using http://extras.sqlservercentral.com/prettifier/prettifier.aspx

WITH LastActivity (ObjectID, LastAction) AS

(

SELECT OBJECT_ID AS TableName,

last_user_seek AS LastAction

FROM sys.dm_db_index_usage_stats u

WHERE database_id = DB_ID(DB_NAME())

UNION

SELECT OBJ

ECT_ID AS TableName,

last_user_scan AS LastAction

FROM sys.dm_db_index_usage_stats u

WHERE database_id = DB_ID(DB_NAME())

UNION

SELECT OBJECT_ID AS TableName,

last_user_lookup AS LastAction

FROM sys.dm_db_index_usage_stats u

WHERE database_id = DB_ID(DB_NAME())

)

SELECT OBJECT_NAME(so.OBJECT_ID) AS TableName,

MAX(la.LastAction) AS LastSelect

FROM sys.objects so

LEFT

JOIN LastActivity la

ON so.OBJECT_ID = la.ObjectID

WHERE so.TYPE = 'U'

AND so.OBJECT_ID > 100

GROUP BY OBJECT_NAME(so.OBJECT_ID)

ORDER BY OBJECT_NAME(so.OBJECT_ID)