DX Infrastructure Manager

Expand all | Collapse all

What table contain system model of device

Jump to Best Answer
  • 1.  What table contain system model of device

    Posted 06-13-2018 04:43 PM

    Hi all.

     

    I need create a report or dashboard that export the total device for system model. For example:

     

    *Vendor = Cisco
    System Model = ISR4431
    Total = 15

     

    *Vendor = Panthera Networks, Inc.
    System Model = Alcatel 7750 SR 14
    Total = 22

     

    I think can create with a query and a SQL table or maybe a context selector. I don't know if this data is possible obtaining of db mysql.

     

    Note: The devices are of networking like a Cisco, Alcaltel, Fortinet.

     

    Best Regards.

     

    M.E



  • 2.  Re: What table contain system model of device
    Best Answer

    Broadcom Employee
    Posted 06-13-2018 04:54 PM

    Miller,

     

    That info is in CM_DEVICE & CM_DEVICE_ATTRIBUTE.

    CM_DEVICE has the dev_id

    CM_DEVICE_ATTRIBUTE has all the device details based on dev_id



  • 3.  Re: What table contain system model of device

    Posted 06-18-2018 01:28 PM

    David I have other question.

     

    I need incorporate in the report the alias of device. This alias i don't see in CM_DEVICE_ATTRIBUTE, this information are in other table?



  • 4.  RE: What table contain system model of device

    Posted 12-13-2019 10:10 AM

    select
    dev_name device 
    ,cda1.dev_attr_value Vendor
    ,cda2.dev_attr_value Model
    from cm_device cd
    join CM_DEVICE_ATTRIBUTE cda1 on cda1.dev_id = cd.dev_id and cda1.dev_attr_key = 'vendor' -- vendor
    join CM_DEVICE_ATTRIBUTE cda2 on cda2.dev_id = cd.dev_id and cda2.dev_attr_key = 'model' -- Model
    order by 2,3


  • 5.  RE: What table contain system model of device

    Broadcom Employee
    Posted 12-13-2019 10:33 AM
    Miller, 
    alias is in CM_COMPUTER_SYSTEM_ATTR, column cs_attr_key, DisplayAlias

    William,
    nice query, will keep that one. 
    thanks

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------