Forum Discussion

Ahmed_Abd_ElGel's avatar
Ahmed_Abd_ElGel
Level 4
17 years ago

How to Disable Bulk Users from Archiving

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
Enterprise Vault
Information Governance
  • TonySterling's avatar
    TonySterling
    17 years ago
    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

6 Replies

Sort By
  • jimbo2's avatar
    jimbo2
    Level 6
    17 years ago
    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:
     
    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's avatar
    Ahmed_Abd_ElGel
    Level 4
    17 years ago
    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's avatar
    jimbo2
    Level 6
    17 years ago
    Because you stated that you did not want to use the GUI.
  • Ahmed_Abd_ElGel's avatar
    Ahmed_Abd_ElGel
    Level 4
    17 years ago
    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's avatar
    TonySterling
    Moderator
    17 years ago
    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's avatar
    bobby_hilliard
    Level 5
    15 years ago
    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.