Reporting tool
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.
nscollect, and stop or start its operation.
Using the reporting tool
Invoke the reporting tool
-
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. -
In the User Name text box, type the user name assigned to the NetScaler.
-
In the Password text box, type the password.
-
In the Start in drop-down list box, select Reporting.Click Login.
Working 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
Display a built-in report
-
In the left pane of the Reporting tool, under Built-in Reports, expand a group (for example, SSL).
-
Click a report (for example, SSL > All Backend Ciphers).
Creating and deleting reports
Create a custom report
-
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.
-
In Report Name box, type a name for the custom report.
-
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 the Click to add folder icon, in Folder Name, type the name of the folder, and in Create in, specify where you want the new folder to reside in the hierarchy, and then click OK.
-
Delete a custom report
-
In the left pane of the Reporting tool, next to Custom Reports, click the Click to manage the custom reports icon.
-
Select the check box 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
Modify the time interval
-
In the left pane of the Reporting tool, click a report.
-
On the report toolbar, click Duration, and then click a time interval.
Setting the data Source and time zone
Set the data source and time zone
-
In the Reporting tool, on the report toolbar, click Settings.
-
In the Settings dialog box, in Data Source, select the data source from which you want to retrieve the counter information.
-
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 check box.
-
If you want the reports to use the time settings of your NetScaler appliance, select the Use Appliance’s time zone check box.
-
Exporting and importing custom reports
Export or import custom reports
-
In the left pane of the Reporting tool, next to Custom Reports, click the Click to manage custom reports icon.
-
Select the check box 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
Adding a chart
Add a chart to a report
-
In the left pane of the Reporting tool, click a report.
-
Under the chart where you want to add the new chart, click the Add icon.
Modifying a chart
Modify a chart
-
In the left pane of the Reporting tool, click a report.
-
Under the chart that you want to modify, click Counters.
-
In the dialog box that appears, in the Title box, type a name for the chart.
-
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.
-
-
In the Select group, click the desired entity.
-
Under Counters, in Available, click one or more counter names that you want to plot, and then click the > button.
-
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.
-
Click OK.
Viewing a chart
Change the graph type of a chart
-
In the left pane of the Reporting tool, select a report.
-
In the right pane, under the chart you want to view, on the chart toolbar, click Customize.
-
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 check box.
Refocus a chart with detailed data
-
In the left pane of the Reporting tool, select a report.
-
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.
-
-
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
-
In the left pane of the Reporting tool, select a report.
-
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
-
In the left pane of the Reporting tool, select a report.
-
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
-
In the left pane of the Reporting tool, select a report.
-
In the right pane, under the chart for which you want to customize the axes, click Customize.
-
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
-
In the left pane of the Reporting tool, select a report.
-
In the right pane, under the chart for which you want to customize the axes, click Customize.
-
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
-
In the left pane of the Reporting tool, select a report.
-
In the right pane, under the chart for which you want to customize the plot area, click Customize.
-
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
-
In the left pane of the Reporting tool, select a report.
-
In the right pane, under the chart for which you want to customize the display of the data set (counters), click Customize.
-
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.
-
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 check box.
-
Exporting chart data to excel
-
In the left pane of the Reporting tool, select a report.
-
In the right pane, under the chart with the data you want to export to Excel, click Export.
Deleting a chart
Delete a chart
-
In the left pane of the Reporting tool, select a report.
-
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
-
In the left pane of the Reporting tool, under Built-in Reports, expand System.
-
Click the report CPU versus Memory Usage and HTTP Requests Rate.
-
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
-
In the right pane, on the report toolbar, click Create.
-
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.
-
Under System Overview, on the chart toolbar, click Counters.
-
In the counter selection pane, in Title, type a name for the chart (for example, Interfaces bytes data).
-
In Plot chart for, click System entities statistics, and then in Select Group, select Interface.
-
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.
-
On the Counters tab, click Bytes received (Rate) and Bytes transmitted (Rate) and then click the > button.
-
Click OK.
-
On the report toolbar, click Duration, and then click Last Week.
Stopping and starting 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.
/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>.
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.
Stop nscollect
/netscaler/nscollect stop
/netscaler/nscollect start
/netscaler/nscollect start &