How to Disable Bulk Users from Archiving

[Ahmed_Abd_ElGel]

Dears,

I have enviroment consists of Windows 2003 Domain, Exchange 2007, Enterprise Vault 2007

Now i have about 700 users Items from AD not deleted but disabled

I need to know is there are an automated way to disable them from Archiving, without follow the disable user wizard and choose one by one

Thanks in advance

Ahmed Abd ElGelil

[jimbo2]

You can access the SQL server and run a Query on the EnterpriseVaultDirectory database below.

SELECT     *
FROM         ExchangeMailboxEntry
WHERE     (MbxArchivingState = 2)

This will return all of the disabled users.

0 = new

1 = Enabled

2 = Disabled

You can use the SQL UPDATE command to fine the entries with (2) and replace them with (1).

Here is a link to the update command:

http://www.comptechdoc.org/independent/database/begin/sqlupdate.html

Find everything with MbxArchivingState = (2) and make MbxArchivingState (1).

Backup your directory DB before you complete any updates.

Let me know if it works.

[Ahmed_Abd_ElGel]

Dear Man,

Thank you for your reply

the situation is I have some users in Active directory was disabled and the same accounts are enabled in Enterprise vault

I need to disable them from enterprise vault, why i should touch SQL in this case???

Thanks in advance

Ahmed Abd ELGelil

[jimbo2]

Because you stated that you did not want to use the GUI.

[Ahmed_Abd_ElGel]

dear sir,

first of all thank you for keep replying me question, i'll ask it with a different way because i feel that's i didn't discribe it propapbly

i Have some users which is 700 users disabled from active directory

the same users is enabled from EV, which i think is marked as enabled also at SQL Database

I need to find a way to go and check which disabled users at AD then disable them at EV with automated way

if there are a way from GUI ok, but i didn't want to go through Enabled users and choose them one by one

My AD has about 8000 Users

That's my question hope you got me right and have solution for me

Thanks in advance

Ahmed Abd ElGelil

[TonySterling · Accepted solution]

If you add users to a specific dept or group you could set an EVPM script to disable them and run it nightly.  There is more information on EVPM in the Policy Manager section of the Utilities guide.

[Directory]
DirectoryComputerName = Vaultserverthathostsdirectoryservice
Sitename = sitenamefromadminconsole

[Mailbox]

LDAPquery = department= dept42

[Folder]
Name = MailboxRoot
Enabled = False
Suspended = False

[bobby_hilliard]

Now, with the utilities manual, I'm dangerous. Your reply pointed me to be able to use a group to do the disabling!

 It pays to search.

Thanks.