Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Sep 2001 @ 20:37:04 GMT

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

Subj:   Re: Number of ACTIVE users
From:   Adam DeYoung

This method assumes no spool = inactive, but you could take a count of distinct users having SUM(CURRENTSPOOL) > 0 from DBC.Diskspace. This will not capture utility sessions (MLoad, Fastload) from what I recall but would get you anyone running Selects or Exports at the time.


  <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