DX NetOps Manager

CA PC OpenAPI app: Interface Top N with Rank 

07-04-2016 03:33 AM


  This sample app displays interface data in a table view:

  • for all interfaces (up to a query limit) in the given group context
  • retrieve standard interface item attributes and for one metric
    • average metric across the given time range with ranking (sort order descending)
    • average metric across the previous time range with ranking
  • metric name, metric column name, minimum value and query limit are passed as parameters, along with the context


Dashboard with two instances of app:

  Please note, the ranking is built in this app. Therefore the number of interfaces in the context group should be less than the query limit


  The app



  CA PM 2.8



  • Download the attached zip archive tableView.zip. Unzip the download and make sure the unzipped folder is named tableView.
  • Copy the folder to the apps/user directory of your CA PC installation. This is normally:
  • There is no need to start or restart PC.



  • In CA PC, create or edit a dashboard. Use layout 1 or 2 (50/50).
  • Add a Browser View to the page. Configure the browser view with:
    • Title: Top N Interface Utilization with Rank (or anything else appropriate)
    • URL (for example): /pc/apps/user/tableView/IfTopNwithRank.html?id={ItemIdDA}&startTime={TimeStartUTC}&endTime={TimeEndUTC}&limit=1000&metric=im_Utilization&metricCol=Utilization&metricMin=0
      which consists of
      id={ItemIdDA}                                   dashboard context (group ID)
      startTime={TimeStartUTC}               dashboard context (start time)
      endTime={TimeEndUTC}                  dashboard context (end time)
      limit=1000                                          query limit: the number of rows retrieved to build the ranking
      metric=im_Utilization                         metric value, basis for average calculation. Must be a valid attribute name in OpenAPI for portmf (interface metric family)
                                                                 see InterfaceMFattributes.txt for a list of names
      metricCol=Utilization                          column title
      metricMin=0                                        minimum value for the metric data
    • Height: 400 (minimun)
  • Save your work
  • The dashboard will display. You may want to select an appropriate context group
  • Additional views can be created to display other interface metrics. Copy the existing as a template.



The ZIP archive also contains DeviceItemCount app. This sample app displays top N devices polled item count for devices in the given group context.

The app also uses DataTable but with direct OpenAPI query. Please review the comments in DeviceItemCount.html


Update 1:

There is an enhanced version that also includes device HostName and PrimaryIPAddress. It also uses a feature to hide/display columns - the Toggle column names are clickable.

In addition to the steps described above, unpack and copy IfTopNwithRankD.html to the tableView directory on CA PC and use that instead of IfTopNwithRank.


Your feedback is appreciated so please post any comments in this thread.  As with all free Infrastructure Management Field Developed Utility postings, inquiries should be made through questions or comments in this thread, and the author, Lutz_Holzbecher, will provide a response.

All information downloaded or accessed (including field packs, customized solutions, patches etc.) are provided AS IS and no warranties are provided or made.  For more information you may click here.

0 Favorited
2 Files
zip file
IfTopNwithRankD.zip   3K   1 version
Uploaded - 05-29-2019
zip file
tableView.zip   186K   1 version
Uploaded - 05-29-2019

Tags and Keywords


10-12-2018 06:40 AM

Hello Akash,

I'm sorry but I am not aware of such a view type.

10-12-2018 06:04 AM



I need this kind of bars that is shown in PC but i need these in the report shown above in column with percentage.

10-10-2018 03:22 AM



I need your help as customer requirement is to show a dashboard having max utilization or peak utilization of interfaces with the percentages shown in bars. Can you help me in this...

05-10-2018 08:03 AM

Hi Lutz, thanks for drafting the app. This is quite useful, however, the customer is seeking for certain improvements such as Trend/Table view like available in Network performance dashboard view available currently. It will enable to view Table cum Trend view on the left side of the table.


10-26-2016 04:14 AM

Its straight forward installed it. Thanks Lutz . Appreciate your time

07-08-2016 09:44 AM

Already installed it!  Nice job.  Thanks.

07-08-2016 04:17 AM

Hi Scott, not sure if you already saw it .. I added "update 1" to the article with an enhanced version of the app.

Hth, Lutz.

07-06-2016 02:24 AM

Hi Scott,

actually this is a good idea I also had in mind. Should be pretty straight forward (expand on device in query builder / this will add device/hostname etc to the query, add columns to the tables). I can look into this during the next couple of days and will let you know.

Thanks, Lutz.

07-05-2016 04:01 PM

Good stuff.  How would I add the parent device to the table?

07-05-2016 03:38 PM

Works great!

Installed & configured in less than 1 minute

Well done!

Related Entries and Links

No Related Resource entered.