Per the documentation,
SELECT Caption FROM Orion.Nodes WHERE Node.CustomProperties.City = 'Atlanta'
Should work in a custom query object, but instead I get 'there was an error in querying the solarwinds information service'
Am I missing something or should a support case be opened?
EDIT:
I was able to get it to work with a slightly more advanced query and joining the custom properties to the nodes.
SELECT N.Caption AS [Node Name], OCP.StoreGroup, N.StatusDescription, '/Orion/images/StatusIcons/Small-' + N.StatusIcon AS [_IconFor_Node Name] FROM Orion.NodesCustomProperties OCP
INNER JOIN Orion.Nodes N ON OCP.NodeID = N.NodeID WHERE OCP.StoreGroup = (SELECT StoreGroup FROM Orion.NodesCustomProperties WHERE NodeID = ${NodeID})
Anyone else have this issue?
