Use this Report Knowledge Script to generate a report detailing availability and response time for the following SQL-RT DSN Knowledge Scripts:
AppManager repository
The default schedule is Run once.
Set the following parameters as needed:
Description |
How to Set It |
---|---|
Data Source |
|
KS for report |
Click Browse [...] to select the Knowledge Scripts you want to include in the report. |
SQL-RT client(s) |
Click Browse [...] to select the SQL-RT client computers to include in the report. Your selections are limited to computers or server groups that are visible in the selected views. Select one of the filter options:
NOTE:Selecting a server group includes all computers in that group. |
SQL DSN or “All” |
Specify the name of the SQL Server or type “All” to designate all computers as SQL Servers. The default is “All”. |
Select time range |
Click Browse [...] to set specific start and end report information dates, good for historical or ad hoc reports, or a sliding range that sets the time range of data to include in the report. The sliding range option is the default and is useful for reports running on a regular schedule. |
Select peak weekday(s)) |
Click Browse [...] to select a contiguous day range a selection of non-contiguous days. |
Aggregation by |
Select the time unit by which to aggregate data. The default is Hour. This works in conjunction with the next field (Aggregation interval), which determines the number of units for one interval of data aggregation. |
Aggregation interval |
Select the interval units in which to aggregate data. The default is 1. For example, if you aggregate by the Hour and select 1 here, data is aggregated once every hour. |
Report Settings |
|
Include parameter card? |
Select Yes to display a table of parameters used in the report. The default is Yes. |
Include Availability detail table? |
Select Yes to display the Availability Detail table as part of the report. The default is Yes. |
Include Availability chart? |
Select Yes to display the Availability chart as part of the report. The default is Yes. |
Availability data stream format |
Specify the data stream format. Options are 0-100 or 0-1.
The default format is 0-100. |
Threshold on Availability chart |
Specify an integer for the percentage threshold. The default is 0 (no threshold is displayed). |
Include Response Time Detail table? |
Select Yes to display the Response Time Detail table as part of the report. The default is Yes. |
Include Response Time chart? |
Select Yes to display the Response Time chart as part of the report. The default is Yes. |
Units for Response Time report |
Select the response time unit, msec or sec. The default is msec. |
Threshold on Response Time chart (selected units) |
Specify the response time threshold to display on the chart in the report. The default is 0, which suppresses the threshold indicator in the chart. |
Select chart style |
Click Browse [...] to set the appearance of the chart. The same parameters are used in both the Availability and Response Time charts, if both are produced. The default is Ribbon. |
Select output folder |
Select Browse [...] to specify the report filename and the report folder. You can specify a specific folder or have the system generate the folder each time the report runs. |
Add job ID to output folder name? |
Select Yes to add a job ID to the output folder name. Use a job ID to correlate a specific instance of a Report Script with the corresponding report. The default is unselected. |
Index-Report Title |
Select Browse [...] to configure report title settings and custom fields. |
Add timestamp to title? |
Select Yes to add a timestamp to the report title, making each title unique. The time stamp is made up of the date and time the report was generated. A time stamp lets you run consecutive iterations of the same report without overwriting previous output. The default is unselected. |
Event Notification |
|
Generate event on success? |
Select Yes to raise an event when a report is generated. The default is Yes. |
Severity level for report success |
Set the event severity level to indicate the importance of an event in which the report is generated successfully. The default is 35. |
Severity level for report with no data |
Set the event severity level to indicate the importance of an event in which the report has no data. The default is 25. |
Severity level for report failure |
Set the event severity level to indicate the importance of an event in which the report cannot be generated. The default is 5. |