Storage Viewer for Backup Database Views > apt_v_avm_retention_policies
  
Version 10.0.01
apt_v_avm_retention_policies
The apt_v_avm_retention_policies view contains one row per retention policy defined on an Avamar system.
Table 3.34 apt_v_avm_retention_policies
Column Name
Data Type
Description
avm_domain_id
NUMBER
Avamar Domain ID
daily
NUMBER
Advanced policy daily retention
duration
NUMBER
Duration of retention
exists_in_catalog
STRING
Indicates if the retention policy is in the catalog
expiration_date
DATE
Expiration date of this policy
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
is_enabled
STRING
If Y, this retention policy can be used
is_link
STRING
If Y, this policy is an alias for another policy
is_override
STRING
If Y, advanced policy is being used
is_read_only
STRING
If Y, this policy cannot be changed
last_updated
DATE
Date and time of last update
master_server_id
NUMBER
Master server ID
monthly
NUMBER
Advanced policy monthly retention
parent_retention_policy_id
NUMBER
foreign key into apt_v_avm_retention_policies to the parent of this policy if any
policy_nbr
NUMBER
Policy number. Valid values are:
0 - Undefined
1 - Compute expiration date
2 - Static expiration date
3 - No expiration date
retention_policy_id
NUMBER
primary key of apt_v_avm_retention_policies
retention_policy_name
STRING
Name of this retention policy
unit
NUMBER
Duration unit. Valid values are:
0 - No expiration
1 - Days
2 - Weeks
3 - Months
4 - Years
weekly
NUMBER
Advanced policy weekly retention
yearly
NUMBER
Advanced policy yearly retention