Storage Viewer for Backup Database Views > apt_v_avm_activities
  
Version 10.0.01
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