Hello
I'm working on a report to create an inventory of all our Cisco voice gateways, including hostname, IP, serial number and model.
Most voice gateways are popping up in the report just fine, but other's don't. For example, we have 2 exact same voice gateway models, with exact same configuration and firmware level and have been added exactly the same way in Solarwinds, but only 1 of the two is visible in the cirrus.entityphysical table.
For reference, this is the full SWQL query we're using to request this info.
SELECT n.SysName as FQDN, n.CustomProperties.Country as Country, n.CustomProperties.Site as Site, n.IP_Address as IP,ent.serial as SerialNumber,ent.Model as Model
FROM Orion.Nodes n
RIGHT JOIN cirrus.nodes n2 ON n2.SysName = n.SysName
RIGHT JOIN cirrus.EntityPhysical ent ON ent.NodeID=n2.NodeID
WHERE (N.CustomProperties.Server_Role = 'IPTel Voice Gateway' OR N.CustomProperties.Server_Role = 'IPTel Analog Voice Gateway') and ent.Serial != '' and ent.Model = N.HardwareHealthInfos.Model and n.UnManaged = false and ent.Name NOT LIKE '%Module%' and ent.name NOT LIKE '%Supervisor%'
I 'debugged' the query part by part, and the missing devices are present in Orion.Nodes and Cirrus.Nodes, but not in cirrus.entityphysical.
How do I trigger the cirrus.entityphysical table to be populated with device information? By the way, it's also not present in ncm.entityphysical table though I can see the device in the NCM GUI.
Thanks
