3.7 Report_SQL-RT_DSN

Use this Report Knowledge Script to generate a report detailing availability and response time for the following SQL-RT DSN Knowledge Scripts:

3.7.1 Resource Object

AppManager repository

3.7.2 Default Schedule

The default schedule is Run once.

3.7.3 Setting Parameter Values

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:

  • View: Includes all computers in the views you selected.

  • Computer: Select from individual computers in the views you selected.

  • Server Group: Select from server groups in the views you selected.

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.

  • 1 or 100 -- Available

  • 0 -- Not available

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.