How check when was a table last accessed?

[former_member213461]

We can get information about DML changes on a table with sp_iqunusedtable. However, our requirement needs when was a Select query was executed on a particular table, it is possible??

Best regards

[Former Member · Accepted solution]

Jairo,

You may try query on SYSIQTAB for last UPDATE on table without audit.....

select convert(varchar(50),table_name),convert(varchar(27),update_time)

from systable t, SYSIQTAB i

where t.table_id = i.table_id

order by update_time;

[markmumy]

You would need to enable auditing to track individual usage.  If all you need is usage data, you could look at the workload monitor where we track IF a table/column/index was used or not.  It does not track the WHO or the WHEN, that would come from auditing.

Mark

[former_member213461]

Thank you Mark

Is there any IQ auditing procedure? or this could be executed with a third part tool?

Jairo