DX Unified Infrastructure Management

Hi,

Is it possible to write a sql query for my problem below? 

I need for only one specific network interface a conversion from bits/s or bytes/s to Mb/s?

Because I want to use this value in a graph or text field in my UIM dashboard.

I am not a SQL expert! :-)

Regards,

      Jurgen

Hello Jurgen,

     The data you whant are on an exterior database, or are on QOS format?

     If they are on a database, it will be necessary that database schema to provide you a query.

    If they are on QOS format you can do that on dashboard without a SQL Query.

    First on datasource selection chose advanced datasource 

Then select QOS and create a new one:

then chose the interface QOS, it may be something like QOS_INTERFACE_BITSIN

Create and associate that to the graph, and go to the Serie configuration and select the Serie

Finaly configure the multiplier and you gonna have the result you whant

Hi Renato,

Thanks for your help!

I think I was temporarily blind, because I have not seen this option at all! :-)

Problem solved!

Maybe you have also an answer on this problem?

Also in my dashboard I will show 2 Cisco port channels in one value.

Is it possible to make a sum of two values?

Regards,

  Jurgen

Hello, I think that there is no easy way to do that, take a look on that thread:

Displaying aggregate/summed data in UMP 

If it is possibly i recommend you to use Unified Reporter or CABI for that

Regards,

Thx Renato! :-)