Select Page

How to Build Device Metrics Chart/Table sub-reports in ENA?

Building sub-reports for Composite Reports in Entuity Network Analytics (ENA)

An Introduction

This article is going to show you an example of building custom reports that can be used as sub-reports for a Composite report in Entuity Network Analytics and provides better control of your network management as you navigating around your network.

What you’ll Learn

  • Device Metrics Chart/Table
  • Sub-reports
  • Composite Reports
  • Entuity Network Analytics
  • Network Management

Time

12 min

I am going to illustrate how a pair of basic reports can be built in readiness for later inclusion in a composite report, which is the subject of a separate tutorial video. There’s a separate dedicated tutorial video explaining how to build a multi chart and table report which covers several concepts. In this example, we are going to generate two reports: the first one will display a chart and table that each Device in a View (Device Metrics Chart and Table) in this blog and the second report will display separate charts for each operational enabled Ports in a View (Port Utilization Charts) in the following blog.

Report Builder

To build a Multi Chart/Table Report, the appropriate template should be selected from the Report Builder, which is available from the Main Menu→ Reports Page. As we have mentioned on the previous blog, there are four different fundamental templates and in this case, you should select the third one Multi chart/table report template.

Device Metrics Chart and Table

To populate the attributes in this report, I will need to drag attributes from another Attributes Dashboard for the device. As we mentioned on the previous blog “How to Build Time Series Chart Reports in ENA“, in order to make that Dashboard available, you have to firstly duplicate this tab in the same browser window then select the Dashboards using the Explorer and select a Device. And finally, choose the Attributes Dashboard over the All Dashboards Menu.

  • As this is going to be a device basis, choose a device (hq01) from the Explorer.
  • Then select the Attributes Dashboard from the All Dashboards Menu.
  • Sort the attributes into alphabetical order to make it easier to find the attributes.
  • Drag the CPU and Memory Utilization metric up to the Builder tab and down to the first and second entry.

Alternatively, you could also try to drag attributes by using two browser windows.

Editing Tabular Data

The table is going to be used to display both the mean and maximum values of the CPU Utilization% over the period of the report plus a Manufacturer, Model, Version and Serial Number.

  • Create six columns for the attributes before populating them.
  • Drag the CPU Utilization% into the first column. Rather than displaying the last sample in the reporting period, select Mean instead.
  • Drag the CPU Utilization% again and select Maximum as the summarization method.
  • Then follow the same procedure to drag Model, Manufacturer, Version and Serial Number. The summarization method doesn’t need to be defined for these object attributes.

Now, if you take a look at the preview, the report would be like this.

Formatting Tabular Table

We are going to take this opportunity to refine the format of the report the six object attributes listed in the table below. The chart could be displayed in a more compact manner by placing them in three rows of two columns. You can adjust the format of the table by clicking the Organized Layout button.

The resulting dialog shows the default single column tabular layout. The Change Layout button allows the placement of the attributes within the table to be defined.

Various predefined layouts are listed. I would like a single table below the chart with three rows of two columns but that isn’t one of the standard options. Fortunately, there’s an easy way to create a custom tabular layout using the Custom options at the bottom. I will select the Custom option and specify that there is to be a table below the chart with three rows of two columns and none above.

If I prefer the CPU Utilization% Mean to appear on the top line on the left, I could simply drag that attribute to the appropriate table. Cell Utilization Maximum can go next to it on the right. Model can go on the line below on the left and the Manufacturer next to it on the right. I will put the Version on the bottom line on the left and the Serial Number next to it on the right.

Data Source Selection

Before previewing the report, you will need to define where the data comes from. Instead of using the selection technique, here I’m going to use the New York View. This is already selected to Devices by default and this is a Device basis report.

Chart Title

One of the best ways to display the device name in this style of report is to place it into the chart Title which appears in large bold text at the top of each chart. The text is defined in the Chart Title field but I don’t want the static text to be used here. As the title needs to be the actual name of the device, which is decided at runtime, we are going to revise it. Fortunately, there’s an easy way to access the object model of the device directly from this field using the syntax. If I simply want to obtain the value of a device attribute, the name of that attribute can be placed within pound or hash symbols to cause it to be accessed. The attribute that holds the device name is called name so I can simply enter #name#.

let’s preview the result and you can see the chart with the name of the Device in bold characters at the top of each chart, the shortened form of the labels and the six tabular entries in three rows two columns and nothing is spilling over the lines.

ENA Tips:

The chart legend runs the risk of spilling onto two lines because of the length of the descriptions. If you’d really like to make sure it fits on a single line, you can edit the text used to describe each metric. In this case, I am going to shorten the descriptions.

Publishing

Before moving on to the Port report, there is one more change I am going to make to allow this report to be practically used in the Composite Report template. Firstly, I need to strip off the Title Header and remove all of the Margins. When basic reports such as those created using the multi chart/table template are built, they would normally include a Title Header and Margins around all four sides this makes them suitable for printing on their own. When this type of report is intended for inclusion into a composite report, the Title Header and Margins are usually not required and the report builder allows them to be removed.

For this purpose, the standard header can be removed by unchecking Include Standard Header option. The margins can be adjusted by clicking the Report Options control. I am going to set them all to zero. The report is now free of all titles and margins.

I am going to give it a suitable name Device Metrics and publish it.

ENA Tips:

One point you should remember when you build a report and you’re considered to be its owner, which allows you to modify its configuration at a later date via this icon.

Share This