11.4 Working with the Chart Console

The Chart Console provides functionality not available on the Charts tab. The Chart Console allows you to perform the following functions:

  • Create chart groups from which you can quickly assess overall performance.

    For more information about creating groups, see Section 11.4.4, Organizing Charts into Groups.

  • Customize the chart appearance through options that allow you to:

    • Orient your view of the data using real-time rotation, zoom, and pan.

    • Re-order data streams within a chart to improve readability.

    • Customize the chart color scheme.

    • Mix and match chart styles across different data streams in a chart. Proportional graphing between streams correctly displays different monitoring intervals.

    For more information about the customization options, see Section 11.4.5, Customizing Charts.

  • Identify when a data stream breaches a high or low threshold by creating static threshold indicators.

    For more information about creating threshold indicators, see Section 11.4.6, Setting Thresholds.

Use AppManager Security Manager to grant users permission to use the Chart Console. For more information about using Security Manager, see the Administrator Guide for AppManager, available on the AppManager Documentation page.

11.4.1 Starting the Chart Console

You can start the Chart Console from the Control Center console, the Windows desktop, or the Operator Console.

To start the Chart Console from the...

Do this...

Control Center console

  1. In a Servers, Jobs, or Events view, right-click an item in the view pane and select Utilities > AppManager Utilities > Chart Console.

  2. Select the data streams you want to chart.

  3. Specify a chart title, select a color scheme, and click Finish.

Windows desktop

  1. Start the Chart Console from the AppManager program folder.

  2. Specify the name of the SQL Server and, if applicable, instance that hosts the QDB that stores the data streams you want to chart. To specify a SQL Server instance, use the format servername\instance.

  3. Select the QDB.

  4. Select whether to use Windows or SQL Server authentication to connect to the QDB. If you select SQL Server authentication, also provide the account user name and password.

  5. Click Logon.

Operator Console

  1. (Conditional) If you want to create a chart based on a specific computer, right-click the computer in the tree view and select Create Chart by Selected Computer.

  2. (Conditional) If you want to create a chart based on a specific job, right-click the job on the Jobs tab and select Create Chart by Selected Job.

  3. (Conditional) If you want to chart a specific data stream, right-click the data stream on the Graph Data tab and select Create Chart.

  4. (Conditional) If more than one data stream is available, select the data streams you want to chart.

  5. Specify a chart title, select a color scheme, and click Finish.

11.4.2 Viewing Charts

The Chart Console consists of a tree pane and a chart pane. The tree pane lists available charts and chart groups and allows you to create new charts and chart groups. For more information about creating charts, see Section 11.4.3, Creating Charts. For more information about organizing charts into groups, see Section 11.4.4, Organizing Charts into Groups.

When you select a chart group in the tree pane, a chart snapshot of each chart in the group displays in the chart pane. Chart snapshots provide a quick view of the most recent data points for the associated data streams. When you select a chart snapshot, a complete view of the data displays in the chart pane.

When you select an individual chart in the tree pane, a complete view of the data displays in the chart pane.

11.4.3 Creating Charts

Use the Add Data wizard to create new charts and add data streams to existing charts.

To create a chart:

  1. In the tree pane, select the group in which you want to create the chart.

    To share the chart with other console users, select the Public group. If the Public group is not available, check with your AppManager administrator to ensure you have permission to view and edit charts in the Public group. For more information about chart groups, see Section 11.4.4, Organizing Charts into Groups. For more information about setting permissions for the Chart Console, see the Administrator Guide for AppManager, available on the AppManager Documentation page.

    To create a chart without adding it to a group, select the Charts folder.

  2. On the Chart menu, select Create Chart.

  3. Select the QDB, view, and filter for which you want to view available data streams, and then click Next.

  4. Select the data streams you want to chart and click Next.

  5. Specify a chart title and select a color scheme.

  6. (Optional) If you want to display dates and times, select the option Display dates and times based on the local time of the managed computer.

  7. Click Finish.

    A snapshot of the new chart appears in the chart pane.

