Description

The proper way to determine the Custodians on an EV Hold is to create and inspect each EV Hold Defensibility Report.
Under the EV Hold Tasks feature, select the Actions > Report on the right side of each EV Hold Task

- For the Custodian list of EV Journal Archive holds, the list will be under the 'Assigned Custodians' section

- For the Custodian list of EV Mailbox Archive holds, the list will be under 'Filters' labeled 'Archive'

Option B:
** This query will ONLY supply the list of On-Hold custodians when the holds are in place in EV Journal Archives.
The EV Mailbox archives are by ArchiveName and NOT by custodian.
NOTE:  The output is not easily read

-- To be run on the Cluster Master evidence_repo database
SELECT te.Name 'Collection name', tet.Description 'Task Description', tet.Custodian_Rules 'Custodians'
FROM t_esicollection_task tet 
JOIN t_esicollection te on te.ID = tet.parent_ID
WHERE tet.Type_ID = 'EV_MAIL_HOLD'


Example Output: