Listing archives for a particular user (backend database)
I need a method via SQL to list the archives belonging to a user.
Currently I am executing:
SELECT DefaultvaultId FROM ExchangeMailboxEntry where MbxNTUser = xxx
However there has been a policy in place previously where some users have had a new archive created when their existing archive exceeded a certain size. So these archives are no longer in the ExchangeMailboxEntry table.
I also tried the following but it also returns other users that I have permission to access (i.e. not just my own):
Ideally I want to execute a SQL query providing a NT Login id and retrieving all the archives assoictaed with that user (past and present).
Is this possible?