Archives of the TeradataForum

Message Posted: Fri, 14 Sep 2001 @ 18:56:01 GMT

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

You should be able to find the number of concurrent (but not necessarily active) users from the DBC.EVENTLOG table. Unfortunately I'm not in a position to test it, but this might give you an idea about how to use the DBC.EVENTLOG table:

    sel logondate                  (named logon_date)
      , logontime                  (named logon_time)
      , datefld                    (named logoff_date)
      , timefld                    (named logoff_time)
      , username                   (named userid)
      , substr(logonsource,15,15)  (named ip_address)

      from dbc.eventlog

      where event = 'logoff'
        and logonsource like '(tcp/ip)%'

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