search cancel

How to get a report/list containing the device name and main IP/chassis address for Spectrum devices


Article ID: 240718


Updated On:


DX NetOps


This article provides two possible solutions to get this required list/report.


Release : 21.2.x

Component : Spectrum Reporting


Solution 1: 

Using a rest query:


Here is an example of the result:

<model mh="0x3000300">
<attribute id="0x1006e">SWITCH-01</attribute>
<attribute id="0x12d7f"></attribute>
<model mh="0x3000302">
<attribute id="0x1006e">ROUTER_TEST</attribute>
<attribute id="0x12d7f"></attribute>
<model mh="0x3041307">
<attribute id="0x1006e">FIREWALL-24567</attribute>
<attribute id="0x12d7f"></attribute>

Solution 2:

Using MySQL queries to be executed in the SRM/Reporting Manager database.

Here is the query ("reporting" DB):

select model_name,network_address from model where model_class=x order by model_name;

Where 'x' must be replaced by the model_class ID desired.

OBS: To know what is/are the ID's model_classes you need, you can run the following additional query:

select * from modelclass order by model_class;

The 'modelclass' table contains the id of all model types in spectrum.

Here is an example. Let's suppose you want to run a report to get the ip adresses from Routers and switches and Workstation-servers.

According to the modelclass table contents, we have the following (i.e):

Router = ID 3
Switch = ID 2
Workstation-server = ID 9

The query should be the following:

select model_name,network_address from model where model_class=3 or model_class=2 or model_class=9 order by model_name;

Additional Information