Set a Bunch of user to "Will not be deleted"

[jpergola329]

is there a script/or a way to set a bunch of users to "Will not be deleted" once added to EV.

im adding about 100 people and need to set them to "Will not be deleted" once they added to the Vault.

thanks

ev8 sp3

[JesusWept3]

Are you talking about stopping the archives from being deleted? Or stopping their content from being expired? Or denying the users the ability to delete archived email? You cannot stop an archive from being deleted unless all their content is archived in a retention that doesn't allow email to be deleted You can exclude the users from expiry by going to the properties of their archive and unchecking the allow items to expire checkbox And you can stop them from deleting email by archiving their items In a retention that doesn't allow user deletes or by setting the site property to not allow users to delete or giving manually assigning their username to their archive and checking the deny deletion

[JesusWept3]

Oh and just noticed the version, only EV10 has an option to allow users not to be able to delete but still allow expiry to delete items

[jpergola329]

sorry, i mean once they are in EV and have the items not delete in the expiry process even though it may be in a folder that is set to expire.

see attached screenshot.

[JesusWept3 · Accepted solution]

K so you can either go to the properties of the archive, then go to the Advanced Tab
Uncheck "Delete Expired Items From This Archive Automatically"

or run this following SQL Query against the EnterpriseVaultDirectory database

UPDATE Archive
SET DeleteExpiredItems = 0
WHERE ArchiveName IN ('User1','User2', 'User3')

[NaturesRevenge]

We went through the exact same scenario. Instead of relying on an accurate DA search to protect content for custodians in a litigation, we had to instead exclude custodian Vaults from expiry. Groan.

Anyway, the SQL query JW3 advises worked for us as well.

[jpergola329]

its not working, for the 'user1' i put the archive name correct ie: 'Pergola, Joe'

thanks

[JesusWept3]

is the SQL update throwing an error?
you probably need to exit out of the Vault Admin Console and go back to refresh the view
It may also be caching the results so you may need to restart the Directory Service and reload the Vault Admin console

[GabeV]

@jpergola329,

If you want to modify this setting "Delete Expired Items From This Archive Automatically", you need to do it through the Enterprise Vault Admin Console.

@JesusWept3

Direct SQL updates to the Enterprise Vault Directory database are not supported by Symantec. When an archive is modified through the Enterprise Vault Admin Console, Enterprise Vault doesn't go directly and run an update in the database. There are several settings and conditions verified and checked BEFORE the update takes place. Thus, you might end with an inconsistent archive for other operations.

[NaturesRevenge]

I just went back to my notes and our experience was consistent with what GabeV is saying. I was forced to use the VAC to unselect each individual Vault from expiry.

[JesusWept3]

And just what would those conditions be? 
Because tracing it, all that happens is it does a CheckAndQualifyNTAccount to convert a SID to an NT Account name, and then it calls SQL with UpdateArchive, and the UpdateArchive does very little after that

SO yeah, really all you need to do is restart the EV services at that point as it could be cached.

But i tried the SQL update, refresh in cache, shows won't be deleted
Did a run now in Report Mode 

Number of Vaults Processed: 2003
Number of vaults enabled for expiry: 0
Total number of expired items: 0

Flipped it back to DeleteExpiredItems back to 1

Number of Vaults Processed: 2003
Number of Vaults Enabled For Expiry: 2003
Total Number of Expired Items: 6358

So yeah, enabling through the console does nothing more than call the stored procedure UpdateArchive

[jpergola329]

pls see atteched.

thanks

[TonySterling]

What database did you run it against?  Make sure it is running against the EnterpriseVaultDirectory database or put "USE EnterpriseVaultDirectory" as the first line of the query.

[jpergola329]

thanks!!

worked.