Which table holds the information on discarded messages, are there any

Question

William Glover · Nov 9, 2022

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?

Discussion (1)1

Julian Matthews · Nov 9, 2022

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.

1 0

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