I need help adding serial numbers to some custom reports that I have. Most devices are Cisco but there other vendors as well. As wluther pointed me in the right direction partially, I have been able to get "some results". In it's current format, I have 222 nodes that I'd like to pull from that are Cisco devices, and the below only shows me 30 serial numbers. My guess is that different models may not show this information in the same manner. Help would be greatly appreciated!
SELECT
n.Caption
,n.NodeProperties.CiscoChassis.ChassisSerialNumberString
FROM Orion.Nodes AS n