Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 01 Nov 2001 @ 16:45:21 GMT

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

Subj:   Re: User activity monitor
From:   Al Lee

Would it be possible to do a self join on this table (dbc.logoff) to capture the date and time for events 'logoff' and 'logon' based either on username and session. Then take the time difference between logon and logoff time.

Not a SQL Guru, but would that be possible. And if it is, can someone give us an example?.



  <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