• Facebook
  • RSS Feed
  • Instagram
  • LinkedIn
  • Twitter
Aug 022010

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'
PSTImportEnabled =
    CASE EnabledPSTImport
        WHEN 0 THEN 'No longer'
        WHEN 1 THEN 'Yes'
from exchangemailboxentry
where enabledpstimport is not null
order by mbxDisplayName

Sample output :


If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>