14.10 Compare24HoursLD

Use this Knowledge Script instead of Compare24Hours when the data sets from which you are deriving values exceed the ADO limit of 1.5 GB. When data sets exceed this size limit, the report agent cannot process the data. Use this script to process data on the SQL Server managing the AppManager repository and return the aggregated value to the report agent.

Use this script to generate a report that compares the average, minimum or maximum values per hour of selected datastreams for periods of 1 day, 1 week, 1 month, and 3 months. You can limit the scope of the report by selecting data from specific days of the week (for example Monday through Friday only).

The time periods illustrated in the report are:

  • Today

  • Last Week

  • Last Month

  • Last 3 Months

For example:

  • Today = 4-1-06, 12 A.M. to 11:59:59 P.M.

  • Last Week = 3-24-06, 12 A.M. to 3-30-06, 11:59:59 P.M. (the previous seven days)

  • Last Month = 3-1-06, 12 A.M. to 3-31-06, 11:59:59 P.M. (all days of the previous month; for example, if Today is any day in April, then Last Month = all days in March)

  • Last 3 Months = 1-1-06, 12 A.M. to 3-31-06, 11:59:59 P.M. (all days of the previous three months; for example, if Today is any day in April, then Last 3 Months = all days in January, February, and March)

Twenty-four values are given for each time period, from 12 A.M. to 11 P.M. For each time period, the values are based on different quantities of data. For example:

  • 12 A.M. Today is an average of one hour’s worth of data (12 A.M. to 12:59:59 A.M. for one day)

  • 12 A.M. Last Week is an average of seven hours’ worth of data (12 A.M. to 12:59:59 A.M. for each day of the week)

  • 12 A.M. Last Month is an average of 31 hours’ worth of data (12 A.M. to 12:59:59 A.M. for each day of the month)

  • 12 A.M. Last 3 Months is an average of 90 hours’ worth of data (12 A.M. to 12:59:59 A.M. for each day of the three months)

This report always compares these four time periods, and so there is no option to select the time range.

All time periods are relative to the day you start the report.

14.10.1 Resource Object

Report agent

14.10.2 Default Schedule

The default schedule is Run once.

14.10.3 Setting Parameter Values

Set the following parameters as needed:

Parameter

How To Set It

Data source

Select data wizard

Select the data for your report by Knowledge Script or by datastream.

Select peak weekday(s)

Filter the data for your report by days of the week.

Select average, minimum, or maximum

Select the type of value you want to represent in your report.

Report settings

Include parameter help card?

Set to y to include a table in the report that lists parameter settings for the report script. The default is y.

Include table/chart/both?

Select the type of datastream values you want to include in the report:

  • Table (table only)

  • Chart (chart only)

  • Both (table and chart)

Select chart style (Today)

Define the graphic properties of the chart in your report, and for the chart series representing values for the Today time period.

Series style (Last Time Periods)

Select the series style for the last three time periods represented in the report.

This parameter lets you select a series style different from the Today series in order to easily differentiate the time periods.

Select output folder

Set parameters for the output folder.

Add job ID to output folder name?

Set to y to append the job ID to the name of the output folder.

A job ID helps you correlate a specific instance of a Report Script with the corresponding report.

The default is n.

Select properties

Set miscellaneous report properties as desired.

Add time stamp to title?

Set to y to append a time stamp to the title of the report, making each title unique. The time stamp contains the date and time the report was generated.

A time stamp allows you to run consecutive iterations of the same report without overwriting previous output.

The default is n.

Event notification

Event for report success?

Set to y to raise an event when the report is successfully generated. The default is y.

Severity level for report success

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 35 (magenta level indicator).

Severity level for report with no data

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 25 (blue level indicator).

Severity level for report failure.

Set the event severity level, from 1 to 40, to indicate the importance of the event. The default is 5 (red level indicator).