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

How to include Orion Variables in a SWQL Select statement

zagwill

SWQL returns the following response: no viable alternative at input 'M' in Select clause.

Heres the actual query:

SELECT ${N=Alerting;M=Downtime}, ${N=SwisEntity;M=CPULoad}, C.SiteID, N.EngineID, N.ObjectSubType AS [Polling Method], N.Status, N.StatusDescription, N.NodeID, N.IPAddress, N.NodeName, N.DNS, N.Description, N.Vendor, N.MachineType AS [Device Type], N.NodeDescription, HI.ServiceTag AS [Switch/Rtr Serial No], ONPMC.CurrentValue AS [UPS Serial No], ONPMC2.CurrentValue AS [PDU Serial No], ONPMC3.CurrentValue AS [APC SKU No],N.Location, C.DeviceLocation, C.BusinessUnit, C.City, C.Owner, C.AddressGroup, C.DeviceCategory, C.DeviceRole, C.SLA, C.Alerting, N.AgentPort, N.SNMPVersion, OEID.Elements AS [PE Monitored Device Count], C.Comments
FROM Orion.Nodes N
JOIN Orion.NodesCustomProperties C on C.NodeID=N.NodeID
LEFT JOIN Orion.Engines OEID on OEID.EngineID=N.EngineID
LEFT JOIN Orion.HardwareHealth.HardwareInfo HI on HI.NodeID=N.NodeID
LEFT JOIN Orion.NPM.CustomPollerAssignmentOnNode ONPMC on N.NodeID=ONPMC.NodeID AND ONPMC.CustomPollerID = 'e955f524-a816-48f7-9765-ff1be5362c39'
LEFT JOIN Orion.NPM.CustomPollerAssignmentOnNode ONPMC2 on N.NodeID=ONPMC2.NodeID AND ONPMC2.CustomPollerID = 'acbe9348-ddea-4847-bfa5-ce596ea6f2c7'
LEFT JOIN Orion.NPM.CustomPollerAssignmentOnNode ONPMC3 on N.NodeID=ONPMC3.NodeID AND ONPMC3.CustomPollerID = 'abddf61e-5b64-437a-821b-e634ab396226'
WHERE C.DeviceCategory LIKE 'Wireless%' AND N.ObjectSubType NOT LIKE 'SNMP'
ORDER BY C.SiteID ASC, N.IPAddress ASC

Find more posts tagged with

Accepted answers

All comments

zagwill

**** Correction - Here's the Correct SWQL query for this question ****

SELECT DISTINCT '${N=Alerting;M=Downtime}' AS [Alert Duration], '${N=SwisEntity;M=CPULoad}' AS [CPU Reset Load], C.SiteID, N.IPAddress, N.NodeName, N.MachineType, CPUL.NodeID, C.DeviceCategory, C.DeviceRole, N.ObjectSubType AS [Polling Method], TOLOCAL (CPUL.DateTime) AS [Date Time], N.CPULoad AS [AVG CPU Load], CPUL.MaxLoad AS [CPU Max Load]
FROM Orion.CPULoad CPUL
JOIN Orion.Nodes N on N.NodeID=CPUL.NodeID
JOIN Orion.NodesCustomProperties C on C.NodeID=N.NodeID
LEFT JOIN Orion.AlertObjects AO on AO.RelatedNodeId=N.NodeID
LEFT JOIN Orion.AlertHistory AH on AH.AlertObjectID=AO.AlertObjectID
Where (CPUL.MaxLoad >= '70' AND ToLocal (DATETIME) >= '2022-02-01') AND C.DeviceCategory NOT LIKE 'iLO' AND C.DeviceCategory NOT LIKE 'WirelessAccessPoint'
ORDER BY CPUL.MaxLoad DESC, C.SiteID ASC, CPUL.DateTime DESC

KMSigma.SWI

Those variables are only "exposed" in a few places (like Alert Actions).

Where are you using this query? What exactly are you trying to accomplish?

zagwill

The users want the CPU Utilization in a report format, my Reset alert email contains this data along with the specific node profile information as well, but I was trying to include the data provided by those two variables as exhibited below:

I can generate a report on the alerting/resetting, and provide this data in a Message column, but of course they want the variable data in their own columns for sorting purposes.

Any help on this would be greatly appreciated. Thanks for responding!

zagwill

Here's my Node High CPU Utilization - 70% v.1.3 - RESET Email Message content:

*** From: ${AlertName} - RESET ***

*** High CPU Utilization Duration lasted for ${N=Alerting;M=Downtime} minutes. ***

*** RESET CPU Load: ${N=SwisEntity;M=CPULoad} ***

*** Active Alert ID: ${N=Alerting;M=AlertActiveID} ***

=========================================================
* Site: ${SiteID}
* Business Unit: ${N=SwisEntity;M=CustomProperties.BusinessUnit}
* Node Name: ${N=SwisEntity;M=Caption}
* Node IP Address: ${IP_Address}
* NodeID: ${NodeID}
* Alerting: ${N=SwisEntity;M=CustomProperties.Alerting}
* SLA: ${N=SwisEntity;M=CustomProperties.SLA}
* Status: ${Status}
* DeviceCategory: ${N=SwisEntity;M=CustomProperties.DeviceCategory}
* DeviceRole: ${N=SwisEntity;M=CustomProperties.DeviceRole}
* Location: ${DeviceLocation}
* Time: ${YYYY}-${MM}-${DD}.${HH}:${Minute}:${Second}
=========================================================${CrLf}
${N=SwisEntity;M=DetailsUrl}

KMSigma.SWI

This email looks ok, what fields are you missing that you'd be getting from SWQL?