Switch/Router Serial and IP Addresses

jrosenblumcwc

I'm trying to create a report that will list out all my Cisco routers and switches including name, serial number, and all IP addresses (like in the All IP Addresses widget on the device summary page) for each device.

I've read through this thread Need to create a report that lists all IPs on every device but can't find resource? and from there I was able to learn about the SWIS schema and create the following SWQL

select n.NodeCaption, n.EntityPhysical.Serial, n.Interfaces.IpAddresses.IPAddress

from NCM.Nodes n

where n.vendor = 'Cisco' and (n.EntityPhysical.EntityName like '%Chassis%' or n.EntityPhysical.EntityName like '%CHASSIS%') and n.EntityPhysical.Serial <> '' and n.Interfaces.IpAddresses.IPAddress <> ''

This seems to get me what I want except when I build a report and run it it only returns 130 rows, I have over 200 devices (each with at least 2 IP addresses) so it's definitely not returning everything.

Thoughts?

m_roberts

In situations like this I start simple and add from that point. In this situation, I would remove the IP Addresses from the select and where lines and confirm that the number of devices from the single SWQL entity table are inline with your expectations. This could be the join type is excluding empty values and therefore changing to a manual join in the query code will allow you to control the output more appropriately.