Description

SQL Script Description
Script Purpose:	Gets Vaults/EV Users where the Mailbox was deleted
Description:	Returns the ExchangeMailboxEntry row for EV Vaults/Users without Mailboxes/associated Users. Users are automatically marked by EV after 14 Days of mailbox/user deletion.
Script Input:	-
Script Output:	ExchangeMailboxEntry Rows
Tested on EV Versions:	7.5, 8.0

Source

Execute in EnterpriseVaultDirectory Database

SELECT * FROM ExchangeMailboxEntry WHERE LegacyMbxDn LIKE '%marked%'