Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Number of ACTIVE users
From:   John Hall

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020