BIRT for Capacity Managment

itrubin

I am new in BIRT and we need to get 30 days histoy of CPU util. of some servers from TDW with ITM performance data.

I can filter out data for particular day (see script below) but how to get current date (curdate() for DB2? or getdate() for T/SQL type of function?) and put that in where clouse?

Here is my code:

select
DATE(SUBSTR("Timestamp",4,2) || '/' ||
SUBSTR("Timestamp",6,2) || '/' ||
'20' || SUBSTR("Timestamp",2,2)) as DT,

"AVG_Busy_CPU",
"System_Name"
from
"ITMUSER"."KLZ_CPU_H"
where DATE(SUBSTR("Timestamp",4,2) || '/' ||
SUBSTR("Timestamp",6,2) || '/' ||
'20' || SUBSTR("Timestamp",2,2))
='2010-10-19'