Archives of the TeradataForum

Message Posted: Tue, 07 May 2013 @ 12:56:51 GMT

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

     select username, count(*) cnt
       from table ( monitorsession(-1,'*',0) ) a
       where pestate <> 'IDLE'
       group by 1

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