Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 17:03:32 GMT

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

Dave,

I don't recall exactly how BO works, (it's been a long time since I last used it), but if BO generates the SQL from a server and "normal SQL" is submitted from the user's client (i.e. queryman, etc.), you might be able to distinquish the query source by examining the LogonSource column in the DBC.EVENTLOG table (i.e. LOGONOFF). The column is normally populated with the IP address of the requestor for a network request. Therefore, the server IP address would be in LogonSource for BO queries while the client IP address would be in LogonSource for QueryMan queries. Of course, any requests from that server (BTEQ, etc.) would also have the same IP address.

BTW, for mainframe requests, LogonSource contains job information.

Let everyone know if this works for you or not.

Hope this helps.

Regards,

Thomas F. Stanek
TFS Consulting

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