10-29-2013 07:17 AM
I am trying to find all Archive ID's that are tied to a specific Vault Store.
Solved! Go to Solution.
10-29-2013 07:30 AM
Hi Donnal,
You can try this query
USE EnterpriseVaultDirectory SELECT ArchiveView.ArchiveName, ArchiveView.VaultEntryId, VaultStoreEntry.VaultStoreName FROM ArchiveView INNER JOIN VaultStoreEntry ON ArchiveView.VaultStoreEntryId = VaultStoreEntry.VaultStoreEntryId WHERE (VaultStoreEntry.VaultStoreName = '[VAULT_STORE_NAME]')
Just replace
[VAULT_STORE_NAME]
with the name of the vault store. VaultEntryId contains the ArchiveID.
I hope this helps.
10-29-2013 07:30 AM
Hi Donnal,
You can try this query
USE EnterpriseVaultDirectory SELECT ArchiveView.ArchiveName, ArchiveView.VaultEntryId, VaultStoreEntry.VaultStoreName FROM ArchiveView INNER JOIN VaultStoreEntry ON ArchiveView.VaultStoreEntryId = VaultStoreEntry.VaultStoreEntryId WHERE (VaultStoreEntry.VaultStoreName = '[VAULT_STORE_NAME]')
Just replace
[VAULT_STORE_NAME]
with the name of the vault store. VaultEntryId contains the ArchiveID.
I hope this helps.
10-29-2013 07:41 AM
Thank you, this worked perfectly.
10-29-2013 08:26 AM
Glad to help