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

Custom table widget missing results

I am running version 2025.4.1. The issue is that I am trying to use a custom table widget to display a custom SWQL report and the data shown in the widget is not complete when compared to the report.

The report shows data for an expected 52 nodes, but the table widget linked to the exact same report shows 149 total rows representing the data for 50 nodes.

Any ideas what is going on? Thank you.

Find more posts tagged with

Comments

cnorborg

Can you provide an example maybe? And you're using the "Custom SWQL" in classic dashboards? Or are you doing modern dashboards?

patriot

Here is the SWQL being used in the report and by extension, in the table widget:

SELECT rn.NeighborID, rn.NodeID, rn.NeighborIP, rn.ProtocolName, rn.ProtocolStatusDescription, rn.Router.Nodes.Caption, rn.Router.Nodes.StatusLED, rn.Router.Nodes.DetailsUrl

FROM Orion.Routing.Neighbors rn

WHERE rn.Router.Nodes.CustomProperties.Remote_Site_Direct = 'True'

patriot

One additional piece of information. The bottom right corner of the custom table widget has a message in blue text saying "the resource doesn't show all data". Is that always there, or is it indicative of an issue with the data?

romeo-donca

it is about hard-coded limitation

To avoid this, in your classical dashboard introduce a custom table instead of the custom query widget

patriot

It is the custom table widget.

Could there be an Advanced Setting where that limitation can be modified?

patriot

Found the answer here -

Custom table "The resource doesn't show all data" in NPM