Queue Alert Report SQL Query

Document ID:  TEC1329186
Last Modified Date:  06/06/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details


  • CA Service Operations Insight


  • CA Service Operations Insight:Release:4.0
  • CA Service Operations Insight:Release:3.3


  • Service Operations Insight (SOI) Generic Connector:SOICTR
  • Service Operations Insight (SOI) Manager:SOIMGR
  • Service Operations Insight (SOI) Reports:SOIRPT
  • Service Operations Insight (SOI) User Interface:SOIUI

Client needs the SQL Query to get the Alarms list for Queues to create a Jasper Soft report. 


What is the SQL Query to get the Alarms list for Queues?. I need to create a Jasper Soft report and I need  the correct SQL Query to do it.


Please test the following query on your test system.

SELECT dbo.AlertQueues.QueueName,

dbo.AlertQueueAssignments.AlertID,dbo.Alerts.DeviceID, dbo.Alerts.SituationMessage, dbo.Alerts.AlertDetail, dbo.Alerts.ModelElementID,dbo.Alerts.Active

FROM dbo.AlertQueueAssignments INNER JOIN

dbo.Alerts ON dbo.AlertQueueAssignments.AlertID = dbo.Alerts.AlertID INNER JOIN

dbo.AlertQueues ON dbo.AlertQueueAssignments.QueueID = dbo.AlertQueues.QueueID

WHERE dbo.AlertQueues.QueueName = 'Critical' and dbo.Alerts.Active = 1

Please note that custom Jasper reports / queries related to the same are outside of support scope and any further assistance may need CA Services engagement.


Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255


Not what you were looking for?

Search Again >

Product Information

Support by Product >


Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required


We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile

  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.

    Rate Your Chat Experience.


agent is typing