SQL

Apr 172013
 
SolarWinds Orion WirelessSwitchPortMapping (table)

Below is a SQL query to create WirelessSwitchPortMapping (view) in Orion NPM database:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[WirelessSwitchPortMapping]
AS
SELECT
ISNULL(wl_con.Controller_Name,'') as [Controller Name],
ISNULL(wl_con.Controller_IPAddress,'') as [Controller Source IP Address],
CASE WHEN wl_con.ID IS NOT NULL THEN CAST(n.[Description] AS NVARCHAR(512)) ELSE ''
END AS [Controller Description], -- description from Nodes table, it can be 
MORE