Set Permission on Enterprise Vault Accounts with EVPM

Here we are going to discuss how to set permission on some EV account to a user by using EVPM script. Below script will help you with the same.

1. Create a file with notepad and save the same in UNICODE format, with an .ini extension.
2. Copy below script to the .ini file created in 1st step and modify with your environmental value on DirectoryComputerName, SiteName, ArchiveName and  Yourdomain\User.

How to Use EVDuplicateCleaner.exe

Symantec has found that under some circumstances post-processing failed to convert items to shortcuts resulting in duplicates in the archive. They have released a tool called EVDUplicateCleaner and the same is available in ClickHere. Since the documentation for the tool is not that clear I thought of writing my experience with the tool here

1 Create report of duplicated items

The tool has 2 options to create reports one is ‘summary’ and other is ‘report ‘. Summary gives you a just summary and report gives you detailed report of duplicate items from a specified archive or entire archive from a specific EV Store.

How to set ‘Archive Usage Limit’ above 16GB for a user in Enterprise Vault

Issue
When you try to set ‘Archive Usage Limit’ for a user from VAC, if the value is above 16Gb, you will get error ‘Enter and integer between 0 and 16000’,

Solution
Its by design and you have to apply the solution via SQL

Prepare Exchange 2010 for Enterprise Vault

To prepare Exchange 2010 for Enterprise vault you should do 2 steps from Exchange 2010 side, that are,
1. Create a throttling policy and assign to EV service account
2. Set permission for EV service account on Exchange
Note;- please make sure that your EV service account has a mailbox in Exchange 2010 before following the below steps.
Create a throttling policy and assign to EV service account
To create a required throttling policy Symantec has give proper PowerShell script which is available with installation media,
1. Go to EV installation media and brows ‘Symantec Enterprise Vault 9.0.3\Server\PowerShellScripts\PowerShellScripts’

EVPM Script for bulk archive

There was a bulk mailbox archive request and its was tough to run the script for each user to change the default policy which force EV to archive mails from users who already left the organization.  Finally we have decided to create a group and include LDAP query in the EVPM script, below is the script which i was using.
[Directory]
directorycomputername=localhost ; Localhost can be changed by the server name
sitename=EVSITE ; Site name of EV

How to report Number of Archived Items and Size

There are various options you have for reporting Number if items in archive and size of archive. Lets check these possibilities
Option 1
1. Go to VAC [Vault Admin Console] 
2. From Admin Console go to Storage Group –> Store –>Right Click—> reporting
Option 2
Run below query against EV Store Database

Find when the archives are created

Below query will will list result of date when the archive accounts are created for all users who belongs to a particular store. Rename ‘VaultStore’ to your Vault store database name before running the query.

SELECT A.ArchiveName, AP.CreatedDate
FROM   EnterpriseVaultDirectory.dbo.Archive A,
       EnterpriseVaultDirectory.dbo.Root R, 
       VaultStore.dbo.ArchivePoint AP
WHERE  A.RootIdentity = R.RootIdentity
  AND  R.VaultEntryId = AP.ArchivePointId
ORDER BY A.ArchiveName

How to find Count of items archived per Archive

 
If you ask me ‘How to find count of item archived since certain dates & archived by a specific archiving task? Oh! its not that easy, I would say. But I always feel that there is a solution for each question!
As far I know the only possible way through we can achieve this goal is by writing a SQL query, below query will help you to find ‘number of items’ and ‘Size of items’ archived into a specific store from each Exchange server/task. You have to change the Vault Store DB name and desired date before running this query.

Backup SQL Database to Share

 

For backing the SQL database to share you should make sure that below points are correct.

1. The service account should have access to share where you are going keep the backup file.

2. The account which you are using should have permission to backup the DB.

If above conditions are met then below query can be used,

USE VaultStore01
GO
BACKUP DATABASE VaultStore01
To Disk = '\\Server01\\SQLBackup\VaultStore01.bak' WITH FORMAT, INIT;
GO

Note;- in above example ‘VaultStore01’ is the name of Database and ‘\\Server01\\SQLBackup\’ is the share where backup file is kept. You should use WITH FORMAT, INIT otherwise the file will append and that create free space issues.

Configure Windows Search for Vault Cache

Enterprise vault is improving much and it has an option to enable/facilitate windows search on cached archived mails. This article will help you to configure Windows search for vault cache.

This article has 3 sections and these are easy steps to follow

I Enable WDS Search auto-enable from EV policy

1. Login to Enterprise Vault server by using EV service account.

2. From VAC got to Policies>Exchange>Desktop

3. Right click on policy and go to properties

4. In properties go to ‚Advanced‘ tab and Vault Cache from dropdown menu

5. Slect WDS search auto-enabled and click on Modify tab

6. From Modify Setting window select Foce On and click on OK

7. Click Apply from properties of polcy it will prompt that “….the change will take affect when the task syncrononize next time….” Click on OK

II Run EV tasks manually to force the policy change.

1. From VAC go to Enterprise Vault Servers>server>Taks

2. Select the tasks and go to properties

3. From properties go to Synchronization tab and make sure that ‘All mailboxes’ are selected and click on ‘Synchonize’

4. Follow above steps for all tasks

II Make sure that Windows search is enabled for EV Cache from client side

1. Login to client computer.

2. Go to Control Panel

3. Select Indexing Options

4. In Indexing Options go to Modify

5. From Indexed Locations make sure that Symantec Vault Cache is slected for the user.

6. Click on OK

How to reset Enterprise Vault Cache from outlook 2003 and 2010

This post has 2 sections, section 1 talks about how we do it from Outlook 2010 and Section 2 talks about how we do it from Outlook 2003. This article can be used when you see your EV cache is not syncing due to ‘x’ reasons.

I. Reset Vault Cache from Outlook 2010.

1. Open Outlook

2. Hold the Ctrl+Shift keys and click on any of the EV icons on either, refer below screenshot

This will launch the EV Diagnostics window ,

3. From ‘Enterprise Vault Diagnostic’ window click on ‘Reset’ icon under Vault Cache.

4. Click on ‘Yes’

5. Click on OK

6. Close ‘Enterprise Vault Diagnostic’ window by clicking on OK .

7. Restart Outlook and check the status.

II. Reset Enterprise Vault Cache from Outlook 2003.

1. Open outlook 2003

2. Hold CTRL + SHIFT and click on an EV button in Outlook

3. Click on the button to reset the offline vault.

4. Respond Yes to the warning message

5. Close outlook.

6. Open outlook and see the status.