Resolution

Pending notification records are available in two tables:

1. EnitityNotifications.
2. EntityNotificationBacklog

All records from EntityNotifications will have Status of 'Pending Initial Attempt' and all records from EntityNotificationBacklog will have Status of 'Failed Previously'

The Action is already encoded in the Entity Payload string. The following example query fetches all records as one result set.

SELECT EntityType,
CAST(EntityNotificationBacklog.EntityPayload AS VARCHAR(800)) as EntityPayload,
SubscriberCode,
'Failed Previously' as EntityStatus
FROM dbo.EntityNotificationBacklog

UNION ALL

SELECT EntityType,
CAST(EntityNotifications.EntityPayload AS VARCHAR(800)) as EntityPayload,
' ' as SubscriberCode,
'Pending Initial Attempt' as EntityStatus
FROM dbo.EntityNotifications

Browser not supported