Archives of the TeradataForum

Message Posted: Thu, 10 Jul 2003 @ 20:06:49 GMT

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

I don't have a way of checking my example, but can't you get the IP address of a LAN user by looking at table DBC.EVENTLOG?

You'll probably have to play with it, but try something like:

    SEL LOGONDATE                  (NAMED LOGON_DATE)
      , LOGONTIME                  (NAMED LOGON_TIME)
      , DATEFLD                    (NAMED LOGOFF_DATE)
      , TIMEFLD                    (NAMED LOGOFF_TIME)
      , USERNAME                   (NAMED USER_ID)
      , SUBSTR(LOGONSOURCE,15,15)  (NAMED IP_ADDR)
      , IFPNO                      (NAMED PE_NBR)

      FROM DBC.EVENTLOG

      WHERE EVENT = 'LOGOFF'
        AND SUBSTR(LOGONSOURCE,1,8) = '(TCP/IP)'

      ORDER BY 1,2,3,4,5;

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