When using Advanced SQL in Report Designer, how do we pull through the Node Custom Properties?
I've searched high and low, a couple of similar unanswered questions so still getting a SQL Error when trying to use the names of the Custom Properties.
If you are actually using SQL and not SWQL then the name of the property is the name of the column and it is just on the Nodes view, no need to pull anything in at all.
In SWQL you need to navigate from orion.nodes to nodes.customproperties.[yourpropertyhere]
