Try to find out Vault Store users

[mayu]

Dear All,

Can we find out which user resides on which vault store. Basically we are going to conduct sql specific activity on our all databases. 

We will test this on our test database if everything goes fine we will perform it on rest of the vault store databases.

Thanks in advance

[Rob_Wilcox1]

You can see this information in the Vault Admin Console.

Go to the Archives -> Exchange Mailbox area. You can sort by Vault Store.

Remember if you're doing SQL specific maintenance, and you have several Vault Store Groups, depending on your sharing level there might be more impact, because when you do the maintenance on the Vault Store Group database, each vault store sharing information through that group database will also be affected.

[Rob_Wilcox1 · Accepted solution]

And you can do this:

select vaultstoreentry.VaultStoreName, archivename from 
archiveview, VaultStoreEntry
where archiveview.VaultStoreEntryId = VaultStoreEntry.VaultStoreEntryId
order by vaultstoreentry.vaultstorename, archivename    

[mayu]

Thanks Rob