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

SWQL from alert "duplex mismatch" works in SWQL studio but doesn't work in report writer

I tore the SWQL out of the alert "duplex mismatch", ran it in SWQL studio successfully, but when I try it in report writer it won't even preview the results.

Thoughts / comments ?

select 
    interfaces.uri,
    interfaces.displayname 
from 
    orion.npm.Interfaces
    LEFT JOIN Orion.TopologyConnections tc ON 
        (tc.SrcNodeID = Interfaces.NodeID OR tc.DestNodeID = Interfaces.NodeID) AND 
        (tc.SrcInterfaceID =Interfaces.InterfaceID OR tc.DestInterfaceID =Interfaces.InterfaceID) AND 
        tc.DestInterfaceID IS NOT NULL AND 
        tc.SrcInterfaceID IS NOT NULL AND 
        tc.LayerType = 'L2'

	LEFT JOIN Orion.NPM.Interfaces i ON 
        i.InterfaceID = tc.DestInterfaceID OR i.InterfaceID = tc.SrcInterfaceID 
WHERE 
    Interfaces.DuplexMode != i.DuplexMode AND 
    Interfaces.DuplexMode > 1 AND 
    i.DuplexMode > 1

Find more posts tagged with

swql query

Reports

SWQL

Accepted answers

All comments

cgregors

Additional note:
The query works on platform 2020.2.6
The query fails on platform 2023.4.2

KMSigma.SWI

This is the query as of Platform 2024.1

SELECT Interfaces.Uri
     , Interfaces.DisplayName
FROM Orion.NPM.Interfaces AS Interfaces
--------------------------------------------------------------
LEFT JOIN Orion.TopologyConnections tc
     ON (
               tc.SrcNodeID = Interfaces.NodeID
               OR tc.DestNodeID = Interfaces.NodeID
               )
          AND (
               tc.SrcInterfaceID = Interfaces.InterfaceID
               OR tc.DestInterfaceID = Interfaces.InterfaceID
               )
          AND tc.DestInterfaceID IS NOT NULL
          AND tc.SrcInterfaceID IS NOT NULL
          AND tc.LayerType = 'L2'
LEFT JOIN Orion.NPM.Interfaces i
     ON i.InterfaceID = tc.DestInterfaceID
          OR i.InterfaceID = tc.SrcInterfaceID
WHERE Interfaces.DuplexMode != i.DuplexMode
     AND Interfaces.DuplexMode > 1
     AND i.DuplexMode > 1

I'd try to throw it into a report, but I don't have any data returned, so a report in my lab would be zero help.