avm_domain_name

Full domain of the client on this activity

avm_group_id

Foreign key into the apt_v_groups view

backup_label

The user-assigned backup label for this activity

backup_nbr

The backup number for this activity

client_id

Client ID number

client_name

Client Name

dataset_id

Foreign key into the apt_v_datasets view

dataset_name

Name of the dataset used in the activity

effective_expiration_date

The expiration date of this activity as a string

effective_path

The effective dataset used in the activity

encryption_name

Name of encryption method used

error_code

Last error code generated by this activity

excluded_kb

Number of bytes excluded

expiration_date

Expiration date of this activity

expiration_text

Text of the expiration date - may also be NEVER

group_name

Name of the group used in this activity - applies to group-based backups only

gsan_system_id

System-generated Avamar system ID

gsan_system_name

User-supplied Avamar system name

initiated_by

Name of the user who initiated this backup - applies to on-demand backups only

is_encrypt_server_auth

True if mcserver.xml encrypt_server_authenticate preference is set true. Otherwise, false

is_override_dataset

Is the dataset used an override? Y/N

is_override_ret_policy

Did the activity override the group retention policy? Y/N

job_id

Primary key of the underlying table

modified_kb

Number of bytes modified

modified_not_sent_kb

Number of non-unique bytes modified

modified_sent_kb

Number of unique bytes modified

nbr_files_skipped

Number of files skipped due to errors

new_kb

Number of new bytes

overhead_kb

Number of bytes of system overhead

plugin_id

Foreign key into the apt_v_plugin_catalog view

recorded_date

Date this activity was recorded in MCS

retention_policy_id

Foreign key into the apt_v_retention_policies

scanned_kb

Number of bytes scanned for de-duplication

schedule_end_date

Scheduled end date

schedule_id

Foreign key into the apt_v_schedules_2 view

schedule_name

Name of the schedule used in this activity - applies to group-based backups only

schedule_start_date

Scheduled start date

server_id

Server ID number

session_id

The system-generated session id for this activity

skipped_kb

Number of bytes skipped due to errors

status_code

Last status code generated by this activity

status_code_summary

Text of the status code

vendor_job_type

Type of activity

work_order_name

Work order for this activity

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

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

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

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

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

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

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

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

elapsed_seconds

NUMBER

Elapsed time in seconds

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

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

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

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

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

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

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

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

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

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

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