1 of 1 people found this helpful
The node name and description are in different entities, so you need to use joins. Like this:
SELECT N.DisplayName, N.Description, E.LastDiscovery, E.FirstDiscovery, E.Missing, E.Type, E.ContainedIn, E.EntityClass, E.Position, E.HardwareRevision, E.FirmwareRevision, E.SoftwareRevision, E.Serial, E.Manufacturer, E.Model, E.Alias, E.AssetID, E.FieldReplaceable
FROM Cirrus.EntityPhysical E
LEFT JOIN Cirrus.Nodes CN ON E.NodeID=CN.NodeID
LEFT JOIN Orion.Nodes N ON CN.CoreNodeID=N.NodeID
(Note: I don't have an NCM system handy, so I haven't tested this query.)
My SQL/SWQL ignorance is demonstrated to all, for my embarrassment. "Joins" are news to me.
I'd totally be up for either a Solarwinds interface that intuitively included all the SDK generate statements, along with an intuitive GUI editor, or a "SDK Statement Editing For Dummies, Unabridged Edition" book online.
Thank you, tdanner!