Archives of the TeradataForum

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

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

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.

Adam

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