Archives of the TeradataForum

Message Posted: Thu, 04 Mar 2016 @ 00:16:51 GMT

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

If you are referring to all sessions logged in by a Batch/ETL user per day/time then it should be straight forward.

     sel logondate,
     count(*)
     from dbc.logonoff where username=
     and logondate =
     and event='logon'
     --logontime between <> and <>
     group by 1

If you are referring to all sessions logged on by a Batch/ETL user per day and per activity/Job then you may need to join this with your below query on

     ....
     dbc.dbqlogtbl
     ....
     WHERE
     appid in ('FASTLOAD','MULTLOAD','TPTLOAD','TPTUPD')

The below could help if its active,

     Viewpoint  --> Query Monitor  --> By Utility  -->  By Job.

Thanks,

Sravan.

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