18
Copyright © Acronis, Inc., 2000-2009
5.6
Vaults report
5.6.1
Description
The
Vaults
view contains the centralized vaults—both managed and unmanaged. The vault type
(whether the vault is managed or not) is determined by the
IsManaged
column. The
HostID
column
refers to the storage node that currently manages the vault (for an unmanaged vault, the value in this
column is
NULL
).
5.6.2
Query samples
The following query returns the managed vaults whose storage is located on a network share
with a name starting with
\\server\backups
SELECT * FROM Vaults WHERE
IsManaged = 1 AND
StoragePath LIKE '\\server\backups%'
The following query returns the managed vaults that are both deduplicated and compressed—
and thus are potentially slow:
SELECT * FROM Vaults WHERE
IsDeduplicated = 1 AND
CompressionLevel <> 'NONE'
5.6.3
Column values
The
Vaults
view contains the following columns:
Name
– The name of the vault
IsManaged
– Equals 1 if the vault is managed; otherwise, equals 0
OwnerName
– The name of the user who created the vault
OwnerUID
– The unique identifier of the user who created the vault
Comments
– The vault comments
StoragePath
– The path to the folder where the archives are stored and—for deduplicated
vaults—where the deduplication data store is located
DatabasePath
– The path to the folder where the vault's database is located. For centralized
unmanaged vaults, the value in this column is an empty string (
''
).
IsDeduplicated
– Equals 1 if the vault is deduplicated; otherwise, equals 0
EncryptionAlgorithm
– Encryption level for the vault. Managed vaults can be encrypted by using
the Advanced Encryption Standard (AES), with a key size of 128, 192, or 256 bits. Unmanaged
vaults cannot be encrypted.
NONE
– The vault is not encrypted.
AES128
– The managed vault is encrypted by using a 128-bit key.
AES192
– The managed vault is encrypted by using a 192-bit key.
AES256
– The managed vault is encrypted by using a 256-bit key.
CompressionLevel
– The compression level for the vault. Only deduplicated vaults can be
compressed.
NONE
– The vault is not compressed.
NORMAL
– The deduplicated vault is compressed.
ID
– The unique identifier of the vault