Archives of the TeradataForum

Message Posted: Mon, 14 Mar 2011 @ 13:44:57 GMT

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

These information could be found from DBQL and AMPUsage

1. DBQL

     SELECT username
            , CAST(starttime AS DATE) AS StartDate
            , SUM(AMPCPUTime+ ParserCPUTime) AS TotalCPU
            , SUM(TotalIOCount) AS TotalIO
        FROM dbc.dbqlogtbl
        WHERE username = ''
          AND EXTRACT(YEAR FROM starttime) = 2011
        GROUP BY 1, 2   ORDER BY 1, 2

2. For AMPUSAGE, depend on your account string, you need to do some manipulation to extract the date information if you've specified in the date info in your account string.

Regards,

YB.

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