Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Netflow Traffic Analyzer (NTA) > CBQoS alerts do not display in EOC

CBQoS alerts do not display in EOC

Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1 Votes: 0 Revisions: 10

Issue

Class-Based Quality of Service alerts do not appear in your Enterprise Operations Console.

Environment

  • NTA 4.1
  • EOC 1.6
  • Orion Platform 2015.1

Resolution

Run the following SQL query on the SolarWinds Orion database. You can also download the SQL query here.

IF  EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[AlertStatusView]'))
                DROP VIEW [dbo].[AlertStatusView]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[AlertStatusView] AS
SELECT AC.[AlertRefID] AS AlertDefID,
CAST(CASE WHEN (AO.EntityNetObjectId IS NOT NULL
                                                                                                AND (AO.EntityNetObjectId LIKE '%:%:%' OR ISNUMERIC(SUBSTRING(AO.EntityNetObjectId,CHARINDEX(':',AO.EntityNetObjectId)+1,LEN(AO.EntityNetObjectId))) = 0) )
                                                                                                THEN CAST(AO.AlertObjectID as nvarchar)
                                                                                                ELSE SUBSTRING(AO.EntityNetObjectId,CHARINDEX(':',AO.EntityNetObjectId)+1,LEN(AO.EntityNetObjectId))
             END AS nvarchar) as ActiveObject,
AC.[ObjectType],
2 AS [State], 0 AS WorkingState,
AO.EntityCaption AS ObjectName, AA.[TriggeredMessage] AS AlertMessage, AO.[LastTriggeredDateTime] AS TriggerTimeStamp, DATEDIFF(SECOND, AO.[LastTriggeredDateTime], GETUTCDATE()) AS TriggerTimeOffset, AO.[TriggeredCount] AS TriggerCount,
CAST('18991230 00:00:00.000' AS datetime) AS ResetTimeStamp,
IsNull(AA.[Acknowledged], 0) AS Acknowledged, IsNull(AA.[AcknowledgedBy], '') AS AcknowledgedBy, IsNull(AA.[AcknowledgedDateTime], CAST('18991230 00:00:00.000' AS datetime)) AS AcknowledgedTime,
 
(SELECT TOP 1 [TimeStamp] FROM AlertHistory AS AH WHERE AH.[AlertActiveID]=AA.[AlertActiveID] ORDER BY AH.[TimeStamp] DESC) AS LastUpdate,
'' AS AlertNotes, AO.[AlertNote] AS Notes,
AO.AlertObjectID
 
FROM [dbo].[AlertActive] AS AA
INNER JOIN [dbo].[AlertObjects] AS AO ON AO.AlertObjectID=AA.AlertObjectID
AND AO.EntityNetObjectId IS NOT NULL
INNER JOIN [dbo].[AlertConfigurations] AS AC ON AC.AlertID = AO.AlertID
 
UNION ALL
SELECT ALS.[AlertDefID], ALS.[ActiveObject], ALS.[ObjectType], ALS.[State], ALS.[WorkingState], ALS.[ObjectName], ALS.[AlertMessage], ALS.[TriggerTimeStamp], ALS.[TriggerTimeOffset],
ALS.[TriggerCount], ALS.[ResetTimeStamp], ALS.[Acknowledged], ALS.[AcknowledgedBy], ALS.[AcknowledgedTime], ALS.[LastUpdate], ALS.[AlertNotes], ALS.[Notes], 0 AS AlertObjectID
FROM [dbo].[AlertStatus] AS ALS
 

After you run the query, your CBQoS alerts appear in EOC.

Last modified
20:28, 22 Jun 2016

Tags

Classifications

Public