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
Store

Using SWQL / SWQL Custom Resource

Hello Fellow Thwackers -

This swql query is about as simple as it can get - I'm just trying to get my feet wet with writing custom resources with SWQL instead of SQL - especially since it offers more options.

I use the Orion SWIS Query page to test and everything works correctly when I use that page. *YOURORIONSERVER*/Orion/Admin/Swis.aspx

However when I use the same code in the 'SWQL Custom Resource' - the fields show up with no data.

I'm assuming I'm just missing something simple here.... Can someone clue me in??

Example:

SELECT n.NodeID
FROM Orion.Nodes n
JOIN Orion.NodesCustomProperties (nolock=true) ncp
ON n.NodeID = ncp.NodeID
WHERE n.Status = '2'

Thank you,

Find more posts tagged with

Accepted answers

jamison.jennings

Are you trying to insert the Custom Query Resource on a page that has a view limitation?

All comments

jamison.jennings

Are you trying to insert the Custom Query Resource on a page that has a view limitation?

atruepath

Sigh. That was it. Thanks for the help...rookie mistake.

jamison.jennings

Glad I could help. Can you mark my answer as correct?