Backup Manager Database Views > Detailed View Descriptions (Avamar)
  
Version 9.2.00
Detailed View Descriptions (Avamar)
apt_v_avm_activities
The apt_v_avm_activities view contains all non-replication jobs on an Avamar system.
Table 3.17 apt_v_avm_activities
Column Name
Data Type
Description
avm_domain_name
string
Full domain of the client on this activity
avm_group_id
number
Foreign key into the apt_v_groups view
backup_label
string
The user-assigned backup label for this activity
backup_nbr
string
The backup number for this activity
client_id
number
Client ID number
client_name
string
Client Name
dataset_id
number
Foreign key into the apt_v_datasets view
dataset_name
string
Name of the dataset used in the activity
effective_expiration_date
date
The expiration date of this activity as a string
effective_path
string
The effective dataset used in the activity
encryption_name
string
Name of encryption method used
error_code
number
Last error code generated by this activity
excluded_kb
number
Number of bytes excluded
expiration_date
date
Expiration date of this activity
expiration_text
string
Text of the expiration date - may also be NEVER
group_name
string
Name of the group used in this activity - applies to group-based backups only
gsan_system_id
string
System-generated Avamar system ID
gsan_system_name
string
User-supplied Avamar system name
initiated_by
string
Name of the user who initiated this backup - applies to on-demand backups only
is_encrypt_server_auth
string
True if mcserver.xml encrypt_server_authenticate preference is set true. Otherwise, false
is_override_dataset
string
Is the dataset used an override? Y/N
is_override_ret_policy
string
Did the activity override the group retention policy? Y/N
job_id
number
Primary key of the underlying table
modified_kb
number
Number of bytes modified
modified_not_sent_kb
number
Number of non-unique bytes modified
modified_sent_kb
number
Number of unique bytes modified
nbr_files_skipped
number
Number of files skipped due to errors
new_kb
number
Number of new bytes
overhead_kb
number
Number of bytes of system overhead
plugin_id
number
Foreign key into the apt_v_plugin_catalog view
recorded_date
date
Date this activity was recorded in MCS
retention_policy_id
number
Foreign key into the apt_v_retention_policies
scanned_kb
number
Number of bytes scanned for de-duplication
schedule_end_date
date
Scheduled end date
schedule_id
number
Foreign key into the apt_v_schedules_2 view
schedule_name
string
Name of the schedule used in this activity - applies to group-based backups only
schedule_start_date
date
Scheduled start date
server_id
number
Server ID number
session_id
string
The system-generated session id for this activity
skipped_kb
number
Number of bytes skipped due to errors
status_code
number
Last status code generated by this activity
status_code_summary
string
Text of the status code
vendor_job_type
string
Type of activity
work_order_name
string
Work order for this activity
apt_v_avm_clients
The apt_v_avm_clients view contains all the clients recognized by the Avamar system being reported.
Table 3.18 apt_v_avm_clients
Column Name
Data Type
Description
agent_version
STRING
Avamar agent version
allow_overtime
STRING
Indicates if overtime is allowed
allow_user_snapup
STRING
Indicates if user snapup is allowed
allow_user_snapup_filesel
STRING
Indicates is user snapup file system is allowed
avm_domain_name
STRING
Avamar domain name
backup_date
DATE
Backup date for the client
can_page
STRING
Indicates if pagination is active
checkin_date
DATE
Check-in date
cid
STRING
Client ID name
client_id
NUMBER
Client ID number
contact_email
STRING
Client contact email
contact_location
STRING
Client contact location
contact_name
STRING
Client contact name
contact_notes
STRING
Client contact notes
contact_phone
STRING
Client contact phone
created_date
DATE
Date this client was created in MCS
enabled
STRING
If Y, client can be backed up
has_backups
STRING
If Y, client has backups
is_override_ret_policy
STRING
If Y, client can override group retention policy
is_registered
STRING
If Y, client has checked into MCS
master_server_id
NUMBER
Master server ID
modified_date
DATE
Date this client was last modified
os_type
STRING
Client operating system
override_dataset
STRING
If Y, client can override group dataset
override_init_ret_policy
STRING
If Y, allow override of standard retention policy on user-initiated backups
override_retry_count
STRING
If Y, client can override group retry settings
override_timeout
STRING
If Y, client can override group timeout settings
overtime_option
STRING
One of the following:
ALWAYS - Scheduled group backups are always allowed to run past the schedule duration setting
NEXT - Only the next scheduled group backup is allowed to run past the schedule duration setting
NEXT_SUCCESS - Scheduled group backups are allowed to run past the schedule duration setting until a successful backup is completed
NEVER - Scheduled group backups are never allowed to run past the schedule duration setting
page_addr_locked
STRING
If Y, address cannot be automatically updated by MCS
page_address
STRING
The IP address used to contact this client
page_port
NUMBER
Port number at which to contact this client
plugin_backup
STRING
Plugin used for last backup
registered_date
DATE
Registered date/time
restore_only
STRING
If Y, client can only do restored
retry_count
NUMBER
Connection retry count
timeout
NUMBER
Connection timeout value
apt_v_avm_datasets
The apt_v_avm_datasets view contains one row per dataset defined on an Avamar system.
Table 3.19 apt_v_avm_datasets
Column Name
Data Type
Description
avm_domain_id
NUMBER
Avamar domain ID
dataset_id
NUMBER
primary key of this view
dataset_name
STRING
Dataset name
exists_in_catalog
STRING
Indicates if the dataset is in the catalog
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
is_all_data
STRING
GSAN system name
is_link
STRING
Indicates all data
is_read_only
STRING
Indicates if read-only dataset
last_updated
DATE
Date and time last updated
master_server_id
NUMBER
Master server ID
parent_dataset_id
NUMBER
Parent dataset
apt_v_avm_event_catalog
The apt_v_avm_event_catalog view contains one row per possible event that could be generated in an Avamar system.
Table 3.20 apt_v_avm_event_catalog
Column Name
Data Type
Description
category
STRING
Avamar event catalog category
event_catalog_code
NUMBER
Avamar event catalog code
event_catalog_id
NUMBER
Primary key of this view
event_catalog_name
STRING
Name of this event
event_catalog_type
STRING
Type of event
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
master_server_id
NUMBER
Master server ID
object
STRING
Object causing this event
operation
STING
Operation for the event
severity
STRING
Severity of this event
software_source
STRING
Source of this event
summary
STRING
Summary description of this event
apt_v_avm_dpn_statistics
The apt_v_avm_dpn_statistics view contains one row per statistics for Data Protection Network; contains one row per data set in an Avamar system.
Table 3.21 apt_v_avm_dpn_statistics
Column Name
Data Type
Description
data_protected_kb
NUMBER
Data Protected in KiB
dpn_date
DATE
Data Protection Network Date
last_updated
DATE
Last Updated Date
master_server_id
NUMBER
Master Server Identifier
apt_v_avm_dpn_statistics_log
The apt_v_avm_dpn_statistics_log view contains one row per statistics log for Data Protection Network; contains one row per data set in an Avamar system.
Table 3.22 apt_v_avm_dpn_statistics_log
Column Name
Data Type
Description
data_protected_kb
NUMBER
Data Protected in KiB
dpn_date
DATE
Data Protection Network Date
log_date
DATE
Log Date
master_server_id
NUMBER
Master Server Identifier
apt_v_avm_event_catalog
The apt_v_avm_event_catalog view contains one row per event generated by any component in an Avamar system.
Table 3.23 apt_v_avm_event_catalog
Column Name
Data Type
Description
category
STRING
Avamar event catalog category
event_catalog_code
NUMBER
Avamar event catalog code
event_catalog_id
NUMBER
Primary key of the view
event_catalog_name
STRING
Name of this event
event_catalog_type
STRING
Type of event
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
master_server_id
NUMBER
Master server ID
object
STRING
Object causing this event
operation
STRING
Operation currently being performed
severity
STRING
Severity of this event
software_source
STRING
Source of this event
summary
STRING
Summary description of this event
apt_v_avm_events
The apt_v_avm_events view contains one row per event generated by any component in an Avamar system.
Table 3.24 apt_v_avm_events
Column Name
Data Type
Description
audience
STRING
Intended audience of event
description
STRING
Long event description
event_catalog_id
NUMBER
Foreign key into apt_v_avm_event_catalog
event_data
STRING
Event data
event_date
DATE
Event date
event_id
NUMBER
Avamar system-generated event id
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
master_server_id
NUMBER
Master server ID
notes
STRING
Event notes text
remedy
STRING
Event remedy text
summary
STRING
Short description of event
apt_v_avm_gc_status
The apt_v_avm_gc_status view contains one row per Garbage Collection Status defined on an Avamar system.
Table 3.25 apt_v_avm_gc_status
Column Name
Data Type
Description
master_server_id
NUMBER
Master server identifier
status_id
NUMBER
Status identifier
result
STRING
Result
start_date
DATE
Start date of garbage collection
end_date
DATE
End date of garbage collection
elapsed_minutes
NUMBER
Elapsed time in minutes
no_of_passes
NUMBER
Number of passes
node_count
NUMBER
Number of nodes
recovered_bytes
NUMBER
Amount of recovered space
chunks_deleted
NUMBER
Chunks deleted
indexed_stripes
NUMBER
Number of indexed stripes
indexed_stripes_processed
NUMBER
Number of indexed stripes processed during garbage collection
last_updated
DATE
Date and time the apt_v_avm_gc_status was last updated in the database
apt_v_avm_group_members
The apt_v_avm_group_members view contains one row per client membership in a group in an Avamar system.
Table 3.26 apt_v_avm_group_members
Column Name
Data Type
Description
avm_group_id
NUMBER
Foreign key into apt_v_avm_groups
client_id
NUMBER
Foreign key into apt_v_avm_clients
dataset_id
NUMBER
Foreign key into apt_v_avm_datasets
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
is_client_dataset
STRING
If Y, then this group member uses the client dataset
is_client_ret_policy
STRING
If Y, then this group member uses the client retention policy
is_client_retry
STRING
If Y, then this group member uses the client retry setting
is_client_timeout
STRING
If Y, then this group member uses the client timeout setting
is_enabled
STRING
If Y, then this group member can be backed up
is_restore_only
STRING
If Y, then this group member can only do restores
last_updated
DATE
Date this group member was last updated
master_server_id
NUMBER
Master server ID
retention_policy_id
NUMBER
apt_v_avm_groups
The apt_v_avm_groups view contains one row per group in an Avamar system.
Table 3.27 apt_v_avm_groups
Column Name
Data Type
Description
avm_domain_id
NUMBER
Avamar Domain ID
avm_group_id
NUMBER
Avamar Group ID
created_date
DATE
Date the group was created
dataset_id
NUMBER
Dataset ID
exists_in_catalog
STRING
Indicates if the group is in the catalog
group_name
STRING
Avamar group name
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
Indicates if the group is enabled
is_failed_stop
STRING
Indicates if failed-stop is enabled
is_read_only
STRING
Indicates if the group is read-only
is_run_once
STRING
Indicates if run once is enabled
is_skip_next
STRING
Indicates if skip to next is enabled
last_updated
DATE
Last updated date for group
master_server_id
NUMBER
Master server ID
modified_date
DATE
Last modified date for group
priority
NUMBER
Priority of the group
retention_policy_id
NUMBER
Retention policy
retry_count
NUMBER
Retry count
schedule_id
NUMBER
Schedule ID
target_dpn
STRING
Target data protection network
timeout_min
NUMBER
Minimum timeout
apt_v_avm_node
The apt_v_avm_node view contains one row for each Avamar node.
Table 3.28 apt_v_avm_node
Column Name
Data Type
Description
access_mode
STRING
Access mode
disk_reads_kb
NUMBER
Disk reads in KiB
disk_writes_kb
NUMBER
Disk writes in KiB
dispatcher_port
NUMBER
Dispatcher port
last_updated
DATE
Date and time the Avamar node data was updated in the APTARE StorageConsole database.
load_average
NUMBER
Average load
master_server_id
NUMBER
Master server ID
network_reads_kb
NUMBER
Network reads in KiB
network_writes_kb
NUMBER
Network writes in KiB
node_id
STRING
Node number
number_stripes
NUMBER
Number of stripes
port
NUMBER
Port number
processor_utilization_pc
NUMBER
Processor Utilization %
run_level
STRING
Run level
server_utilization_pct
NUMBER
Server utilization %
status
STRING
Status of the Avamar node
total_capacity_kb
NUMBER
Total capacity in KiB
used_capacity_kb
NUMBER
Used capacity in KiB
version
STRING
Avamar version
apt_v_avm_node_log
The apt_v_avm_node_log view contains one row for each Avamar node.
Table 3.29 apt_v_avm_node_log
Column Name
Data Type
Description
disk_reads_kb
NUMBER
Disk Reads in KiB
disk_writes_kb
NUMBER
Disk Writes in KiB
load_average
NUMBER
Average Load
log_date
DATE
Date and time sample was taken
master_server_id
NUMBER
Master server ID
network_reads_kb
NUMBER
Network Reads in KiB
network_writes_kb
NUMBER
Network Writes in KiB
node_id
STRING
Node number
processor_utilization_pc
NUMBER
Processor Utilization %
server_utilization_pct
NUMBER
Server Utilization %
total_capacity_kb
NUMBER
Total Capacity in KiB
used_capacity_kb
NUMBER
Used Capacity in KiB
apt_v_avm_node_space
The apt_v_avm_node_space view contains space utilization data per node on an Avamar system.
Table 3.30 apt_v_avm_node_space
Column Name
Data Type
Description
capacity_mb
NUMBER
Disk size
disk_id
STRING
Disk number
disk_read_only
NUMBER
Value applied to normalize percent full
disk_utilization_pct
NUMBER
Percentage of storage space used
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
log_date
DATE
Date and time sample was taken
master_server_id
NUMBER
Master server ID
node_id
STRING
Node number
stripes_reserved_mb
NUMBER
Bytes reserved for stripe usage
stripes_used_mb
NUMBER
Amount of reserve stripe bytes used
used_mb
NUMBER
Disk capacity used
apt_v_avm_node_util
The apt_v_avm_node_util view contains node cpu and network utilization data per node on an Avamar system.
Table 3.31 apt_v_avm_node_util
Column Name
Data Type
Description
cpu_sys_pct
NUMBER
Percentage of node utilization by the operating system
cpu_user_pct
NUMBER
Percentage of node utilization by user
disk_read_only
NUMBER
Value applied to normalize percent full
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
load_average
NUMBER
Load average
log_date
DATE
date and time this sample was taken
master_server_id
NUMBER
Master server ID
nbr_of_disk_read_per_sec
NUMBER
Disk reads per second
nbr_of_disk_write_per_sec
NUMBER
Disk writes per second
net_in_per_sec_kb
NUMBER
Network received kb/s
net_out_per_sec_kb
NUMBER
Network transmitted kb/s
net_ping_sec
NUMBER
Node ping time
node_id
STRING
Identifier for this node in this Avamar system
node_state
STRING
Node state
node_utilization_pct
NUMBER
Percentage of storage space used
apt_v_avm_partition
The apt_v_avm_partition view contains one row per partition defined on an Avamar system.
Table 3.32 apt_v_avm_partition
Column Name
Data Type
Description
last_updated
DATE
Date and time last updated
master_server_id
NUMBER
Master server ID
no_offline_stripes
NUMBER
Number of offline stripes
no_transition_stripes
NUMBER
Number of transition stripes
node_id
STRING
Node identifier
partition_id
STRING
Partition identifier
state
STRING
State of the partition
total_capacity_kb
NUMBER
Total capacity of the partition in KiB
used_capacity_kb
NUMBER
Used capacity of the partition in KiB
apt_v_avm_plugin_catalog
The apt_v_avm_plugin_catalog view contains one row per plugin in an Avamar system.
Table 3.33 apt_v_avm_plugin_catalog
Column Name
Data Type
Description
content
STRING
Content description of this plugin
description
STRING
Description of this plugin
encryption_mode
STRING
Encryption methods used: SSL or proprietary
exists_in_catalog
STRING
Indicates if the plugin exists in the catalog
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
is_exp_target_support
STRING
If Y, plugin supports explicit targets
is_imp_target_support
STRING
If Y, plugin supports implicit targets
is_incl_imp_as_default
STRING
If Y, plugin includes implicit targets by default
is_multi_target_support
STRING
If Y, plugin supports multiple targets
last_updated
DATE
Date and time last updated
master_server_id
NUMBER
Master server ID
pid_number
NUMBER
Plugin number
plugin_id
NUMBER
Primary key of this view
plugin_name
STRING
Name of this plugin
plugin_version
STRING
Plugin version
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
apt_v_avm_schedules
The apt_v_avm_schedules view contains one row per schedule defined on an Avamar system.
Table 3.35 apt_v_avm_schedules
Column Name
Data Type
Description
avm_domain_id
NUMBER
Avamar Domain ID
description
STRING
Description of this schedule
end_date
DATE
Date at which this schedule expires
end_policy
NUMBER
Type of schedule termination setting. Valid values are:
2 - Never end
3 - Run N number of times
4 - End on a specific date
end_recurrence
NUMBER
End recurrence. If end_date is not specified, this is a count of the number of times the schedule should run or 0 if it never ends
exists_in_catalog
STRING
Indicates if the schedule is in the catalog
first_start_date
DATE
First date this schedule was used
gsan_system_id
STRING
System-generated identifier for this Avamar system
gsan_system_name
STRING
User-assigned identifier for this Avamar system
interval_mod
NUMBER
Interval mode
is_enabled
STRING
If Y, this schedule can be used
is_fixed_interval
STRING
Indicates if it is a fixed interval schedule
is_link
STRING
If Y, this schedule is an alias for another schedule
is_override_endtime
STRING
If Y, schedule end time can be overridden
is_read_only
STRING
If Y, schedule cannot be modified
last_check_date
DATE
Last schedule check date
last_start_date
DATE
Last start date
last_updated
DATE
Date and time last updated
master_server_id
NUMBER
Master server ID
parent_schedule_id
NUMBER
foreign key into apt_v_schedules_2 to locate the parent of this schedule if any
recurrence_counter
NUMBER
Number of recurrences
recurrence_interval
STRING
Recurence interval
schedule_id
NUMBER
Primary key of apt_v_avm_schedules
schedule_name
STRING
Name of this schedule
start_date
DATE
Start Date
start_duration
DATE
Duration
time_zone_id
STRING
Time zone of the server
total_duration
DATE
Total schedule duration