forcefully disable mailboxes using sql script
Hi
We have around 1k leavers mailboxes of which EV has successfully archived off all mail from their mailboxes.
Our service desk will cleanup the mailboxes in exchange 2003 now we are happy the mail is in their archives.
I now need to disable all of these mailboxes from EV as they will no longer have a mailbox.
is there :-
1) a sql script we can run on the database to disable these users' mailboxes on mass rather than go through the wizard in EV? We can then drop the mailbox aliases into this script to do all the mailboxes.
2) any way to script renaming these disabled users' archives to prefix them with _Leaver_mailboxalias
3) use a tool to strip out permissions on these archives and specify just a couple of security objects on there.
Thanks
1. Use an EVPM Script to Zap the vault:
http://www.symantec.com/business/support/index?page=content&id=TECH142375&actp=search&viewlocale=en_US&searchid=1309180518781
or update the ArchivingState field in the EnterpriseVaultDirectory's "Archive" table, to set ArchivingState from 1 to 2
i.e. UPDATE Archive SET ArchivingState = 2 WHERE ArchivingState = 1 AND ArchiveName = 'Smith, John'
2. If you can change it in AD first that would be the easiest way , because then EV will just take the name, otherwise just write a sql script that updates the Archive table in the Enterprise Vault Directory database, something like
UPDATE Archive SET ArchiveName = 'Smith, John (Left The Business)' WHERE ArchiveName = 'Smith, John'
3. Use EVPM to remove the permissions set using the following technote
http://www.symantec.com/business/support/index?page=content&id=TECH44818&actp=search&viewlocale=en_US&searchid=1309180240202
Then use EVPM or the Vault Admin Console to grant the permissions you do want on those archives
http://www.symantec.com/business/support/index?page=content&id=TECH69114&actp=search&viewlocale=en_US&searchid=1309180240202
