Question
William Glover · Nov 9, 2022

Which table holds the information on discarded messages, are there any methods used for retrieving them?

I would like to access discarded messages from a specfic process, is there any method that allows for this?

 

Alternatively what table holds this info so I can query it?

0
0 137
Discussion (1)1
Log in or sign up to continue

Hey William.

I'm pretty sure you just need to query the table Ens.MessageHeader.

This should give you the process by way of the column SourceConfigName, and the status of the discarded messages.

For example:

SELECT *
FROM Ens.MessageHeader
WHERE SourceConfigName = 'ProcessNameHere' AND Status = 'Discarded'

You may want to consider including a time range depending on the size of the underlying database.