Enterprise Vault has several ways available for customers to perform migrations of data from “old” PST files into an archive. Whilst the ways aren’t necessarily perfect, or 110% complete (at least, I don’t think they are) there are some fantastic features available.. and with a little bit of work it’s possible to get a good picture of what’s happening, where, what has happened, and why.
The first piece of this that I thought about is that in the Vault Administration Console you can enable people for Client Driven PST Migration, and you can disable them from Client Driven PST Migration … but how do you tell who already has it enabled?
I have not found an answer in the Vault Administration Console, but the following snippet of SQL works :
select mbxDisplayName, ArchivingEnabled = CASE mbxArchivingState WHEN 0 THEN 'New' WHEN 1 THEN 'Enabled' WHEN 2 then 'Disabled' END, PSTImportEnabled = CASE EnabledPSTImport WHEN 0 THEN 'No longer' WHEN 1 THEN 'Yes' END from exchangemailboxentry where enabledpstimport is not null order by mbxDisplayName
Sample output :