cancel
Showing results for 
Search instead for 
Did you mean: 

forcefully disable mailboxes using sql script

EVMan
Level 4

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 ACCEPTED SOLUTION

Accepted Solutions

JesusWept3
Level 6
Partner Accredited Certified

1. Use an EVPM Script to Zap the vault:
http://www.symantec.com/business/support/index?page=content&id=TECH142375&actp=search&viewlocale=en_...

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_U...

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_U...

https://www.linkedin.com/in/alex-allen-turl-07370146

View solution in original post

1 REPLY 1

JesusWept3
Level 6
Partner Accredited Certified

1. Use an EVPM Script to Zap the vault:
http://www.symantec.com/business/support/index?page=content&id=TECH142375&actp=search&viewlocale=en_...

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_U...

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_U...

https://www.linkedin.com/in/alex-allen-turl-07370146