nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

SWQL SELECT TOP 10 not working in Custom SQL Resource

philip937

I created an SQWL query which works fine when I create a web report and choose Advanced SWQL but the same query when I use in the Custom SQL Resource it doesn’t take the SELECT TOP 10?
Anyone got any ideas as to why this might be?

Find more posts tagged with

Accepted answers

brscott

Ok, maybe something changed in an upgrade. I just did a custom query in a summery view

SELECT TOP 10 NodeID, Caption
FROM Orion.Nodes

and the darn thing worked. I know I am getting old, but I remember this defiantly didn't work before. I no longer have the example where I got around this before, but I think I put the "top 10" in a subquery, like this:

select NodeID, Caption from (
SELECT TOP 10 NodeID, Caption
FROM Orion.Nodes
)

All comments

bobmarley

Post your query so we can see what it is.

philip937

an example would be:

Works in both Web reports and Custom Query resource:

SELECT Caption FROM Orion.Nodes

Works in Web Reports but NOT in Custom Query resource:

SELECT TOP 10 Caption FROM Orion.Nodes

philip937

NPM 11.5.2

brscott

The reporting function already has the ability to limit the number of records. That feature interferes with the SQL "top 10".

philip937

As per my post. Top 10 works in reporting. It doesn’t work with the Custom Query Resource.

brscott

Hmm, well, I've always removed it from reports SWQL's also, that's interesting. I found a way around this let me see if I can find it.

brscott

Ok, maybe something changed in an upgrade. I just did a custom query in a summery view

SELECT TOP 10 NodeID, Caption
FROM Orion.Nodes

select NodeID, Caption from (
SELECT TOP 10 NodeID, Caption
FROM Orion.Nodes
)