Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

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: 714 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