SQL

Feb 092015
 
Observium - new monitoring software

Observium is an autodiscovering network monitoring platform supporting a wide range of hardware platforms and operating systems including Cisco, Windows, Linux, HP, Juniper, Dell, FreeBSD, Brocade, Netscaler, NetApp and many more. Observium seeks to provide a powerful yet simple and intuitive interface to the health and status of your network.

Observium Community is available free and open source. Observium Professional … MORE

Jul 162013
 
Special characters in SQL user password

Normally SQL Server will allow for user to practically have any characters in password. Even NPM (Core) itself will work with that. Yet I have found recently that NCM will not accept ; (semicolon) in the password throwing some slightly misleading error about license when trying to execute Win32 application.

 

 

More to it – Configuration Wizard, for NCM … MORE

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