Archives of the TeradataForum

Message Posted: Fri, 04 Mar 2016 @ 08:26:18 GMT

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

You shouldn't need to join to DBQL. As has already been said that won't trap all sessions (it won't contain the 'amp specific' sessions).

Using dbc.logonoffv (which I think is your best source of this on TD14.10) you need to look in column logonsource for the utility program names (fastload, tptload etc).

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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