SQL Query to find out list of Orphaned Archives

Hi,

Need help in creating a SQL Query to find out which all Archives in the Vault Stores are currently orphaned.

Users have been removed from the EV Environment, but the Archives are stiill present. Hence need to delete those Archives. Looking for a SQL Query that will point in that direction.