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 Query for Wireless Rogues

Does anyone have feedback on a SWQL query to bring information back on the Wireless_Rogues tables. We can tell the SQL query is SELECT TOP 1000 * FROM [dbo].[Wireless_Rogues] and have tried to convert this to SWQL using SELECT TOP 1000 * FROM Orion.Wireless.Rogues and have not had success. We’ve also tried it using FROM Orion.Packages.Wireless.Rogues and a few other ways with no success. We’ve also tried just pulling the column SSID to avoid using * for example (we would like all columns returned) but even that was to no avail. We saw some others online have used Orion.Wireless.AccessPoints to bring back general access point information but we also were not able to return results with this.

Find more posts tagged with

Accepted answers

All comments

Seashore

Try this:

SELECT ControllerID, SSID, MAC, Channel, WirelessType FROM Orion.Wireless.Rogue

iManage

Thank you! We tried, looks like it was an invalid query. Any other thoughts would be helpful.

KMSigma.SWI

This is the SWQL that works on my lab. (Doesn't return any results because I don't have that kind of data in my lab)

SELECT [Rogues].ControllerID
     , [Rogues].SSID
     , [Rogues].MAC
     , [Rogues].Channel
     , [Rogues].WirelessType
     , [Rogues].ID
     , [Rogues].Index
     , [Rogues].NodeID
     , [Rogues].Available
     , [Rogues].FirstUpdate
     , [Rogues].LastUpdate
     , [Rogues].Status
     , [Rogues].DisplayName
     , [Rogues].Description
     , [Rogues].InstanceType
     , [Rogues].Uri
     , [Rogues].InstanceSiteId
FROM Orion.Wireless.Rogue AS [Rogues]

KMSigma.SWI

Also, if it wasn't mentioned, you probably want to install the Orion SDK on one of your workstations. It provides the API browser that helps significantly when building queries.