Determine Permissions on User Archive - SQL Query
I am running an Enterprise vault 18.104.22.1683 environment along with Exchange 2010 and SQL 2008 R2.
I have a powershell script which generates a csv file that contains details of archives which have Mailbox which is not in nomal state and/or AD account which is not in normal state.
This csv file is then emailed and is used for deleting/removing any orphaned archive.
However, there's one more parameter which I need to complete and that is archives which have read/write access on them for some other user account than default (like User B has permissions on User A archives apart of him/her) - So we do not delete archives which are still accessed (we don't have auditing configured)
Is there a way to pull this information from SQL? I know there're some extra tools like PermissionExplorer.exe but to complete the powershell script, I'll need SQL statement to pull out this information....
I'll surely share complete script once it is complete along with this information.
Thanks in advance