To add a data stream to a chart:

  1. Select the chart to which you want to add data.

  2. On the Chart menu, select Add to Chart.

  3. Select Existing Chart and click OK.

  4. Select the QDB, view, and filter that contains the data stream you want to add and click Next.

  5. Select the data streams you want to add and click Next.

  6. Specify a chart title, select a color scheme, and click Finish.

    The updated chart appears in the chart pane.

To delete a data stream from a chart:

  1. Select the chart from which you want to remove data.

  2. In the Legend pane, right-click the data stream and select Delete.

11.4.4 Organizing Charts into Groups

You can use the Chart Console to organize charts into logical groups. For example, you might want to create a group for all charts related to West Coast computers or create separate groups for charts related to the Engineering and Finance departments in your organization. You can also create groups within groups.

To improve startup performance of the Chart Console, organize charts into groups so that the top‑most level of the tree pane does not include any charts.

To create a group:

  1. In the tree pane, select the Charts folder.

  2. On the Chart menu, select Add Group.

  3. Specify the group name and click OK.

To create a group within a group, select the group and repeat Step 2 and Step 3.

To delete a group:

  1. In the tree pane, select the group.

  2. On the Chart menu, select Delete Group.

  3. Select the charts or chart group you want to delete and click OK.

11.4.5 Customizing Charts

A standard toolbar provides quick access to frequently-used Chart Console commands. To show or hide the toolbar, select View > Toolbar. To view a description of a toolbar button, hover the mouse over the button.

Several toolbars for customizing charts are available in the chart pane. The following table describes the chart pane toolbars.

This toolbar...

Does this...

Time frame

Allows you to select the range of data to chart.

By default, AppManager stores the data points that Knowledge Script jobs collect for a given day in a data table for immediate display in charts and graphs for 30 days, and each day removes any data tables that are more than 30 days old.

To set QDB preferences, use the AppManager Operator Console. For more information about using the Operator Console to set preferences, see the Operator Console User Guide for AppManager, available on the AppManager Documentation page.For information about changing the default, see Section 3.2.8, Global Preferences Options.

Legend

Lists the data streams in the active chart and allows you to perform the following functions:

  • Delete a data stream from the chart. To delete a data stream, right-click the data stream and select Delete.

  • Move a data stream to the foreground or background by dragging it to the desired location in the list.

  • Change the properties of a data stream. To change the properties, right-click the data stream and select Properties.

  • Change the style of a data stream. To change the style, right-click the data stream and select Style.

  • Make a data stream transparent. To make a data stream transparent, right-click the data stream and select Transparent.

To show or hide the toolbars, right-click the chart and select Show time frame or Show legend.

The Chart Console provides some customization options that are not available from the chart pane toolbars. The following table describes additional customization options.

To...

Do this...

Display charts horizontally

In the chart pane, right-click the chart and select Horizontal chart.

Make all data streams in a chart transparent

In the chart pane, right-click the chart and select Transparent.

Display only a specific portion of a chart

  1. In the chart pane, ensure the time frame is set to All.

  2. Right-click the chart and select Properties.

  3. Click the Range tab.

  4. Select Specify start date and time and specify the date and time for which you want to start displaying data.

  5. Select Specify end date and time and specify the date and time for which you want to stop displaying data.

  6. Click OK.

    The chart shows only data collected between the date and times you specified.

11.4.6 Setting Thresholds

You can set thresholds to identify when a data stream crosses a critical value. For example, if you are using the NT_MemUtil Knowledge Script to monitor physical and virtual memory use, you can set thresholds to identify a warning level and a critical level.

You can apply thresholds to individual data streams or entire charts.

