Archives of the TeradataForum

Message Posted: Wed, 09 Aug 2006 @ 17:50:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Rishi,

The easiest thing would be to have a look at the accesslog, you could run something like

     Select * from dbc.accessLog
     where TVMName = 'xxxxxxxxx'
     and DatabaseName  = 'yyyyyyyyy'
     order by logDate desc, logTime desc;

If you want to see when the table was last accessed by a "real" user you would need to say

     and UserName not in ('DBC', 'Batch Users', 'etc.')

Hope this helps,

Fachtna O'Donovan
Software Developer
AIB Bank
Ireland

	<Prev	Next>		<<First	<Prev	Next>	Last>>