Overview

Alerts are raised for events that need your attention. Alerts are organized in Groups/Queues so that they are attended in order.

Information

You can view all the Alerts in the client's CSR website by navigating to Workspace > Alerts List. The Alert Queues are listed on the left sidebar on the Alerts List page.

If this option is not available for you, you can create a support ticket and we will retrieve this information for you.

<supportagent>

Whereas the option above list the alerts on the UI, the following query will yield all alerts directly from the database:

select QueueID,al.Subject as Alert_Description
,s.Description as Alert_Status
,at.Description as Alert_Type
,ag.Description as Alert_Group
,a.PriorityID,a.GroupID,CustID,PremID,InvoiceID,ESIID,a.Subject,CreateDate,a.Description,ApprovalEventId,RequestID,Source,SourceID
,RejectEventID,EscalateFlag,EnrollCustID
from <client_database>..AlertQueue a
join paes_BillingAdmin..Alert al on al.AlertID = a.AlertID
join paes_BillingAdmin..AlertStatus s on s.StatusID = a.StatusID
join paes_BillingAdmin..AlertType at on at.TypeID = a.TypeID
join paes_BillingAdmin..AlertGroup ag on ag.GroupID = a.GroupID
where 1=1
order by 1 desc

You can also filter alerts per client in the above query by filtering on Alerts.ClientID where ClientID can be found in the Client table in the paes_BillingAdmin database and the ClientName lists the name of the client.

Alert Groups can also be found similarly from the database by querying on the AlertGroup table in the paes_BillingAdmin database. They can be filtered by ClientID that can be discovered in the manner described above. The Description column contains the name of the group.

Alert Queues assign Alerts to specific Groups. The corresponding database table is AlertQueue, and this table can be joined on its AlertID & GroupID columns.

</supportagent>