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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 | Foreign key into apt_v_avm_retention_policies |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |