Check Table Last Accessed by User. with TSQL Script

Select DB_Name(usts.[database_id]) AS [Database],

Object_Name(usts.[object_id]) AS [TableName],

MAX(usts.[last_user_lookup]) AS [last_user_lookup],

MAX (usts.[last_user_scan]) AS [last_user_scan],

MAX(usts.[last_user_seek]) AS [last_user_seek]

FROM sys.dm_db_index_usage_stats AS usts

WHERE usts.[database_id] = DB_ID()

AND usts.[object_id] = Object_ID(‘Table_Name’)

GROUP BY usts.[database_id], usts.[object_id];

After Database Services/ Server restart View also reset.

Change your database context to your current database.

Change the Table Name for which you want to get last access details.