02-20-2015 12:14 AM
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
Solved! Go to Solution.
02-20-2015 12:31 AM
And you can do this:
select vaultstoreentry.VaultStoreName, archivename from
archiveview, VaultStoreEntry
where archiveview.VaultStoreEntryId = VaultStoreEntry.VaultStoreEntryId
order by vaultstoreentry.vaultstorename, archivename
02-20-2015 12:25 AM
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.
02-20-2015 12:31 AM
And you can do this:
select vaultstoreentry.VaultStoreName, archivename from
archiveview, VaultStoreEntry
where archiveview.VaultStoreEntryId = VaultStoreEntry.VaultStoreEntryId
order by vaultstoreentry.vaultstorename, archivename
02-23-2015 09:26 PM
Thanks Rob