DX Unified Infrastructure Management

  • Private Community

  • 1.  Which table has the field "Nominal Speed"

    Posted Oct 17, 2018 05:32 PM

    Hi everyone. I have a question.

     

    Which table has the field "Nominal Speed"?

     

    I am exploring CM_DEVICE_ATTRIBUTE but I don't see anything

    I need create a report with the field:

     

    Hostname | IfName | IfAlias | Nominal Speed ----> Any recommendation?



  • 2.  Re: Which table has the field "Nominal Speed"

    Broadcom Employee
    Posted Oct 18, 2018 12:12 PM

    Can you check CM_SNMP_INTERFACE? I suspect you'll find it there.



  • 3.  Re: Which table has the field "Nominal Speed"

    Broadcom Employee
    Posted Oct 18, 2018 01:25 PM
      |   view attached

    You may try.

     

    select cmd.dev_name, cci.ci_name, ccia.ci_attr_value from CM_CONFIGURATION_ITEM_ATTRIBUTE ccia

    INNER JOIN CM_CONFIGURATION_ITEM cci on cci.ci_id = ccia.ci_id

    INNER JOIN CM_DEVICE cmd on cmd.dev_id = cci.dev_id

     

    where ccia.ci_attr_key = 'NomSpeedInBitsPerSec'

     

     



  • 4.  Re: Which table has the field "Nominal Speed"

    Posted Oct 22, 2018 12:25 PM

    Yu thank you very much.

     

    Is possible that the nominalspeed showing in mbps ?

     

    Like as in USM ---->

     



  • 5.  Re: Which table has the field "Nominal Speed"

    Broadcom Employee
    Posted Oct 22, 2018 12:32 PM

    I think its possible but need to run some conversion logic through. I will check how to.



  • 6.  Re: Which table has the field "Nominal Speed"

    Posted Oct 23, 2018 10:51 AM

    Thanks Yu for your help.



  • 7.  Re: Which table has the field "Nominal Speed"
    Best Answer

    Posted Oct 26, 2018 10:38 AM

    Yu, resolved my problem with this query ---->

     

    select cmd1.dev_attr_value as SystemName, cmd.dev_ip, cci.ci_name as Interfaz,
    cast(ccia.ci_attr_value as float) * 1.0E-6 as Speed_Mbps,  --This is the parameter for calculation
    ccia3.ci_attr_value as Alias
    from CM_CONFIGURATION_ITEM_ATTRIBUTE ccia
    INNER JOIN CM_CONFIGURATION_ITEM cci on cci.ci_id = ccia.ci_id
    INNER JOIN CM_DEVICE cmd on cmd.dev_id = cci.dev_id
    INNER JOIN CM_DEVICE_ATTRIBUTE cmd1 on cmd1.dev_id = cci.dev_id
    INNER JOIN CM_CONFIGURATION_ITEM_ATTRIBUTE ccia2 on ccia.ci_id = ccia2.ci_id
    INNER JOIN CM_CONFIGURATION_ITEM_ATTRIBUTE ccia3 on ccia.ci_id = ccia3.ci_id
    where ccia.ci_attr_key = 'NomSpeedInBitsPerSec'
    and ccia2.ci_attr_value = 'Origin_Name'
    and ccia2.ci_attr_key = 'Origin'
    and ccia3.ci_attr_key = 'IfAlias'
    and cmd1.dev_attr_key = 'SysName'
    order by cmd1.dev_attr_key



  • 8.  Re: Which table has the field "Nominal Speed"

    Broadcom Employee
    Posted Oct 27, 2018 12:37 AM

    Great !

    I just glad seeing you found solution.

    Thank you for sharing the info so that it would be benefical to everyone in the community.

    Thanks again.

    Regards, Yu