Use this Knowledge Script in place of PerfOverview when the data sets from which you are deriving values exceed the ADO (ActiveX Data Objects) 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.
The report contains a single average value for each selected datastream for a specified increment of time, for example, an average value derived from one month’s worth of data or one year’s worth of data.
A separate chart is generated for each selected datastream.
Report agent
The default schedule is Run once.
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 the style |
Select the style for the first page of the report:
|
Select time range |
Filter the data for your report by a specific or sliding time range. The default is Sliding. |
Select peak weekday(s) |
Filter the data for your report by the days of the week. |
Aggregation by |
Select the method by which data in the report is aggregated. The options are:
This parameter is used in conjunction with the following parameter. For example, if you choose to aggregate by day, then the following parameter determines how many days’ worth of data are aggregated. |
Aggregation interval |
Select the interval at which the data in your report is aggregated. This parameter is used in conjunction with the previous parameter. For example, if the Aggregation by parameter is set to Day, use this parameter to set the number of days by which data is aggregated (1 gives you a single value for one day’s worth of data, 2 gives you a single value for two days’ worth of data, and so on). |
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:
|
Select chart style |
Define the graphic properties of the charts in your report. |
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). |