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
- SolarWinds Academy
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

Making a SWQL query to filter by a custom property on alerts

cowrat

I have the SWQL command on all alerts by severity, but I need to filter by a nodes custom property called BLDG.

Here is the SWQL from SolarWinds All Alerts by Severity:

SELECT AlertSeverity, AlertSeverityColor, AlertSevirtyIcon, ActiveAlerts, '/orion/netperfmon/alerts.aspx' as AlertSeverityLink FROM Orion.AllActiveAlerts.AggregatedSeverity

How do I add the filter to this?

Find more posts tagged with

Widgets

orion

Alerts

Comments

fop

I'm not entirely sure you can, because there's nothing to link that table back to Orion.Nodes. You could maybe go the other way via the Orion.AllActiveAlerts.Dashboard table which includes both the alertSeverity and relatedEntityCaption for hooking into Nodes, but testing this shows you'll have to do some conversion with the Orion.AllActiveAlerts.AggregatedSeverity table because despite the primary key being listed as System.Int32 SWQL seems to want to convert it to a string.

Quick Links

PALO-ALG - Logging
PALO-ALG - Logging.xmlPalo Alto Networks ALG Security Technical Implementation Guide :: Version 2, Release: 3 Benchmark Date: 27 Oct 2022
Alert HTML Content
Alert Cleared.htmlHello, I would like to share the HTML template details we have prepared so that Solarwinds alarms can become more meaningful. It can list alarm object details and connected device details separately in HTML template. Except for object and device details, you can easily add custom property information…
Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…