Video Screencast Help

SQL Query

Created: 25 Jul 2013 • Updated: 12 Aug 2013 | 6 comments
This issue has been solved. See solution.

We are using Enterprise Vault 9.0.2 for Exchange. I am looking for a SQL script which displays all the permissions has been added to particular Vault

 

Say for example for “ABC” vault account in the permission tab how many account has been added automatically. We have dual domain environment so wanted to validate few things.

Operating Systems:

Comments 6 CommentsJump to latest comment

GabeV's picture

Unfortunately, that information is encrypted in the Enterprise Vault database as a binary format. You could to use PermissionsBrowser.exe to read the permissions. Also, this forum might help you on this issue:

https://www-secure.symantec.com/connect/forums/que...

“Success is not final, failure is not fatal: it is the courage to continue that counts.”–Winston Churchill

Pradeep_Papnai's picture

If you looking to find out permssion on particular vault (archive) then permission browser (c:\program file\enterprisevault\permissionbrowser.exe) is best tool to know that information.

http://www.symantec.com/docs/TECH56331

Permission information remain in column AutoSecurityDesc (automatic permission) & ManualSecurityDesc (Manual permission) of table Root for Archives & ArchivefolderView for folders in EV directory database, the information in encrypted format, so making SQL query would not help.

Pradeep_Papnai's picture

The above tech note showing for 'public folder' archives, just to inform it is applicable for other type of archives as well. Same information also present in TN http://www.symantec.com/docs/HOWTO37539
 

Pradeep_Papnai's picture

Hi San,

Did you get the answer what you was looking for ?

Regards
EV-C

San_Bangalore's picture

Yes, but if you have a any other suggestions that will help

Pradeep_Papnai's picture

Unfortunately, we don't have much option see archive permission via scipt files, This is the question being asked by many people, I would suggest you to put Enhancement Idea so this functionality can be added in future version of EV.

SOLUTION