What table contain system model of device

[Miller Echagarreta]

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

[David Michel]

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

[Miller Echagarreta]

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?

[WDRAIN1]

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

[David Michel]

Miller, 
alias is in CM_COMPUTER_SYSTEM_ATTR, column cs_attr_key, DisplayAlias

William,
nice query, will keep that one. 
thanks

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