Archives of the TeradataForum

Message Posted: Wed, 05 Jun 2002 @ 18:33:56 GMT

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

I believe the 100 is the host id and the 1054/1013/1014 are the session numbers. You have the date/times and you can look up both the session and host id's in sessioninfo(if they're still logged on) or logonoff if not(in logonoff, you'll have to sort through possibly lots of duplicates since the sessions renumber every time TDBMS is restarted, so you'll need to find the nearest one to your date/time). Sessioninfo and logonoff have the username, accountname and lots of other stuff.

Pat Belle
Teradata Certified Master

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