Archives of the TeradataForum

Message Posted: Tue, 13 Mar 2012 @ 09:21:59 GMT

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

     SELECT UserName,AccountName , SUM(LogonTime), SUM(QueryBand)
       FROM DBC.SessionInfoV
       where DefaultDataBase like 'FDWQ%DE%'
          OR DefaultDataBase like 'FDWQ%CPS%'
          OR DefaultDataBase like 'FDWQ%SBSL%'
          OR DefaultDataBase like 'FDWQ%RACE%'
       GROUP BY 1,2

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