TopN Reports

TopN Report Settings

You can click Run Report to run a TopN report with the default settings to get a table of the most utilized interfaces in & out for today. Trending time span columns display utilization data for the Trending settings you select. The unit of measure displays: us=microseconds, ms=milliseconds, number=numeric, b=bits, B=bytes, etc. Settings enable you to define the granularity and other report parameters. See the Trending Calculations section below for an explanation of the calculations used to display trends.

TopN views enable you to define the indicators, aggregation, and filters for the report content. See the Manage TopN Views section below.

1. Click the Report View drop-down and select a view. See the Manage TopN Views section for how to use the Add, Edit, and Delete buttons.

2. In the Group section, click the Grouping drop-down.

   • Select Device, then click the Device drop-down and select the devices on which to report.

   • Select Device Group, then click the Device Group drop-down and select the device groups/device types on which to report.

   • Select Object Group, then click the Object Group drop-down and select the object groups on which to report.

3. If you select multiple device groups or object groups, select one of the following options.

   • Select Members of Any to include devices as an OR operator, (e.g., run a report for devices that are either in Group 1 OR in Group 2 OR in Group 3).

   • Select Members of All to include devices as an AND operator, (e.g., run a report for devices that are in all groups you select; in Group 1 AND in Group 2 AND in Group 3).

4. In the Trending section on the Historical tab, select the check box for each historical trend to graph. TopN reports can include multiple historical and projected time spans. This enables you to graph overall changes over time on one report. The time span header in the TopN report displays the actual time span used, which may be slightly different from the requested time span. This does not affect the data returned.

   Example: A report can list the top 10 most utilized interfaces for this month, and show their utilization for today and over the last three months. See the Trending Calculations section below.

   • Select Today to display data from 12:00am until now.

   • Select Past 24 Hours to display data from 24 hours ago until now.

   • Select Yesterday to display data from 12:00am yesterday until 12:00am today.

   • Select Past Week to display data from the past seven days.

   • Select Past Month to display data from the past month.

   • Select Past Three Months to display data from the past three months.

   • Select Past Specify _____ Days/Weeks/Months/Years to define the time span from which to display data.

   • Select Specify to specify the number of days, weeks, months, or years from which to display data.

     The shorttermhourly table is loaded in 2 hour intervals. Due to this, in almost every scenario, reports for the Past <n> Hours and Today intervals do not match.

5. In the Trending section on the Projected tab, select the check box for each projected trend to graph. See the Trending Calculations section below.

   • Select Next Week to project data for the next seven days.

   • Select Next Month to project data for the next month.

   • Select Next Three Months to project data for the next three months.

   • Select Next Six Months to project data for the next six months.

   • Select Next Year to project data for the next year.

   • Select Next Specify _____ Days/Weeks/Months/Years to define the time span for which to project data.

6. In the Options section, click the Sort By drop-down and select the time span on which to sort the data. Available options are dependent on the selections you make in the Trending section. This is important when you select several time span options.

7. Click the Granularity drop-down. Available options are dependent on the selection you make in the Trending section.

   • Select Auto to use the fastest/most applicable frequency aggregation.

   • Select Hourly to use data stored in hourly buckets. The Cluster Manager > Cluster Settings tab enables you to define how long to store data in hourly buckets. Hourly buckets are useful when the time span is less than one week.

   • Select Daily to use data stored in daily buckets. The Cluster Manager > Cluster Settings tab enables you to define how long to store data in daily buckets. Daily buckets are useful when the time span is between the one week and three months.

   • Select Weekly to use data stored in weekly buckets. Data stays in weekly buckets for 365 days. Weekly buckets are useful when the time span is between three months and one year.

   • Select Monthly to use data stored in monthly buckets. Data stays in monthly buckets for 730 days. Monthly buckets are useful when the time span is between one year and two years.

8. Click the Percentage drop-down.

   • Select Only Sorted to display data for the time span you select in the Sort By field as a percentage. All data also displays as numbers of bits, bytes, or the indicator's native unit of measure. The results sort on the percentage column and any data that cannot be converted to a percentage is excluded from all columns.

     Note: Data sorts by the one column that displays percentages. Only indicator data that can be converted to a valid percentage based on the indicator having a defined maximum value appears in the report.

   • Select All Percentage to display only percentage data. Data that cannot be converted to a percentage is excluded.

   • Select No Percentage to display data as numbers of bits, bytes, or the indicator's native unit of measure. The results sort by your Sort Order selection.

9. In the Result Limit field, enter the number of results to display.

10. Click the Sort Order drop-down and select Ascending to sort data in ascending order or select Descending to sort data in descending order.

11. Click the Preferred Units drop-down and select Bits to format the unit of measure as bits where applicable. If the unit of measure is not compatible to bits and you select this option the report displays the unit of measure of the first indicator type in the view. Select Bytes to format the unit of measure in bytes. This setting is not applicable if you select All Percentage in the Percentage field.