To set thresholds:

  1. In the chart pane, right-click the chart and select Properties.

  2. Click the Data Streams tab.

  3. (Optional) If you want to set a threshold for a specific data stream, select the data stream from the Stream drop-down menu.

  4. Click Add.

  5. Complete the following actions and click OK:

    • Select whether to apply the threshold to the specific data stream or the entire chart.

    • Specify the threshold value.

    • Select a color for the threshold indicator.

    • Select whether to activate the threshold indicator.

  6. Repeat Step 4 and Step 5 to set additional thresholds.

  7. On the Chart Properties window, click OK to add the threshold indicators to the chart.

11.4.7 Obtaining Detailed Information

You can view a list of the data points for each data stream included in a chart, or you can view detailed information about a specific data point.

To view a list of the data points for each data stream included in a chart, right-click the chart and select Data viewer. For each data stream, the Data Viewer displays each time and value pair collected.

To view detailed information about a specific data point, double-click the data point in the chart. The Graph Data Details window provides the following information about the data point:

  • Computer name

  • Type of data

  • Value of the data point

  • Time at which the data point was collected

  • Additional details that vary with the type of data

11.4.8 Changing Chart Properties

Use the Chart Properties window to configure properties such as frame rate, graphical style and color scheme, threshold values, and dates and times for which data is displayed. To change the properties of a chart, right-click the chart and select Properties.

The following sections describe the properties you can set on each tab.

General Tab

The following table describes the properties you can set on the General tab.

Property

Description

Title

Specifies the chart title.

Y-Axis Label

Specifies a label for the Y-axis.

View

Provides the following chart rendering options:

  • Perspective - Renders the chart so that the foremost data stream appears larger than the last data stream.

  • Parallel - Renders the chart so that all data streams have the same size relative to value.

WARNING:Frame Rate: (CPU Usage)

Determines the amount of CPU devoted to interactive rendering (rotating, zooming, panning, and scrolling).

A low frame rate is less fluid, but uses less CPU. A high frame rate offers the best visual performance, but uses 100 percent of the CPU.

Vertical Maximum

Provides the following options for adjusting the Y-axis:

  • Auto - Automatically sets the maximum value of the Y-axis to a value greater than the highest point rendered.

  • Manual - Allows you to specify a maximum value for the Y-axis.

Wireframe when rotating, zooming, and panning

Renders the chart in wireframe when rotating, zooming, or panning.

This option conserves CPU resources.

Screentips for data points

Displays a screen tip when you hover the mouse over a data point.

Data stream settings

Provides the following options for adjusting data appearance:

  • Depth - Sets the depth of each data stream along the Z-axis.

  • Point Density - Sets the density of data points along the X-axis.

Colors Tab

The following table describes the properties you can set on the Colors tab.

Property

Description

Scheme

Defines the chart color scheme.

To save the currently-defined color scheme under a unique name, click Save As.

Colors

Defines colors for the following chart items:

  • Title

  • Grid lines

  • Grid panels (the sides and bottom of the grid)

  • Time scale (the numbers in the time line along the X-axis)

  • Left scale (the numbers along the left Y-axis)

  • Right scale (the numbers along the right Y-axis)

  • Background (the background color for the chart pane)

  • Gradient (creates a gradient for the background of the chart pane and defines the color for the bottom of the gradient; the color you selected for the background serves as the top color in the gradient)

  • Data gap (missing points in a data stream rendered with the Area option)

  • Data stream colors

Solid Grid

Renders the grid as a solid object.

Show Left Values

Displays values along the Y-axis on the left side of the grid.

Show Right Values

Displays values along the Y-axis on the right side of the grid.

Data Streams Tab

The following table describes the properties you can set on the Data Streams tab.

Property

Description

Stream

Data stream for which you want to set properties.

Style

Visual style of the data stream.

The following styles are available:

  • Area

  • Bar

  • Cylinder

  • Line

  • Ribbon

Scale

Scale for the data stream.

The Y-axis is scaled relative to its original scale of 1.0. The grid is not affected.

High Thresholds

Thresholds to display in the chart.

