How to report on records by when they are marked deceased

User is attempting to report on records by when they were marked deceased. 
Currently, users can query constituent records and find the deceased date but not the date the constituent was marked deceased. This can be done through a SQL script that uses the DECEASEDCONSTITUENT table. You can individually view each constituent record's history and see the date that they were marked deceased, but there is currently no way to pull this information in bulk from the front end.

Environment

 Blackbaud CRM

Was this article helpful?