Archives of the TeradataForum

Message Posted: Tue, 13 Mar 2012 @ 09:18:53 GMT

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

Hi Sravan,

You can use the following tables to generate the report you are looking for:

Table1 : pdcrdata.dbqlogtbl_hst (Will provide the CPU Usage)

Table2 : dbc.dbase (Will provide the Users list) Joining Condition : dbqlogtbl_hst.databaseid = dbase.userid

Regards,

Manish

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