i need ur help.
i want to have CPU utilization of last 24 hrs. for time being i want
to have result from 1 server.
select "AVG_%_Total_Processor_Time", "WRITETIME", "MAX_
%_Total_Processor_Time", "MIN_%_Total_Processor_Time", "AVG_
%_Total_Privileged_Time" , "AVG_%_Total_User_Time",
"AVG_Context_Switches/Sec", "AVG_Total_Interrupts/Sec"
from "NT_System_HV"
where "Server_Name" = 'Primary:ITM6VM:NT' and "WRITETIME" between
'0000000000000000' and'9999999999999999'
query working fine till where server name but i am confuse how to
utilize and get result from between clause and get last 24 hrs result.
i want this query for BIRT re****t design and itm6.2.
pls tell me how to achieve the result.
|
