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

Help with SWQL...I am missing something here

bsciencefiction.tv

This is a modified report I found on Thwack that works great as a reprot. I am trying to convert it for a SWQL view and am running into issues. Any thoughts on what I am missing?

SELECT

StartTime.EventTime,

Nodes.Caption,

Nodes.Location,

StartTime.Message,

DATEDIFF(Mi, StartTime.EventTime,

(SELECT TOP 1

EventTime

FROM Events AS Endtime

WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5

AND EndTime.NetObjectType = 'N'

AND EndTime.NetworkNode = StartTime.NetworkNode

ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes

FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID

WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') AND

EventTime between dateadd(month, -1, getdate()) and getdate() AND (Nodes.WanTechnology like 'mpls' and Nodes.DeviceType like 'router' and (Nodes.Entity_Type like 'backoffice' or Nodes.Entity_Type like 'branch' or Nodes.Entity_Type like 'callcenter' or Nodes.Entity_Type like 'metrocampus'))