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.
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]
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.