Archives of the TeradataForum

Message Posted: Thu, 17 Nov 2016 @ 09:08:50 GMT

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

Hi Kavitha,

I'll let Michelle give you information about their implementation details, but for querying use the ProxyUser column in whichever view/table one you're querying (e.g. dbc.dbqlogtbl or dbc.qrylogv). That is by far the easiest way.

It is also stored in the Queryband column and you can search that, but that seems a harder way to go about it. If you're going to search the Queryband column then use the " SYSLIB.GetQueryBandValue" function, the QBName value is 'ProxyUser'.

Cheers,

Dave

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

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