Archives of the TeradataForum

Message Posted: Thu, 29 Sep 2011 @ 08:45:22 GMT

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

hello,

in our querylog table, I can see it holds the AppID of the source application - and also adds it to the LogonSource field. (eg Excel, Queryman, Access)

Is there anyway of manipulating this in the connection string?

We submit a lot of queries via an Access application, and we're able to track them via a web-interface of active queries.

It would be good if we good more accurately identify which query is being ran by submitting the queryID (3 digit number) held by access with the query, and see this as part of the AppID / LogonSource

Thanks for your ideas!

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