DX Unified Infrastructure Management

  • 1.  Dashboard / SQL help

    Posted Sep 21, 2017 07:12 AM

    From this blogpost UIM Dashboard Example - Network Device Summary with Context Selector and Metric Conversion 

     

    The example above uses QoS from the snmpcollector probe.

     

    Instead, I want to take it from the interface_traffic probe. Since the column "qos" in the table only cointains QOS_INTERFACE_TRAFFIC for this probe I have to look in the target column which specifies in or out data.

     

    Below is part of Bryans SQL.

    (select a.interface, a.utilization_in, b.utilization_out from
    (select z.target as interface, y.samplevalue as utilization_in from s_Qos_data z
    join s_qos_snapshot y
    on z.table_id = y.table_id
    where z.source = '${device}'

    and z.qos = 'qos_interface_utilizationin') a

    I have tried adding the bold line, but it returns no data.

    where z.source = '${device}'

    and z.target = 'IN-FC port 0/15'

    and z.qos = 'qos_interface_traffic') a

    Why is this?

     

    Thank you.



  • 2.  Re: Dashboard / SQL help
    Best Answer

    Broadcom Employee
    Posted Sep 21, 2017 11:47 AM

    you will need to put the sql query into your SQL studio and debug it.

    I would think it would be virtually impossible to debug here.

    I would start by removing the where clause and see if it works.

    if it does add back the where clause one part at a time and see where it breaks

    then figure out why the option that breaks it is wrong and correct.

     

    If you test this in sql studio and you get an error and can provide that we might be able to shed some light on the problem.



  • 3.  Re: Dashboard / SQL help

    Posted Sep 22, 2017 04:21 AM

    I finally did and somehow solved it myself!

     

    Thank you!

     

    /Kenneth