Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 20 Jul 2011 @ 12:38:28 GMT

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

Subj:   Re: Last logon for each user
From:   Patel, Satish

DBC.Logonoff contains 2 records for each session. Logon and logoff/abort. When PDCR process move it to history table in PDCRDATA, it summarize 2 records into 1. You should be able to find logontime in the table.

You can check your PDCR archive process for more info.


  <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: 15 Jun 2023