Get a tables last scan, seek, lookup and update

Get-ObjectLastUsage

SELECT t.name,
       MAX(us.last_user_seek) AS last_user_seek,
       MAX(us.last_user_scan) AS last_user_scan,
       MAX(us.last_user_lookup) AS last_user_lookup,
       MAX(us.last_user_update) AS last_user_update
FROM sys.dm_db_index_usage_stats AS us
    JOIN sys.tables AS t
        ON t.object_id = us.object_id
WHERE us.database_id = DB_ID()
GROUP BY t.name;