For more information about setting thresholds, see Section 11.4.6, Setting Thresholds.

Other information

SQL query used to retrieve the data stream.

You cannot modify this property.

Range Tab

The following table describes the properties you can set on the Range tab.

Property

Description

Specify start date

Enables fields that allow you to specify the date and time for which you want to start displaying data in the chart.

Start Date

Date for which you want to start displaying data.

Start Time

Time for which you want to start displaying data.

Specify end date

Enables fields that allow you to specify the date and time for which you want to stop displaying data in the chart.

End Date

Date for which you want to stop displaying data.

End Time

Time for which you want to stop displaying data.

If the Range tab is not available, click Cancel and set Time frame to All in the chart pane.

11.4.9 Exporting Chart Information

You can export charts and chart data to a variety of formats. When exporting data, you can export all data or only a range of data. For more information about selecting a range of data, see Selecting a Range of Data Points for Export.

The following table describes the options for exporting chart information.

To export...

Do this...

Chart to an XML-formatted report

  1. In the chart pane, right-click the chart and select Export > Report to XML.

  2. Select a location for the XML file, specify a file name, and click Save.

Chart to an HTML-formatted report

  1. In the chart pane, right-click the chart and select Export > Report to HTML.

  2. Select the type of report to generate and the data streams to include and click Next.

  3. Specify a report title, select a color scheme, and click Finish.

  4. Select a location for the HTML file, specify a file name, and click Save.

    The file is saved in a sub-folder named according to the report title. For example, if the report name is IIS_CpuHigh  (BALQEROW06A12).htm, the report is saved in a subfolder named IIS_CpuHigh  (BALQEROW06A12).

Data to the Windows clipboard

  1. In the chart pane, right-click the chart and select Export > Data to Clipboard.

  2. Select the appropriate export options and click OK.

  3. Paste the data into a text editor.

Data to a text file

  1. In the chart pane, right-click the chart and select Export > Data to File.

  2. Specify the export path and file name, select the appropriate export options, and click OK.

Chart to the Windows clipboard as a .png image

  1. In the chart pane, right-click the chart and select Export > Image to Clipboard.

  2. Paste the image into any application that accepts a .png image.

Chart to a .png file

  1. In the chart pane, right-click the chart and select Export > Image to File.

  2. Select the export location, specify a file name, and click Save.

Selecting a Range of Data Points for Export

When exporting chart data, you can export all data or only the range of data you select.

To select a range of data points:

  1. In the chart pane, right-click the chart and select Select Data.

    A vertical bar appears in the chart pane.

  2. Position the vertical bar at the point where you want to begin your selection.

  3. Click and drag to highlight the desired data points.

  4. Export the data.

    For more information about exporting data, see Section 11.4.9, Exporting Chart Information.

11.4.10 Setting Chart Console Preferences

Preferences control how the Chart Console operates.

Changes to the Chart Console preferences apply only to the current user and QDB.

Preference

Description

Refresh Interval

Frequency with which the Chart Console updates data points for each chart in the currently selected group.

The default interval is once per minute. At each interval, the Chart Console updates the data streams in the chart snapshots and the current chart (if you are viewing one) to include data points collected since the previous interval.

To improve overall performance of the Chart Console, reduce the number of data points that must be updated during a refresh interval by organizing charts into several groups. For more information about creating groups, see Section 11.4.4, Organizing Charts into Groups.

Chart Snapshots: Fetch no more than n points

Maximum number of data points returned for chart snapshots.

The default is 50 data points. If you specify 0, all points are returned.

As a rule, you can improve overall performance of the Chart Console by reducing the number of data points returned for chart snapshots.

Image Width

Width, in pixels, of chart snapshots.

The default is 280 pixels.

Image Height

Height, in pixels, of chart snapshots.

The default is 190 pixels.

Charts: Fetch no more than n points

Maximum number of data points returned for charts.

The default is 2,000 data points. If you specify 0, all points are returned.