Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

SWQL issue - Entity Orion not found in FROM clause

Trying to do what I thought would be a straightforward SWQL for a Proportional Widget, but stuck when trying to add a condition to what servers are included. Trying to use a Custom property to filter which servers are included in Status count by joining the Orion.NodesCustomProperties and Orion.Nodes tables and receive the error Entity Orion not found in FROM clause for navigation property Orion.Nodes.NodeID.

My SWQL query knowledge is beginner level at best, and I have to admit I am lost on how Alias relationships are defined. I am sure this is an asy fix for an expert so any assistance is appreciated.

SELECT
COUNT(NodeID) as value,
Orion.Nodes.Status as status,
Orion.NodesCustomProperties.App_Function

FROM Orion.Nodes

Join Orion.NodesCustomProperties
ON Orion.Nodes.NodeID=Orion.NodesCustomProperties.NodeID

GROUP BY status
HAVING Orion.NodesCustomProperties.App_Function LIKE '%Domain Controller%'
ORDER BY value DESC

--Error Entity Orion not found in FROM clause for navigation property Orion.Nodes.NodeID

Find more posts tagged with

swql query

Accepted answers

All comments

jm_sysadmin

Does this work? I didn't test with the custom properties, but without it seemed ok.

SELECT
COUNT(N.NodeID) as value,
N.Status as status,
N.NodesCustomProperties.App_Function
FROM Orion.Nodes N 
Where N.NodesCustomProperties.App_Function LIKE '%Domain Controller%'
GROUP BY N.status
Order By COUNT(N.NodeID) desc

jm_sysadmin

Also, check out: SWQL Functions · solarwinds/OrionSDK Wiki · GitHub if you haven't already.

And take a look at a post from not long ago: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/91154/dashboard-swql-question/290462#290462

It uses a case statement that takes the status values and maps it to labels

bslobodn

Different error trying your query - Entity Orion.Nodes does not contain requested navigation property NodesCustomProperties

Not sure why there seems to be a disconnect between the Nodes and custom properties table.

bslobodn

Thank you, I tried the query you posted on the forum link, and modified that query to use my custom property and that worked. I definitely need to spend more time learning SWQL so I will check out the GitHub site.

KMSigma.SWI

Learning to use the "Navigation Properties" was the single best use of my time when it came to learning SWQL.

jm_sysadmin

I think I have a typo! Sorry about that.
N.NodesCustomProperties.App_Function should be N.CustomProperties.App_Function

SELECT
COUNT(N.NodeID) as value,
N.Status as status,
N.CustomProperties.App_Function
FROM Orion.Nodes N 
Where N.CustomProperties.App_Function LIKE '%Domain Controller%'
GROUP BY N.status
Order By COUNT(N.NodeID) desc