Enable Client Based PST Migration - SQL Query
Since last few days I was trying to figure best way to enable client drive migration for users in bulk mode and only way found was using ADModify which is pretty decent way to do it... Modify an attribute for bulk users & use that for enabling client drive migration using VAC.
While I was working on it today, I stumbled upon "EnabledPSTImport" bit in ExchangeMailboxEntry table and used below SQL query to make bulk modifications:
Update dbo.EnterpriseVaultDirectory.ExchangeMailboxEntry EME
set EnabledPSTImport = '1'
--Join a custom table which contains user list for migration in display name format
Inner Join dbo.Database.table T ON EME.MbxDisplayName = T.cUserName
where EME.MbxDIsplayName = T.cUserName
After running this query, when I went to VAC, all mailbox entries changed using above were showing as "Disable for client driven", so I guess they did get enable for client driven migration. And the client drive migration enable message isn't sent out using this way.
This was something new and sudden & changed the EnabledPSTImport bit as intended to (and hopefully worked as intended to). So sharing it out and any thoughts around same are welcome in case I did something wrong and this way shouldn't be used.