Archives of the TeradataForum
Message Posted: Fri, 14 Sep 2001 @ 18:56:01 GMT
| 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)
where event = 'logoff'
and logonsource like '(tcp/ip)%'