Forum Discussion

GertjanA's avatar
GertjanA
Moderator
6 years ago

Remove Archive Permission SQL

Hello all,

I have an old EV environment (9.0.4) which has no longer Exchange servers, or EV System Mailbox. We're migrating personal archives to Exchange. There is a need to remove permissions from archives which have been migrated.

As there is no Exchange/systemmailbox anymore, I am unable to use EVPM. Due to the version, I can also not use any powershell commands.

Can I somehow remove permissions for specific archives using SQL?

Thanks.

  • GertjanA's avatar
    GertjanA
    6 years ago

    Hi,

    I did assume, but the format for using EVPM requires defining an Exchange server and mailbox, which are checked for existence.

    I tried several options, but all failed. We might now spin up an old VM, if we have that, and if it is possible in our environment.

  • Prone2Typos's avatar
    Prone2Typos
    Moderator
    6 years ago

    zapping an archive in EVPM does not require Exchange I think. I have not tried in a while but know zapping a mailbox does, but think zapping an archive does not. Did you assume or test?

    • GertjanA's avatar
      GertjanA
      Moderator
      6 years ago

      Hi,

      I did assume, but the format for using EVPM requires defining an Exchange server and mailbox, which are checked for existence.

      I tried several options, but all failed. We might now spin up an old VM, if we have that, and if it is possible in our environment.

      • Prone2Typos's avatar
        Prone2Typos
        Moderator
        6 years ago

        We use the following in our ini files:

         

        [Directory]
        directorycomputername = MyComputer
        sitename = MySite
         
        [VaultPermissions]
        VaultName = MyVault
        Zap = true
         
        IIRC the command line takes the Exchange mailbox or server or something. I am pretty sure that this ini file does not require a valid exchange server to be in existance.... but perhaps it wants the EV records in the DB assocaited with that exchange server to start it off.
         
        I am like 89% sure it does not have to be up though because I think run this regularly against archives where the mailbox woudl be inaccessible to EV.