12. When you select to Sort By a projected time span, you can define a threshold to determine when the data will drop below or exceed the value you define. Perform the following steps in the Days To Threshold field to define a data threshold.

    • Leave the first drop-down at None, the numeric field at 0 (zero), and the second drop-down at Percent (default) to not define a threshold.

    • Click the first drop-down and select Less Than, enter the threshold value in the numeric field, and click the second drop-down to select the unit of measure to define a threshold for declining values.

    • Click the first drop-down and select Greater Than, enter the threshold value in the numeric field, and click the second drop-down to select the unit of measure to define a threshold for increasing values.

      Example

      This is trying to project in how many days you will reach the threshold based on the past data trend. Let's say your object per partition has an indicator with Available space currently at 1GB, the total at 100GB, and it is filling up at the rate of 0.1GB per day for the past 1-month. Based on this, the threshold you have set is greater than 90%. It will try to predict how many days you have until you hit this threshold. The values totally depend on the maximum value, the past data, and the threshold selected.

13. Select the Display R Value (Certainty) check box to display the percentage of data points that were relevant to the display of a projected trend.

14. Select the Exceeding Only check box to only display objects projected to exceed 100 percent for the time span you select. This check box is enabled when you select a projected time span in the Sort By field.

15. Select the Object Descriptions check box to display object descriptions.

16. Select the Abbreviate Numbers check box to abbreviate large numbers (e.g., 5000 becomes 5K). Leave clear to enter the data precision in the Precision field.

17. Select the Use Work Hours check box to include data for the work hours that you associate with the device on the Edit Device page.

18. Click Run Report.

TopN Report Interactions

TopN reports provide the following tools to enable you to manage the report data and to drill down for additional detail.

• CSV - Click to export the report to a .csv format.

• PDF - Click to export the report to a .pdf format.

• Detach - Click to add the TopN report as an attachment in a report on a new browser tab. You can modify reports to add other attachments and you can save reports to the Report Manager. Report workflows enable you to designate reports to be your favorite reports and to define one report to appear as your custom dashboard.

• Click in the Device Name column to display a link to the Device Summary and links to applicable report templates.

• Click in the Object Name column to display a link to the Object Summary and links to applicable report templates.

• Click any value to add a Performance Metrics attachment in a report on a new browser tab for the data you click. Any subsequent values you click appear as additional attachments in the report on the other browser tab that you are currently not viewing.

• Select the check box for each result to include in the report and click a value in a trending time span column for one of the objects you select to add a Performance Metrics attachment in a report that contains the data for the objects you select over the trend time span for the column in which you click.

Manage TopN Views

Views enable you to define the indicators, aggregation, and filters for the report content. SevOne NMS provides starter set TopN views to enable you to create common TopN reports. You can use these views to create custom TopN views for the indicators in your network.

From the TopN Reports page click, Add View or Edit View to display a pop-up that enables you to manage the TopN views you use to create TopN reports.

Each step in this section is dependent on the preceding step.

1. In the Report ViewName field, enter the name of the view. When you edit a view, this field displays the view name. If the view is a starter set view you must change the name before you can save your changes.

2. Click the Plugin drop-down and select the plugin that polls the object type on which to report.

3. Click the Object Type drop-down and select the object type that contains the indicator on which to report.

4. Select the Only Display Common Subtypes check box to filter the Object Subtype list to display only object subtypes you mark as Common on the Object Subtype Manager.

5. Click the Object Subtype drop-down and select an object subtype.

6. Click the Indicator Type drop-down and select the indicator type on which to report.

7. In the Indicator Alias field, enter the indicator name to display in the report.

   Example: To have an Octets indicator display as Incoming Bandwidth.

8. Click the Aggregation drop-down.

   • Select Average to average all data in each data bucket to create the data point for each bucket.

   • Select Maximum to find the maximum value in each data bucket to create the data point for each bucket.

   • Select Minimum to find the minimum value in each data bucket to create the data point for each bucket.

   • Select Percentile. An additional field appears to enable you to enter a percentile. Indicators for which you select Percentile do not appear in reports for projected time spans and a report view must contain at least one indicator that is something other than Percentile.

9. Click the Filter Options drop-down and select a comparison operator to filter results. If you select a comparison operator other than None, fields appear to enable you to enter a filter value and to select the unit of measure for the filter value.

10. Select the Sorted Data check box to enable users to sort the results on the data from this indicator. Leave clear to display data for the indicator in the report without the ability to sort the report on its data. This check box is not applicable for indicators for which you select Percentile in the Aggregation field above.

11. Click Add Indicator to add the indicator to the Current Indicators list and to the view.

12. Repeat the previous steps to add additional indicators to the Current Indicators list and to the view.

13. Select an indicator in the list and click Clone to add a copy of the indicator that you can tweak in the fields above.

14. In the current indicators list, click the Default Direction drop-down and select to sort data in either Ascending or Descending order.

15. Click Save.