cancel
Showing results for 
Search instead for 
Did you mean: 

Need help with SQL Query

Donnal_Spence
Level 4

I am trying to find all Archive ID's that are tied to a specific Vault Store.

1 ACCEPTED SOLUTION

Accepted Solutions

GabeV
Level 6
Employee Accredited

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.

View solution in original post

3 REPLIES 3

GabeV
Level 6
Employee Accredited

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.

Donnal_Spence
Level 4

Thank you, this worked perfectly.

GabeV
Level 6
Employee Accredited

Glad to help