There seems to be very limited options in Powershell when it comes to Enterprisevault.

In this blog I am sharing a experience of Enterprisevault 9.0 where we have to cleanup around 6000 User Vaults & PowerShell is a no go here because No such cmdlets exists.

So let ‘s get back to old school & use some other methods for speeding up the things 🙂

Some of you might have already guessed that I will be using some SQL way 🙂

Yes there is a inbuilt SQL stored procedure that I will use along with Notepad ++  else it would be very clumsy task.

Let’s start & get the List of User Alias or SaMaccount Names that needs removal.

Prepare the below command using Notepad++ (Same method we used in one of the older post of DL upgrade a year ago)

Copy the ids as below –> Notepad++

Click on Search –> Replace (You can use Cntrl + H as well)

Now use the Regex Pattern –   ^(.+)$ (Find What)

Replace with : or MbxAlias = ‘\1’

Hit Replace All to see the magic 🙂

Now you need to connect SQL server with SQL management studio & run the below query on EnterprisevaultDirectory database in-order to get the Defaultvaultid as that would be used when running the stored procedure.

select MbxNtuser,MbxAlias,DefaultVaultId from ExchangeMailboxEntry

where MbxAlias = ‘User1’

or MbxAlias = ‘User2’

or MbxAlias = ‘User3’

or MbxAlias = ‘User4’

or MbxAlias = ‘User5’

or MbxAlias = ‘User6’

Note: I have removed the first “or”, rest is just copy pasted.

Result from SQL:

Now copy this result & have the default vault ids in Notepad++

Follow the same procedure & build the command:

exec DeleteArchive ‘value copied to the clipboard for the Archive ID’

exec DeleteArchive ‘value copied to the clipboard for the Archive ID’

exec DeleteArchive ‘value copied to the clipboard for the Archive ID’

Stop the EV Storage service on the servers hosting the Vaults.

Open SQL management studio & run the command

use EnterpriseVaultDirectory

exec DeleteArchive ’16C529AC6165F6D479B0048769E64D03XXXXXX’

exec DeleteArchive ’16A30218AB8B4B6488BA98951679C2XXXXXXX’

exec DeleteArchive ‘1421E7F03089D0142BCD89459298XXXXXX’

exec DeleteArchive ’16E402CBA5D1C2648BEB5DC782AD6BXXXXX’

exec DeleteArchive ‘1BACE631613CB064BBEB6C13D2D515XXXXXX’

I always runs in the chunks of 500 or 1000, few might result in obvious errors because of legal holds, rest all will run fine.

After work is finished , start the EV Storage Service .

If you provision the user vaults  based on AD group than remove these users from that group as well, use one  of my scripts (search in my blog or technet gallery, you will easily find examples)

Finally you have to remove these users from the “ExchangeMailboxEntry” table , for this as well, you can use the same approach of Notepad++

delete from ExchangeMailboxEntry

where MbxAlias = ‘user1

or MbxAlias = ‘user2’

or MbxAlias = user3′

Let me know if you have any questions on the above process.

Note: Please take Veritas buy-in before following this method in your environment..

 

Tech Wizard

https://techwizard.cloud

https://syscloudpro.com/