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

FEATURE REQUEST - Email SWQL Handle Multiple Rows

Currently, if a SWQL variable in an email returns multiple rows, only the first row will actually be displayed in the email. Tech Support have confirmed that this is the case.

For example, if we have a node that belongs to 2 applications, and run ${N=SWQL;M=SELECT DisplayName from Orion.APM.Application where NodeID = ${N=SwisEntity;M=NodeID}, it should return both applications - this would be useful when identifying what appes are impacted by a node outage/reboot etc.

Find more posts tagged with

Status: None

Comments

christopher.t.jones123

native support would be great. In the meantime take a look at this

SQL variable definition to return multiple rows

paget76

That's great - thanks!