Special time range for report

Magman

When writing a new report, in the Time Frame section, you have the choice between named time frames, relative time frames and custom time frames. Is it possible to write my own Named time frame? I would like a report where the time frame would have the start date of: Yesterday 07:00 to Yesterday 21:00.So that every time I run this report it looks in the SQL db for that "relative custom" time frame! Any help would be great. Basically I'm writing a report that gives me yesterday's performance of a specific application, but it needs to be between time where the application is not idle, and if I'm not specific, the average CPU usage for example can be very skewed.  Thanks

rajivbahl

Hi Magman

 You can use the advance SQL reports for this functionality.

Best way is compose your report they way you want in a standard report designing format do not care about the time frames . than copy the SQL code of this report and paste to a new advance SQL report.

change the time frame in this report matching your requriement.Refer to the below post for SQL codes of time range.

HTH 

Rajiv