[NOM] Scheduled reports on specific interfaces

Hey all
So, with the migration from NPS to NOM I have to take over some reports we generate regularly on NPS. Basically it's a report of usually two interfaces a customer is connected to and include some visualization of volume in/out and/or availability over the last rolling month.

I think the way to do this in NOM would be to create a new dashboard that we then can schedule. So far I played around a little bit with the "Multi Time Series Line Chart" stencil but don't really understand how to properly define the data channel / data fields for this use-case in the Dashboard Management. Well, I'm generally failing to get any time-related data :(

Before I go "deep" into the stencil / dashboard topic: Would you follow the same concept of creating a dashboard for reports like this? Or would you just design it in the Troubleshooter and save/schedule from there?

And if you have some experience with creating your own dashboards: Is it correct that I would have to create my own query if I want to have values like Volume in/out of a specific interface? For example the nom_if_head_line has Volume in/out but from what I see only for interface-groups.
Is it possible to have multiple time-frames on one dashboard? So for example two graphs with one showing Volume In/out of the last rolling month and another one for the last rolling week?

Br

Ben

  • Suggested Answer

    0  

    Hello Ben,

    we use Predefined Queries with Flex Reporting for this use case (no BVD with MS Visio and no PT Widgets as we spotted that old PT widgets don't work after upgrade from 2023.05 to 23.4). You can start with this as new data query (variable nomifname already exist as parameter query):

    select netif_qname AS QualifiedInterfaceName
    , node_name AS NodeName
    , UTILIZATION_IN_AVG_PCT AS UtilInAvg
    , UTILIZATION_OUT_AVG_PCT AS UtilOutAvg
    , throughput_in_avg_mbit_per_s AS ThroughputInMbitPerSec
    , throughput_out_avg_mbit_per_s AS ThroughputOutMbitPerSec
    , discard_in_max_pct AS DiscardsInMaxPct
    , discard_out_max_pct AS DiscardsOutMaxPct
    , error_in_max_pct AS ErrorsInMaxPct
    , error_out_max_pct AS ErrorsOutMaxPct
    , TIMESTAMP_TZ AS timestamp
    from "mf_shared_provider_default"."nom_interface_health_1h"
    WHERE ${netif_qname in (${nomifname})}
    order by TIMESTAMP_TZ

    You can save the first dashboard, then just change the interfaces in the top and save the dashboard as a new instance.

    The result might be like this:

    HTH and best regards

    Allessandro



    Allessandro Soloperto
    ITC GmbH - Senior Consultant
    If this answered your question, please mark it as "Suggest as Answer" or "Verify as Answer".
    If you found this response useful, please give it a "Like".