Product Documentation
ADC
14.1 - Current Release 13.1 13.0 12.1
View PDF

Reporting tool

September 25, 2024
Contributed by: 
C S C

Use the Citrix® NetScaler® Reporting tool to view NetScaler performance statistics data as reports. Statistics data are collected by the nscollect utility and are stored in a database. When you want to view certain performance data over a period, the Reporting tool pulls out specified data from the database and displays them in charts.

Reports are a collection of charts. The Reporting tool provides built-in reports and the option to create custom reports. In a report, you can modify the charts and add new charts. You can also modify the operation of the data collection utility, nscollect, and stop or start its operation.

Using the reporting tool

The Reporting tool is a web-based interface accessed from the Citrix® NetScaler® appliance. Use the Reporting tool to display the performance statistics data as reports containing graphs. In addition to using the built-in reports, you can create custom reports, which you can modify at any time. Reports can have between one and four charts. You can create up to 256 custom reports. You can create a custom report for any number of entities.

Invoke the reporting tool

  1. Use the Web browser of your choice to connect to the IP address of the NetScaler (for example, http://10.102.29.170/). The Web Logon screen appears.
  2. In the User Name text box, type the user name assigned to the NetScaler.
  3. In the Password text box, type the password.
  4. In the Start in drop-down list box, select Reporting and click Login.

The following screenshots show the report toolbar and the chart toolbar, which are frequently referenced in this documentation.

Figure 1. Report Toolbar

Report option

Figure 2. Chart Toolbar

Report options

Working with reports

You can plot and monitor statistics for the various functional groups configured on the NetScaler over a specified time interval. Reports enable you to troubleshoot or analyze the behavior of your appliance. There are two types of reports: built-in reports and custom reports. Report content for built-in or custom reports can be viewed in a graphical format or a tabular format. The graphical view consists of line, area, and bar charts that can display up to 32 sets of data (counters). The tabular view displays the data in columns and rows. This view is useful for debugging error counters.

The default report that is displayed in the Reporting tool is CPU versus Memory Usage and HTTP Requests Rate. You can change the default report view by displaying the report you want as your default view, and then clicking Default Report.

Reports can be generated for the last hour, last day, last week, last month, last year, or you can customize the duration.

You can do the following with reports:

  • Toggle between a tabular view of data and a graphical view of data.
  • Change the graphical display type, such as bar chart or line chart.
  • Customize charts in a report.
  • Export the chart as an Excel comma-separated value (CSV) file.
  • View the charts in detail by zooming in, zooming out, or using a drag operation (scrolling).
  • Set a report as the default report for viewing whenever you log on.
  • Add or remove counters.
  • Print reports.
  • Refresh reports to view the latest performance data.

Using built-in reports

The Reporting tool provides built-in reports for frequently viewed data. Built-in reports are available for the following functional groups: System, Network, SSL, Compression, Integrated Cache, NetScaler Gateway, and NetScaler Application Firewall. By default, the built-in reports are displayed for the last day. However, you can view the reports for the last hour, last week, last month, or last year.

Note:

You cannot save changes to built-in reports, but you can save a modified built-in report as a custom report.

Display a built-in report

  1. In the left pane of the Reporting tool, under Built-in Reports, expand a group (for example, SSL).
  2. Click a report (for example, SSL > All Backend Ciphers).

Creating and deleting reports

You can create your own custom reports and save them with user-defined names for reuse. You can plot different counters for different groups based on your requirements. You can create up to 256 custom reports.

You can either create a report or save a built-in report as a custom report. By default, a newly created custom report contains one chart named System Overview, which displays the CPU Usage counter plotted for the last day. You can customize the interval and set the data source and time zone from the report toolbar.

Create a custom report

  1. In the Reporting tool, on the report toolbar, click Create, or if you want to create a custom report based on an existing report, open the existing report, and then click Save As.
  2. In Report Name box, type a name for the custom report.
  3. Do one of the following:
    • To add the report to an existing folder, in Create in or Save in, click the down arrow to choose an existing folder, and then click OK.
    • To create a new folder to store the report, click Add folder. Type the name of the folder, and specify where you want the new folder to reside in the hierarchy, and then click OK.

Note: You can create up to 128 folders.

Delete a custom report

  1. In the left pane of the Reporting tool, next to Custom Reports, click the Click to manage the custom reports icon.
  2. Select the checkbox that corresponds with the report you want to delete, and then click Delete.

    Note:

    When you delete a folder, all the contents of that folder are deleted.

Modifying the time interval

By default, built-in reports display data for the last day. However, if you want to change the time interval for a built-in report, you can save the report as a custom report. The new interval applies to all charts in the report. The following table describes the time-interval options.

Modify the time interval

  1. In the left pane of the Reporting tool, click a report.
  2. On the report toolbar, click Duration, and then click a time interval.

Setting the data Source and time zone

You can retrieve data from different data sources to display them in the reports. You can also define the time zone for the reports and apply the currently displayed report’s time selection to all the reports, including the built-in reports.

Set the data source and time zone

  1. In the Reporting tool, on the report toolbar, click Settings.
  2. In the Settings dialog box, in Data Source, select the data source from which you want to retrieve the counter information.
  3. Do one or both of the following:
    • If you want the tool to remember the time period for which a chart is plotted, select the Remember time selection for charts checkbox.
    • If you want the reports to use the time settings of your NetScaler appliance, select the Use Appliance’s time zone checkbox.

Exporting and importing custom reports

You can share reports with other NetScaler administrators by exporting reports. You can also import reports.

Export or import custom reports

  1. In the left pane of the Reporting tool, next to Custom Reports, click the Click to manage custom reports icon.
  2. Select the checkbox that corresponds with the report you want to export or import, and then click Export or Import.

    Note:

    When you export the file, it is exported in a .gz file format.

Working with charts

Use charts to plot and monitor counters or groups of counters. You can include up to four charts in one report. In each chart, you can plot up to 32 counters. The charts can use different graphical formats (for example, area and bar). You can move the charts up or down within the report, customize the colors and visual display for each counter in a chart, and delete a chart when you do not want to monitor it.

In all report charts, the horizontal axis represents time and the vertical axis represents the value of the counter.

Adding a chart

When you add a chart to a report, the System Overview chart appears with the CPU Usage counter plotted for the last one day.

Note:

If you add charts to a built-in report, and you want to retain the report, you must save the report as a custom report.

Use the following procedure to add a chart to a report.

Add a chart to a report

  1. In the left pane of the Reporting tool, click a report.
  2. Under the chart where you want to add the new chart, click the Add icon.

Modifying a chart

You can modify a chart by changing the functional group for which the statistics are displayed and by selecting different counters.

Modify a chart

  1. In the left pane of the Reporting tool click a report.
  2. Under the chart that you want to modify click Counters.
  3. In the dialog box that appears, in the Title box, type a name for the chart.
  4. Next to the Plot chart for, do one of the following:
    • To plot counters for global counters, such as Integrated Cache and Compression, click System global statistics.
    • To plot entity counters for entity types, such as Load Balancing and GSLB, click System entities statistics.
  5. In the Select group, click the desired entity.
  6. Under Counters, in Available, click one or more counter names that you want to plot, and then click the > button.
  7. If you selected System entities statistics in step 4, on the Entities tab, under Available, click one or more entity instance names you want to plot, and then click the > button.
  8. Click OK.

Viewing a chart

You can specify the graphical formats of the plotted counters in a chart. Charts can be viewed as line charts, spline charts, step-line charts, scatter charts, area charts, bar charts, stacked area charts, and stacked bar charts. You can also zoom in, zoom out, or scroll inside the plot area of a chart. You can zoom in or out for all data sources for 1 hour, 1 day, 1 week, 1 month, 1 year, and 3 years.

Other options for customizing the view of a chart include customizing the axes of the charts, changing the background and edge color of the plot area, customizing the color and size of the grids, and customizing the display of each data set (counter) in a chart.

Data set numbers, such as Data Set 1, correspond to the order in which the counters in your graph are displayed at the bottom of the chart. For example, if CPU usage and Memory usage are displayed in first and second order at the bottom of the chart, CPU usage is equal to Data Set 1 and Memory usage is equal to Data Set 2.

Whenever you modify a built-in report, you need to save the report as a custom report to retain your changes.

Change the graph type of a chart

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, under the chart you want to view, on the chart toolbar, click Customize.
  3. On the Chart tab, under Category, click Plot type, and then click the graph type you want to display for the chart. If you want to display the graph is 3D, select the Use 3D checkbox.

Refocus a chart with detailed data

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, on the report toolbar, click Zoom In, and do one or both of the following:
    • To refocus the chart to display data for a specific time window, drag the cursor from the start time to the end time. For example, you can view data for a one-hour period on a certain day.
    • To refocus the chart to display data for a data point, simply click once on the chart where you want to zoom in and get more detailed information.
  3. Once you have the desired range of time for which you want to view detailed data, on the report toolbar, click Tabular View. Tabular view displays the data in numeric form in rows and columns.

View numeric data for a graph

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, on the report toolbar, click Tabular View. To return to the graphical view, click Graphical View.

    Note: You can also view the numeric data in the graphical view by hovering your cursor over the notches in the gridlines.

Scroll through time in a chart

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, on the report toolbar, click Scroll, and then click inside the chart and drag the cursor in the direction for which you want to see data for a new time period. For example, if you want to view data in the past, drag to the left.

Change the background color and text color of a chart

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, under the chart for which you want to customize the axes, click Customize.
  3. On the Chart tab, under Category, click one or more of the following:
    • To change the background color, click Background Color, and then select the options for color, transparency, and effects.
    • To change the text color, click Text Color, and then select the options for color, transparency, and effects.

Customize the axes of a chart

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, under the chart for which you want to customize the axes, click Customize.
  3. On the Chart tab, under Category, click one or more of the following:
    • To change the scale of the left y-axis, click Left Y-Axis, and then select the scale you want.
    • To change the scale of the right y-axis, click Right Y-Axis, in the data set to plot, select the date set, and then select the scale you want.

      Note: The data set numbers, such as Data Set 1, correspond to the order in which the counters in your graph are displayed at the bottom of the chart. For example, if CPU usage and Memory usage are displayed in first and second order at the bottom of the chart, CPU usage is equal to Data Set 1 and Memory usage is equal to Data Set 2.

    • To plot each data set in its own hidden y-axis, click Multiple Axes, and then click Enable.

Change the background color, edge color, and gridlines for a plot area of a chart

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, under the chart for which you want to customize the plot area, click Customize.
  3. On the Plot Area tab, under Category, click one or more of the following:
    • To change the background color and edge color of the chart, click Background Color and Edge Color, and then select the options for color, transparency, and effects.
    • To change the horizontal or vertical grids of the chart, click Horizontal Grids or Vertical Grids, and then select the options for displaying the grids, grid width, grid color, transparency, and effects.

Change the color and graph type of a data set

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, under the chart for which you want to customize the display of the data set (counters), click Customize.
  3. On the Data Set tab, in Select Data Set, select the data set (counter) for which you want to customize the graphical display. Note: The data set numbers, such as Data Set 1, correspond to the order in which the counters in your graph are displayed at the bottom of the chart. For example, if CPU usage and Memory usage are displayed in first and second order at the bottom of the chart, CPU usage is equal to Data Set 1 and Memory usage is equal to Data Set 2.
  4. Under Category, do one of more of the following:
    • To change the background color, click Color, and then select the options for color, transparency, and effects.
    • To change the graph type, click Plot type, and then select the graph type you want to display for the data set. If you want to display the graph as 3D, select the Use 3D checkbox.

Exporting chart data to excel

For further data analysis, you can export charts to Excel in a comma-separated value (CSV) format.

To export chart data to excel

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, under the chart with the data you want to export to Excel, click Export.

Deleting a chart

If you do not want to use a chart, you can remove it from the report. You can permanently remove charts from custom reports only. If you delete a chart from a built-in report and want to retain the changes, you need to save the report as a custom report.

Delete a chart

  1. In the left pane of the Reporting tool, select a report.
  2. In the right pane, under the chart that you want to delete, click the Delete icon.

Examples

Display the trend report for CPU usage and memory usage for the last week

  1. In the left pane of the Reporting tool, under Built-in Reports, expand System.
  2. Click the report CPU versus Memory Usage and HTTP Requests Rate.
  3. In the right pane, on the report toolbar, click Duration, and then click Last Week.

Compare the bytes received rate and the bytes transmitted rate between the two interfaces for the last week

  1. In the right pane, on the report toolbar, click Create.
  2. In the Report Name box, type a name for the custom report (for example, Custom_Interfaces), and then click OK. The report is created with the default System Overview chart, which displays the CPU Usage counter plotted for the last hour.
  3. Under System Overview, on the chart toolbar, click Counters.
  4. In the counter selection pane, in Title, type a name for the chart (for example, Interfaces bytes data).
  5. In Plot chart for, click System entities statistics, and then in Select Group, select Interface.
  6. On the Entities tab, click one or more interface names you want to plot (for example, 1/1 and 1/2), and then click the > button.
  7. On the Counters tab, click Bytes received (Rate) and Bytes transmitted (Rate) and then click the > button.
  8. Click OK.
  9. On the report toolbar, click Duration, and then click Last Week.

Stopping and starting the data collection utility

The data collection utility, nscollect, runs automatically when you start the NetScaler. This utility retrieves the application performance data and stores it in the form of data sources on the ADC. You can create up to 32 data sources. The default data source is /var/log/db/default.

The data collection utility creates databases for global counters and entity-specific counters, and uses this data to generate reports. Global-counter databases are created at /var/log/db/<DataSourceName>. The entity-specific databases are created based on the entities configured on the NetScaler, and a separate folder is created for each entity type in /var/log/db/<DataSourceName/EntityNameDB>.

The nscollect retrieves data once every 5 minutes. It keeps data in 5-minute granularity for one day, hourly for the last 30 days, and daily for three years.

You might have to stop and restart the data collection utility if data is not updated accurately or the reports display corrupted data.

Stop nscollect

At the command prompt, type:

/netscaler/nscollect stop

Start nscollect on the current SSH session to the NetScaler:

At the command prompt, type: /netscaler/nscollect start

Start nscollect on the local system:

At the command prompt, type: /netscaler/nscollect start &

Monitor the NetScaler entities

The reporting tool is enhanced to monitor the entities. This functionality provides you the flexibility to monitor the selected entities in the reporting tool. You can add or remove the entities in the database.

How monitoring works

The reporting tool configuration allows you to specify which entities to monitor. When an entity type is selected for monitoring, data for other entities of the same type that were previously monitored stops being recorded. However, entities of different types continue to be monitored.

For instance, the reporting process supports up to 50 content switching virtual servers, 1000 load balancing virtual servers, and 2500 services. If 5000 load balancing virtual servers are configured on NetScaler, data for only the first 1000 load balancing virtual servers is stored in the database, while the rest is ignored. The reporting tool configuration allows you to choose which entities’ data to store and which to ignore. However, the overall threshold limit remains constant.

Configure monitoring of an entity by using the CLI

At the command prompt, type: add reportingconfig <entity> <name>

Example: add reportingconfig lbvserver -name lbv1

The preceding command monitors the lbv1 entity. The load balancing virtual servers that were monitored earlier are stopped.

Disable monitoring of an entity by using the CLI

At the command prompt, type: rm reportingconfig <entity> <name>

Example: rm reportingconfig lbvserver -name lbv1

The preceding command removes the lbv1 entity from getting monitored. If this entity is the last entity that is removed from flexible monitoring, then the monitoring continues in the conventional way.

View the list of entities that are being monitored by using the CLI

At the command prompt, type: show reportingconfig <entity> <name>

Example: show reportingconfig lbvserver

The preceding command lists all the load balancing servers that are actively monitored.

Configure monitoring of an entity by using the GUI

Follow these steps to add or remove the required entities using the GUI interface.

  1. Navigate to System > Reporting Configs.
  2. Click Add to add the required entities.

Notes:

  • Select the required entity and click Delete to remove the selected entity.

  • The reporting process is refreshed every five minutes.

System-level reporting

The reporting tool configuration allows you to set the threshold limit at the system level rather than at the individual entity level. This feature enables you to add any required entities for monitoring, up to the system-wide threshold limit.

When using system-level reporting, the following conditions must be considered:

  • Entities must be configured using the add reportingconfig command.
  • Entities that were previously configured using conventional methods stops being monitored. You must use the add reportingconfig command to re-enable monitoring for these entities.
  • The threshold limits for entities are monitored at the system level, rather than at the individual entity level.
  • Users can monitor up to 3000 load balancing virtual servers assuming that no other entities are configured. This capacity allows for extensive monitoring and reporting on system performance and health.

Enable the system-level reporting by using the CLI

At the command prompt, type: enable systemLevelReporting

The preceding command enables system-level reporting. As a result, monitoring using conventional methods is stopped for previously monitored entities. However, entities that were added through flexible monitoring are continued to be monitored.

Disable the system-level reporting by using the CLI

At the command prompt, type: disable systemLevelReporting

Show the system-level reporting

At the command prompt, type: show systemLevelReporting

The preceding command lists the details of the system-level reporting.

Enable or disable the system-level reporting by using the GUI

  1. Navigate to System > Reporting Configs.
  2. Click Select Action

  3. Select SystemLevelReporting from the list.

    You can enable or disable the system-level reporting by choosing the required option.

Reporting tool
September 25, 2024
Contributed by: 
C S C
September 25, 2024
Contributed by: 
C S C

In this article

Site feedback | Your privacy choices footer linkYour Privacy Choices | Privacy and legal terms | Cookie preferences | Consent settings | docs.cloud.com
© 1999- Cloud Software Group, Inc. All rights reserved.