Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2003 @ 15:15:05 GMT

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

Hi,

What release of Teradata are you running? The AccessCount/Lastaccesstimestamp columns are not populated until v2r5.1.

No, there's no easy way of doing it in v2r4 (which I guess answers the question above !). You need to scan the accesslog and parse out the sql.

Cheers,

Dave

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